Download Zipped Folder with All Files: https:\/\/excelisfun.net\/files\/22-M365ExcelClassVideoFiles.zip<\/a>
\nDownload pdf notes: https:\/\/excelisfun.net\/files\/22-M365ExcelClassDAX.pdf<\/a>
\nThis 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.
\nThis 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<\/a>
\nThis video covers.
\n1. (00:00) Introduction and video topics
\n2. (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.
\n3. (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
\n4. (09:46) Data Model Solution with the USERELATIONAHIP DAX function to create a side-by-side report.
\n5. (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.
\n6. (17:39) Video Summary and Conclusions
\n7. (17:59) Closing and Video Links<\/p>\n

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\/<\/a> . Artist: http:\/\/audionautix.com\/<\/a><\/p>\n

#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<\/p>\n","protected":false},"excerpt":{"rendered":"

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 […]<\/p>\n","protected":false},"author":3,"featured_media":5906,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"jetpack_post_was_ever_published":false,"_jetpack_newsletter_access":"","_jetpack_dont_email_post_to_subs":false,"_jetpack_newsletter_tier_id":0,"_jetpack_memberships_contains_paywalled_content":false,"_jetpack_memberships_contains_paid_content":false,"footnotes":""},"categories":[101,21],"tags":[],"jetpack_featured_media_url":"https:\/\/i0.wp.com\/bonbonsguide.com\/wp\/wp-content\/uploads\/2023\/06\/h5_qxfT2Prg.jpg?fit=480%2C360&ssl=1","jetpack_sharing_enabled":true,"jetpack_shortlink":"https:\/\/wp.me\/p7QB1z-1xe","_links":{"self":[{"href":"https:\/\/bonbonsguide.com\/wp\/wp-json\/wp\/v2\/posts\/5904"}],"collection":[{"href":"https:\/\/bonbonsguide.com\/wp\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/bonbonsguide.com\/wp\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/bonbonsguide.com\/wp\/wp-json\/wp\/v2\/users\/3"}],"replies":[{"embeddable":true,"href":"https:\/\/bonbonsguide.com\/wp\/wp-json\/wp\/v2\/comments?post=5904"}],"version-history":[{"count":0,"href":"https:\/\/bonbonsguide.com\/wp\/wp-json\/wp\/v2\/posts\/5904\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/bonbonsguide.com\/wp\/wp-json\/wp\/v2\/media\/5906"}],"wp:attachment":[{"href":"https:\/\/bonbonsguide.com\/wp\/wp-json\/wp\/v2\/media?parent=5904"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/bonbonsguide.com\/wp\/wp-json\/wp\/v2\/categories?post=5904"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/bonbonsguide.com\/wp\/wp-json\/wp\/v2\/tags?post=5904"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}