Deprecated: Creation of dynamic property CF\WordPress\DataStore::$logger is deprecated in /home1/cassanoc/public_html/bonbonsguide.com/wp/wp-content/plugins/cloudflare/src/WordPress/DataStore.php on line 23
Deprecated: Creation of dynamic property CF\WordPress\Proxy::$pluginAPI is deprecated in /home1/cassanoc/public_html/bonbonsguide.com/wp/wp-content/plugins/cloudflare/src/WordPress/Proxy.php on line 31
Deprecated: file_get_contents(): Passing null to parameter #2 ($use_include_path) of type bool is deprecated in /home1/cassanoc/public_html/bonbonsguide.com/wp/wp-content/plugins/codelights-shortcodes-and-widgets/codelights.php on line 20
Warning: session_start(): Session cannot be started after headers have already been sent in /home1/cassanoc/public_html/bonbonsguide.com/wp/wp-content/plugins/automatic-video-posts/vendor/ternstyle/wordpress/src/class/wordpress.php on line 53
Warning: Cannot modify header information - headers already sent by (output started at /home1/cassanoc/public_html/bonbonsguide.com/wp/wp-content/plugins/cloudflare/src/WordPress/DataStore.php:23) in /home1/cassanoc/public_html/bonbonsguide.com/wp/wp-includes/rest-api/class-wp-rest-server.php on line 1831
Warning: Cannot modify header information - headers already sent by (output started at /home1/cassanoc/public_html/bonbonsguide.com/wp/wp-content/plugins/cloudflare/src/WordPress/DataStore.php:23) in /home1/cassanoc/public_html/bonbonsguide.com/wp/wp-includes/rest-api/class-wp-rest-server.php on line 1831
Warning: Cannot modify header information - headers already sent by (output started at /home1/cassanoc/public_html/bonbonsguide.com/wp/wp-content/plugins/cloudflare/src/WordPress/DataStore.php:23) in /home1/cassanoc/public_html/bonbonsguide.com/wp/wp-includes/rest-api/class-wp-rest-server.php on line 1831
Warning: Cannot modify header information - headers already sent by (output started at /home1/cassanoc/public_html/bonbonsguide.com/wp/wp-content/plugins/cloudflare/src/WordPress/DataStore.php:23) in /home1/cassanoc/public_html/bonbonsguide.com/wp/wp-includes/rest-api/class-wp-rest-server.php on line 1831
Warning: Cannot modify header information - headers already sent by (output started at /home1/cassanoc/public_html/bonbonsguide.com/wp/wp-content/plugins/cloudflare/src/WordPress/DataStore.php:23) in /home1/cassanoc/public_html/bonbonsguide.com/wp/wp-includes/rest-api/class-wp-rest-server.php on line 1831
Warning: Cannot modify header information - headers already sent by (output started at /home1/cassanoc/public_html/bonbonsguide.com/wp/wp-content/plugins/cloudflare/src/WordPress/DataStore.php:23) in /home1/cassanoc/public_html/bonbonsguide.com/wp/wp-includes/rest-api/class-wp-rest-server.php on line 1831
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
Warning: Cannot modify header information - headers already sent by (output started at /home1/cassanoc/public_html/bonbonsguide.com/wp/wp-content/plugins/cloudflare/src/WordPress/DataStore.php:23) in /home1/cassanoc/public_html/bonbonsguide.com/wp/wp-includes/rest-api/class-wp-rest-server.php on line 1831
Warning: Cannot modify header information - headers already sent by (output started at /home1/cassanoc/public_html/bonbonsguide.com/wp/wp-content/plugins/cloudflare/src/WordPress/DataStore.php:23) in /home1/cassanoc/public_html/bonbonsguide.com/wp/wp-includes/rest-api/class-wp-rest-server.php on line 1831
{"id":1344,"date":"2019-06-14T12:44:26","date_gmt":"2019-06-14T19:44:26","guid":{"rendered":"https:\/\/bonbonsguide.com\/wp\/?p=1344"},"modified":"2019-06-14T12:44:26","modified_gmt":"2019-06-14T19:44:26","slug":"msptda-30-order-ship-dates-in-fact-table-dax-formulas-and-data-modeling-to-create-reports","status":"publish","type":"post","link":"https:\/\/bonbonsguide.com\/wp\/blog\/2019\/06\/msptda-30-order-ship-dates-in-fact-table-dax-formulas-and-data-modeling-to-create-reports\/","title":{"rendered":"MSPTDA 30: Order & Ship Dates in Fact Table: DAX Formulas and Data Modeling to Create Reports"},"content":{"rendered":"Download files for videos 29 & 39: http:\/\/bit.ly\/2IDWV56
\nClass web site with individual file downloads: http:\/\/bit.ly\/2GF25Ni
\npdf notes for Videos 29 & 30: http:\/\/bit.ly\/31pQafN<\/p>\n
In this video learn about how to create a Side By Side Report and a Cross Tabulated Report for Ordered Sales and Shipped Sales when you have two Date Columns in the Fact Table. Learn about Inactive Relationships, the USERELATIONSHIP DAX Function, and how to use Two Date Dimension Tables in a Data Model.
\nLearn methods that work in both Excel Power Pivot or Power BI Desktop.
\nTopics:
\n1. (00:15) Introduction & look at Data Modeling Problem
\n2. (02:00) Create Active and Inactive Relationship.
\n3. (03:43) Use the USERELATIONSHIP DAX Function inside the CALCULATE Function to calculate Shipped Sales.
\n4. (05:07) Create Side-By-Side Report that uses Two Measures and One Date Dimension Table using Excel Power Pivot.
\n5. (05:34) Create Two Date Dimension Tables using Power Query, then create relationships in Power BI Desktop.
\n6. (08:48) Create Cross Tabulated Report that uses One Measure and Two Date Dimension Tables using the Martix Visualization in Power BI.
\n7. (09:36) Conclusion
\nComprehensive Microsoft Power Tools for Data Analysis Class, BI 348, taught by Mike Girvin, Excel MVP and Highline College Professor.<\/p>\n