Download Zipped Folder with All Files: https://excelisfun.net/files/22-M365ExcelClassVideoFiles.zip
Download pdf notes: https://excelisfun.net/files/22-M365ExcelClassDAX.pdf
This video teaches how to create reports when you have two date columns in a Fact Table Three ways: Worksheet Formulas, DAX Data Model Formulas and Power Query. Learn about how to create a Side By Side Report and a Cross Tabulated report for ordered sales and shipped sales. Learn about USERELATIONSHIP DAX Function, and how to create two date dimension tables using Power Query in the Data Model. See solutions in both Power BI Desktop and Excel Power Pivot.
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:33) Fundamental problem when you have two date columns in Fact Table and Required Reports for a Fact Table with Order and Ship Dates.
3. (01:58) Worksheet Formula Solution using SUMIFS Function for both types of reports: side-by-side ordered and shipped orders reports and cross tabulated reports
4. (09:46) Data Model Solution with the USERELATIONAHIP DAX function to create a side-by-side report.
5. (13:42) Power Query to create two data tables for a cross tabulation report that shows ordered sales and shipped sales broken apart by ordered and shipped years.
6. (17:39) Video Summary and Conclusions
7. (17:59) 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 #powerquery #Dax #powerquery #datamodel #datamodeling #datascience #datetable #dimensions #dimensionformula #order #ship #shipping