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":1575,"date":"2019-08-01T19:25:08","date_gmt":"2019-08-02T02:25:08","guid":{"rendered":"https:\/\/bonbonsguide.com\/wp\/?p=1575"},"modified":"2019-08-01T19:25:08","modified_gmt":"2019-08-02T02:25:08","slug":"show-cumulative-totals-unaffected-by-date-slicer-selection-in-power-bi","status":"publish","type":"post","link":"https:\/\/bonbonsguide.com\/wp\/blog\/2019\/08\/show-cumulative-totals-unaffected-by-date-slicer-selection-in-power-bi\/","title":{"rendered":"Show Cumulative Totals Unaffected By Date Slicer Selection In Power BI"},"content":{"rendered":"In this tutorial I run through a unique example that recently came up on the Enterprise DNA Support Forum.<\/p>\n
This example looks to solve how to showcase cumulative total comparisons, but to only have one part of the visualization affected by a slicer selection on dates.<\/p>\n
This is relevant if you wanted to showcase information or values versus forecasts but you wanted to be able to adjust the date range you are looking at for your actual values and leave your forecasts as they are.<\/p>\n
We look to use a duplicate date table to solve for this scenario.<\/p>\n
Sam<\/p>\n
***** Learning Power BI? *****<\/p>\n
FREE COURSE – Ultimate Beginners Guide To Power BI – https:\/\/ift.tt\/2Lmxubn<\/p>\n
FREE COURSE – Ultimate Beginners Guide To DAX – https:\/\/ift.tt\/2IJLvOv<\/p>\n
FREE – Power BI Resources – https:\/\/ift.tt\/2LiAVQj<\/p>\n
FREE – 60 Page DAX Reference Guide Download – https:\/\/ift.tt\/2IJLx95<\/p>\n
Learn more about Enterprise DNA – https:\/\/ift.tt\/2LiAWDR<\/p>\n
Enterprise DNA Membership – https:\/\/ift.tt\/2IJLxWD<\/p>\n