See how to:
(00:08) Problem Set up
(00:49) Use Filter Feature rather than Table Feature to get Table into Power Query
(01:30) Unpivot Cross Tabulated Table into Proper Data Set
(03:12) Unpivot Only Two Columns in table to create Proper Data Set.
(04:48) Sort is different than in Excel.
DESCRIPTION See how to: (00:08) Problem Set up (01:48) Power Query it import table 3 times, each time deleting certain columns, then Append the 3 tables, Sort and Load To Table. (04:57) Test with New [Read More >>>]
DESCRIPTION In this video learn about how to build Excel Dashboard based on Data Model and see first DAX Measure (Formula): (00:22) Introduction (02:43) Power Query to Clean, Transform & Import Text Files (From Folder [Read More >>>]
DESCRIPTION See how to import multiple CSV files from a folder and refresh Query and PivotTable when new files are in folder: (00:11) Problem Setup (00:52) Power Query Import From Folder (01:15) Edit Query and [Read More >>>]
EXCEL is a registered trademark of the Microsoft Corporation. MasterExcel is not sponsored by nor affiliated in any way with the Microsoft Corporation.
Leave a Reply
You must be logged in to post a comment.