MSPTDA 26: Budget vs Actual in Power Pivot & Power BI Desktop, DAX & Data Model

Download files for videos #26 & 26: http://bit.ly/2QgUgll
Class web site with individual file downloads: http://bit.ly/2GF25Ni
pdf notes for Video #25-26: http://bit.ly/2QgUj0v

In this video learn about how create a Data Model with Relationships and DAX Measures to compare month product budgeted amounts to actual amounts. Then calculate variances.
Topics:
1. (00:24) Introduction & look at Data Modeling Problem
2. (03:20) Data Modeling with Relationships
3. (05:15) Diagram and pictures of how Filter Context works in our Data Model
4. (07:00) DAX Measures
5. (08:35) Important Data Modeling with Hiding Columns
6. (09:10) Data Model PivotTable
7. (09:50) Attributes that can NOT slice our Report
8. (10:28) Conclusion
Comprehensive Microsoft Power Tools for Data Analysis Class, BI 348, taught by Mike Girvin, Excel MVP and Highline College Professor.

View on YouTube

Further Help

I offer limited consulting services to potentially assist you with data challenges, whether it's designing a complex Excel formula, writing a macro or building a whole new process for data capture, modeling and analysis.  Contact me if you have a need.