How to Excel Magic Trick 1332: Power BI Desktop: Import Multiple Excel Files & Build Dashboard #
Articles Tagged: Magic
How to Excel Magic Trick 1336: Power Query: Import Big Data Text Files: Connection Only or Data Model?
How to Excel Magic Trick 1336: Power Query: Import Big Data Text Files: Connection Only or Data Model? #
How to Excel Magic Trick 1338: Power Query: Unpivot 12 Cross Tabulated Tables into One Proper Data Set
How to Excel Magic Trick 1338: Power Query: Unpivot 12 Cross Tabulated Tables into One Proper Data Set #
How to Excel Magic Trick 1357: Power Query Function to Repeat Clean & Transform Steps for Many Excel Files
How to Excel Magic Trick 1357: Power Query Function to Repeat Clean & Transform Steps for Many Excel Files #
How to Power BI Desktop: DAX CALENDAR Function to Create Calendar / Date Table (Excel Magic Trick 1367)
How to Power BI Desktop: DAX CALENDAR Function to Create Calendar / Date Table (Excel Magic Trick 1367) #
How to Excel Magic Trick 1381: Power Query: Records In Column into Table then Two Different Top 3 Reports
How to Excel Magic Trick 1381: Power Query: Records In Column into Table then Two Different Top 3 Reports #
How to Excel Magic Trick 1382: Extract Records With Multiple Contains (Partial Text) Criteria: 4 Examples
How to Excel Magic Trick 1382: Extract Records With Multiple Contains (Partial Text) Criteria: 4 Examples #
How to Excel Magic Trick 1393 PivotTable Show Values As: % Column Total, % Parent Total, % Parent Row Total
How to Excel Magic Trick 1393 PivotTable Show Values As: % Column Total, % Parent Total, % Parent Row Total #
How to Excel Magic Trick 1396: PivotTable Show Values As: Running Total and % of Running Total (2 Examples)
How to Excel Magic Trick 1396: PivotTable Show Values As: Running Total and % of Running Total (2 Examples) #
How to Excel Magic Trick #117: Reverse 2-Way Lookup Part 1
How to Excel Magic Trick #117: Reverse 2-Way Lookup Part 1 #