Download Zipped Folder with All Files: https://excelisfun.net/files/19-M365ExcelClassVideoFiles.zip
50 pages of pdf notes: https://excelisfun.net/files/19-M365ExcelClass.pdf
This video shows how to create an actual vs. budget variance report in three ways: 1) Relationships and DAX Formulas, TREATAS Dax Function and Worksheet Formulas.
This full free Microsoft 365 Excel & Power BI class is taught by Excel MVP and Highline College Professor and can be found here: https://www.youtube.com/playlist?list=PLrRPvpgDmw0nre_bTeBfJWjrnixKoyNtW
This video covers.
1. (00:00) Introduction and video topics
2. (00:32) Budget Vs Actual Grain Problem
3. (01:13) Two Fact Tables
4. (02:20) Create Budget Vs Actual Variance Report with three methods
5. (02:20) Worksheet Formulas to Create Budget Vs Actual Variance Report
6. (05:41) Relationships and DAX Formulas to Create Budget Vs Actual Variance Report
7. (10:45) TREATAS function to simulate a relationship to create a Budget Vs Actual Variance Report
8. (14:06) Video Summary and Conclusions
9. (14:38) Closing and Video Links
Song in video: Rock Intro 3 by Audionautix is licensed under a Creative Commons Attribution 4.0 license. https://creativecommons.org/licenses/by/4.0/ . Artist: http://audionautix.com/
#excel #excelisfun #analytics #analysis #dataanalysis #dataanalytics #excelmvp #powerbi #powerquery #powerbidesktop #freeclass #freecourse #freeclasses #excelclasses #microsoftexcel #microsoftmvp #datamodel #DAX #budget #varianceanalysis #variance #relationships