Download Excel File: https://ift.tt/2XFfRpL
Download Start Power BI Desktop: https://ift.tt/2JpVBV1
Download Finished Power BI Desktop File: https://ift.tt/2XBDUG3
Entire page with all Excel Files for All Videos: https://ift.tt/1kSFWvs
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