Dynamically Compare Monthly Information Cumulatively in Power BI w/ DAX

Learn how to use this great technique where you can cumulatively compare information over different months that will showcase diverging trends in your data.

***** Video Details *****
0:45 creating total sales measure
1:06 dragging in MonthInCalendar
1:51 using a time intelligence function
3:39 calculating cumulatively
5:50 turning the table into a visualization
6:50 looking at other dimensions

***** Learning Power BI? *****
FREE COURSE - Ultimate Beginners Guide To Power BI - http://portal.enterprisedna.co/p/ultimate-beginners-guide-to-power-bi
FREE COURSE - Ultimate Beginners Guide To DAX - http://portal.enterprisedna.co/p/ultimate-beginners-guide-to-dax
FREE - 60 Page DAX Reference Guide Download - https://enterprisedna.co/dax-formula-reference-guide-download
FREE - Power BI Resources - http://enterprisedna.co/power-bi-resources
Enterprise DNA Membership - https://enterprisedna.co/membership
Enterprise DNA Online - http://portal.enterprisedna.co/
Enterprise DNA Events - https://enterprisedna.co/enterprise-dna-events-page/

***** Related Links *****
Showing Actual Results vs Targets Only To Last Sales Date In Power BI - https://blog.enterprisedna.co/2019/07/31/showing-actual-results-vs-targets-only-to-last-sales-date-in-power-bi/
Calculate A Reverse Cumulative Total In Power BI Using DAX - https://blog.enterprisedna.co/2019/07/29/calculate-a-reverse-cumulative-total-in-power-bi-using-dax/
Cumulative Totals In Power BI Without Any Dates – Advanced DAX - https://blog.enterprisedna.co/2018/10/05/create-cumulative-totals-no-date-no-index-advanced-dax-techniques-in-power-bi/

***** Related Course Modules *****
Time Intelligence Calculations - http://portal.enterprisedna.co/p/time-intelligence-calculations
Mastering DAX Calculations - http://portal.enterprisedna.co/p/mastering-dax-calculations
Budgeting & Forecasting - http://portal.enterprisedna.co/p/budgeting-and-forecasting

***** Related Support Forum Posts *****
Cumulative Total VS Cumulative Total LY - Cleaning Visual - https://forum.enterprisedna.co/t/cumulative-total-vs-cumulative-total-ly-cleaning-visual/116
Cumulative Total Question - https://forum.enterprisedna.co/t/cumulative-total-question/1054
Cumulative Total This Year vs Last - https://forum.enterprisedna.co/t/cumulative-total-this-year-vs-last/2713
For more cumulative total support queries to review see here -
https://forum.enterprisedna.co/search?q=cumulative%20total

Видео Dynamically Compare Monthly Information Cumulatively in Power BI w/ DAX канала Enterprise DNA