MSPTDA 29: Order & Ship Date in Fact Table? Side-By-Side & Cross Tab Reports with Worksheet Formulas

Download file for video:
Class web site with individual file downloads:
pdf notes for Video:

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.

Excelisfun,Highline College,Data Analysis,BI 348,Mike Girvin,Microsoft Power Tools for Data Analysis 29,MSPTDA 29,Ship and Order Date,Total Sales Ship Date,Total Sales Order Date,Cross Tabulated Report,Side By Side Report,SUMIFS Function,Adding with Criteria,Adding with Conditions in Excel,Mixed Cell References,EOMONTH Function,Total Sales by Ship and Order Date,Excel Formulas,Advanced Excel Formulas,Two Dates in Fact Table,Multiple Dates in Fact TAble,