Рет қаралды 8,369
Download Excel File: excelisfun.net...
Download Start Power BI Desktop: excelisfun.net...
Download Finished Power BI Desktop File: excelisfun.net...
Entire page with all Excel Files for All Videos: excelisfun.net...
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