In this tutorial, I showcase a simple technique to visually showcase cumulative totals only up to a specific date.
Sometimes, if this is not done, you will see charts and visuals that look cluttered. These make it far cleaner visually and better for the consumer to understand what is happening.
Enjoy reviewing these DAX formulas and techniques and make sure to use these yourself when you can.
Good luck.
Sam
**** Video Details ****
2:20 showing cumulative totals up to the last sales date
4:47 getting better visuals in Power BI
**** Learning Power BI? ****
FREE COURSE Ultimate Beginners Guide To Power BI http://portal.enterprisedna.co/p/ulti...
FREE COURSE Ultimate Beginners Guide To DAX http://portal.enterprisedna.co/p/ulti...
FREE 60 Page DAX Reference Guide Download https://enterprisedna.co/daxformula...
FREE Power BI Resources http://enterprisedna.co/powerbireso...
Enterprise DNA Online http://www.enterprisedna.co/
Enterprise DNA Membership https://enterprisedna.co/membership
Enterprise DNA Events https://enterprisedna.co/enterprised...
**** Related Links ****
Cumulative Totals Based On Monthly Average Results In Power BI https://blog.enterprisedna.co/calcula...
Showing Cumulative Results Vs Targets Only To Last Sales Date In Power BI https://blog.enterprisedna.co/showing...
Compare Multiple Metrics Cumulatively In Power BI Using Advanced DAX https://blog.enterprisedna.co/compare...
**** Related Course Modules ****
Learning Summit Series http://portal.enterprisedna.co/p/lear...
Advanced DAX Combinations http://portal.enterprisedna.co/p/adva...
Solving Analytical Scenarios With Power BI & DAX http://portal.enterprisedna.co/p/solv...
**** Related Support Forum Posts ****
Donations As At A Specific Date https://forum.enterprisedna.co/t/dona...
Cumulative Calculations From A Specific Date And Normal Cumulative On The Same Page https://forum.enterprisedna.co/t/cumu...
MTD, YTD Showing Total As To Date Value (December) But Not As Sum Of All MTD, YTD https://forum.enterprisedna.co/t/mtd...
For more cumulative totals only up to a specific date support queries to review see here…. https://forum.enterprisedna.co/search...