PQ #3: Full Free Lesson in Power BI Desktop: Power Query, M, Data Model, DAX Formulas, Visualizing
From excelisfun · · 42 min

The player loads from YouTube only when you click. It uses YouTube's privacy-enhanced mode.
If the video does not play, the owner may have turned off embedding. Watch it on YouTube instead.
Description
Download Zipped folder with files: https://excelisfun.net/files/PowerQuery03Files.zip Free Power Query YouTube class from Mike excelisfun Girvin: https://www.youtube.com/playlist?list=PLrRPvpgDmw0lHaJfr4mjRcOMEYqKKvKBj Buy Mike Girvins Power Query M Code book: https://www.amazon.com/Transformative-Magic-Power-Query-Excel/dp/1615470832/ or Mr Excel: https://www.mrexcel.com/products/the-transformative-magic-of-power-query-m-code-in-excel-and-power-bi/ Download Power BI Desktop: https://powerbi.microsoft.com/en-us/desktop/ Topics: 1. (00:00) Intro Clip 2. (11:30) What is in this video 3. (01:01) Download files correctly 4. (02:25) pdf notes: Free book 5. (02:59) 5 main Power Query features that are different in Power BI Desktop from Excel 6. (04:54) Overview of video #3 project 7. (06:36) Open Start File 8. (06:43) Tour of Power BI Desktop 9. (07:21) Where is Power Query in Power BI Desktop? 10. (07:43) Import CSV Fact Table file 11. (08:10) Power Query Editor 12. (09:18) Advanced Editor 13. (09:25) let expression and how it works 14. (10:00) Close Power Query Editor without Applying query steps and loading to the Data Model 15. (10:26) What to do with this message: There are pending changes in your queries that haven’t been applied 16. (10:33) Import an Excel Table from an Excel file 17. (11:46) Import Access Database table 18. (12:36) Transform Data: Split by Dash Delimiter to get lookup values 19. (12:52) Efficient M Code: Delete repetitious query steps 20. (13:17) Split By Delimiter feature 21. (13:55) Edit M Code in Formula Bar 22. (15:10) Clean Data: Convert ISO Date to Real Serial Number Date 23. (15:31) Watch M Code change LIVE as you use the user interface 24. (15:52) Why you NEVER drag and drop data fields into Data Model Driven Visuals 25. (16:39) Intentionally forget important M Code Query step 26. (17:10) Load all 3 queries to Data Model using Close & Apply button 27. (17:24) Look at loaded tables in Table View & Model View 28. (17:58) Create Relationships 29. (19:41) Introduction to REALTED DAX lookup function 30. (20:29) DAX Measures and DAX Calculated Columns. One-Step or Two-Step DAX Measure Methods? 31. (21:32) Create DAX Calculated COLUMN 32. (22:23) Row Context and how it works in a Calculated Column and X Iterator functions such as SUMX 33. (23:27) Validate that returned lookup values are correct, discover a problem, and fix it in the Power Query Editor 34. (24:42) Use Transform Data button to open Power Query 35. (24:54) Replace feature in Power Query to fix mismatched lookup values 36. (25:17) Apply Changes to Data Model 37. (25:51) Create Net Sales DAX Calculated Column Formula 38. (26:19) Row Context 39. (28:21) DO NOT create Implicit Measures. Create Explicit Measures 40. (28:45) Create Explicit Measure with SUM function that adds values from Calculated Column (Two-Step Measure Method) 41. (29:24) What Icon looks like for Measure in Power BI 42. (29:37) Compare Preview of Grand Total for Measure in: Worksheet, Power Pivot, and Power BI 43. (29:56) Use Report View to Preview the results from a Measure using a Matrix Visualization 44. (30:57) One-Step Measure Method using the SUMX function 45. (31:05) DAX formulas: Data Analysis eXpressions 46. (31:42) Copy Calculated Column formula 47. (31:53) SUMX Function 48. (33:10) Test SUMX Measure in Report View 49. (33:24) Compare and contrast One-Step Measure to the Two-Step Measure 50. (34:17) Hide Fields that you do not want in the Reporting Area 51. (35:36) Create Dashboard visuals: Matrix and Stacked Column 52. (36:20) Filter Context and how it works with Measures 53. (38:32) How Filter Context & Row Context work together in the SUMX function 54. (39:14) Edward Tufte “No Chart Junk” Rule 55. (40:41) Interactive Visuals 56. (41:23) Summary 57. (41:53) Mike excelisfun Girvin’s Power Query M Code book 58. (42:02) Closing
This video has subtitles or audio translations a 137 languages, some of them are listed here: Afrikaans, Albanian, Amharic, Arabic, Armenian,…