Power BI is a unified, scalable platform for self-service and enterprise business intelligence (BI). Connect to and visualize any data.

Power BI

1. BASIC TRANSFORMATIONS Date & Text Tools Time Numerical Tools GROUP-1

2. NUMERICAL TOOLS DIVIDE: CLICK ON SALES COLUMN > PRESS CTRL > CLICK ON QUANTITY COLUMN > ADD COLUMN > STANDARD > DIVIDE SUBTRACT: CLICK ON SALES COLUMN > PRESS CTRL > CLICK ON DISCOUNT COLUMN > STANDARD > SUBTRACT PERCENT OF: CLICK ON PROFIT COLUMN > ADD COLUMN > STANDARD > PERCENT OF > SELECT VALUE SALES > CLICK OKAY

3. DATE AND TIME TOOLS DATE FORMATS: ADD COLUMN > CUSTOM COLUMN > ENTER FORMULA Text.Combine ({ Date.ToText ([DDMMYY], " yyyy "), "-", Date.ToText ([DDMMYY], "%d"), "-", Date.ToText ([DDMMYY], "MMMM")}) HOURS WORKED: ADD COLUMN > CUSTOM COLUMN > ENTER FORMULA {[Logout] - [Login]} AND { Duration.TotalHours ([Subtraction])}

4. DATE AND TIME TOOLS AGE CALCULATION: CLICK ON ADD COLUMN > DATE > AGE DATE DIFFERENCE: ADD COLUMN > CUSTOM COLUMN > ENTER FORMULA Duration.Days ([Ship Date] - [Order Date])

5. TEXT TOOLS SELECT THE COLUMN > GOTO TRANSFORM TAB > NEXT CLICK ON FORMAT OPTION TRIM: - IT REMOVES ALL TRAILING & LOADING SPACES IN THE CHARACTERS. CLEAN: - IT REMOVES NON-PRINTABLE CHARACTERS.

6. CHANGING THE CASE OF THE TEXTS SELECT COLUMN > TRANSFORM TAB > CLICK ON FORMAT LOWER CASE: CONVERTS ALL THE CHARACTERS TO LOWER CASE. UPPERCASE: CONVERTS ALL CHARACTERS TO UPPER CASE. CAPITALIZE EACH WORD: CONVERTS THE FIRST LETTER OF EACH WORD TO UPPER CASE.

7. MERGING TWO / MORE COLUMNS SELECT COLUMN > TRANSFORM/ADD COLUMN > CLICK ON MERGE COLUMNS