Download Files: ZippedTextFiles: excelisfun.net/files/1659TextFiles.zip Finished Power BI Desktop File: excelisfun.net/files/CrossTabReportEMT1659.pbix
Download Power BI Desktop :
Microsoft Download Page: microsoft.com/en-us/download/details.aspx?id=45331
• When you want to update each month, you have to re-download and re-install.
Microsoft Windows Store: powerbi.microsoft.com/en-us/desktop/
• This download will automatically update each month.
In this video learn how to build a Data Model in Power BI Desktop to create a Cross Tab Report with six conditions. Learn how to use Power Query to import Text Data From a Folder and how to use Power Query to make a Date Table. Learn how to create a DAX Measure to count hours less than zero using the COUNTROWS and CALCULATE Function. Learn how to make a report with the Martix Visualtization and how to publish the report top powerbi.com.
Topics:
1. (00:01) Introduction.
2. (00:29) Download Power BI Desktop
3. (00:45) Data we need to import
4. (01:05) Open and Save Power BI Desktop
5. (01:19) look back to last three videos and compare to this video
6. (01:47) Power Query to Import Text Data From Folder.
7. (04:25) Create Data Table using Power Query. Power Query M Code to build a Date Table.
8. (10:47) Build Relationship between Date Table and Fact Table.
9. (11:20) Sort Month Name Column.
10. (11:36) Hide Month Number in Report View.
11. (11:43) Matrix Visualization Report.
12. (13:06) DAX Function COUNTROWS.
13. (14:01) Learn how Filter Context works.
14. (14:54) DAX Function CALCULATE to change the Filter Context.
15. (16:21) Publish Report to Power BI Online so it can be viewed on any device.
16. (17:11) Summary of the tasks in video.
17. (17:34) Change Folder Location.
18. (18:07) Summary and End Video Links.

• Power BI Matrix Report, DAX Measures, Power Query M Code Date Table, Filter Context & More! EMT 1659 ( Download)
• PP03: DAX Iterator Functions, Measures vs Added Columns, Filter Context, Internal & external filters ( Download)
• 23.How DAX computes filtered aggregates 1 ( Download)
• Power BI - Table and matrix ( Download)
• How to use Power BI Visual Level filter and Add today's date filter on the data ( Download)
• Power BI Context Transition with Calculate | Power BI Analytics (Power BI Training) ( Download)
• Power BI Desktop Introduction #3 - Data Model & Creating a Date Table ( Download)
• How to create a table to a matrix in Power BI | Power BI Matrix | Power BI Tutorial ( Download)
• Power BI row context - 10 (Power BI Training) ( Download)
• 7 hidden features in Power BI! ( Download)
• Power BI Create Pivot and Enable Slicer | Matrix in Power BI | Slicer in Power BI ( Download)
• Filter Context in DAX ( Download)
• Free Advanced Data Analysis & BI Course at YouTube (MSPTDA) ( Download)
• Power BI + Excel = Great DAX!!! ( Download)
• Tips on using the Matrix Visual in Microsoft Power BI ( Download)