Videos about Excel Microsoft Power BI Desktop from Mike excelisfun Girvin at Highline College.
Curated by: excelisfun (61 videos)
Download Excel File: https://excelisfun.net/files/EMT1561.xlsx Download Start Power BI Desktop: https://excelisfun.net/files/EMT1561Start.pbix Download Finished Power BI Desktop File: https://excelisfun.net/files/EMT1561Finished.pbix Entire page with all Excel Files for All Videos: https://excelisfun.net/files/ Learn how to create a DAX Calculated Colum and DAX Measure for Half Year Running Totals in Power BI Desktop or Excel Power Pivot. Topics: 1. (00:01) Introduction 2. (00:20) Files to download 3. (00:51) Overview of Data Model 4. (01:05) DAX Calculated Column for Half Year Date Table Attribute 5. (02:13) DAX & Excel Worksheet Formulas can mix Data Types – this is different than Power Query 6. (03:00) What is Filter Context? 7. (04:30) DAX Measure for Running Total using FILTER, ALL, MAX, VALUES and CALCULATE DAX Functions 8. (09:28) Format DAX Measures 9. (10:30) Conclusion