Deprecated: Creation of dynamic property ternplugin\youtube_video::$post is deprecated in /home1/cassanoc/public_html/bonbonsguide.com/wp/wp-content/plugins/automatic-video-posts/vendor/ternstyle/plugin/src/class/youtube_video.php on line 64

Two Date Columns in Fact Table? How To Create Report? DAX, Power Query, Excel? 365 MECS Class 22

Posted on by Annie D

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

Further Help

I offer limited consulting services to potentially assist you with data challenges, whether it's designing a complex Excel formula, writing a macro or building a whole new process for data capture, modeling and analysis.  Contact me if you have a need.

ExcelIsFunThu, June 22, 2023 2:12pm