Download Excel File: https://people.highline.edu/mgirvin/YouTubeExcelIsFun/EMT1561.xlsx
Download Start Power BI Desktop: https://people.highline.edu/mgirvin/YouTubeExcelIsFun/EMT1561Start.pbix
Download Finished Power BI Desktop File: https://people.highline.edu/mgirvin/YouTubeExcelIsFun/EMT1561Finished.pbix
Entire page with all Excel Files for All Videos: http://people.highline.edu/mgirvin/excelisfun.htm

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

Read More

Share This