Skip to main content
AmigoFish

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.

Watch on YouTube

Not rated yet

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,…

Back to excelisfun · Report a problem