Download file for video: https://people.highline.edu/mgirvin/AllClasses/348/MSPTDA/Content/DataModeling/MSPTDA-29-Worksheet-OrderShipDates.xlsx
Class web site with individual file downloads: https://people.highline.edu/mgirvin/AllClasses/348/MSPTDA/Content/DataModeling/DataModeling.htm
pdf notes for Video: https://people.highline.edu/mgirvin/AllClasses/348/MSPTDA/Content/DataModeling/029-30-MSPTDA-OrderShipDates.pdf

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.