Download file for video: http://bit.ly/31jt5LE
Class web site with individual file downloads: http://bit.ly/2GF25Ni
pdf notes for Video: http://bit.ly/31pQafN
In this video learn about how to create a Side-By-Side and Cross Tabulated Report for Total Sales for Order Date and Ship Date using SUMIFS Worksheet function, Mixed Cell References and the EOMONTH Function. This is the classic Two Dates in a Fact Table Problem. MSPTDA #29 we solve it with Worksheet formulas and in MSPTDA #30 we use the Data Model and DAX formulas in both Excel Power Pivot and Power BI Desktop.
Topics:
1. (00:15) Introduction & look at Data Modeling Problem when we have two dates in a Fact Table.
2. (01:22) Side-By-Side Report for Total Sales for Order Date and Ship Date using SUMIFS and EOMONTH with Mixed Cell References using two conditions or criteria.
3. (04:22) Custom Number Formatting for both reports so we have useful labels in our report
4. (06:41) Cross Tabulated Report for Total Sales for Order Date and Ship Date using SUMIFS and EOMONTH with Mixed Cell References, and four conditions and criteria.
5. (09:37) Conclusion
Comprehensive Microsoft Power Tools for Data Analysis Class, BI 348, taught by Mike Girvin, Excel MVP and Highline College Professor.