cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Anonymous
Not applicable

calculate the cumulative

Hello,
Please, I want to calculate the cumulative turnover but I have the dimenssion date (Year, quarter, month, day) ie I want to display the cumulated by exploring the data through the year then the quarter then by the month then by the day.
Here is a screenshot explaining the past of the year to the quarter by the month by clicking on the axis.
In short, I look for the DAX formula that allows me to calculate the cumulative turnover.
Thank you.

aaa.PNGmmm.PNG

2 REPLIES 2
GzRacer
Frequent Visitor

You might use the TOTALMTD function to display the cumulative using your date column as reference. It automatically creates context around the YEAR context. You only need to specify the date column used in your chart in the TOTALMTD sintaxis. Check the function sintaxis here:

https://docs.microsoft.com/en-us/dax/totalmtd-function-dax,

then try to drive through the hierarchy levels to see what happens.

You might check other similar functions as TOTALQTD or TOTALYTD.

Anonymous
Not applicable

Hello,
I tried these two formulas to calculate the cumulative turnover but it did not work. Can you calculate the cumulated?
Here is a screenshot:

Capture1.PNGCapture2.PNG

Thank you a lot

Helpful resources

Announcements
PBI User Groups

Welcome to the User Group Public Preview

Check out new user group experience and if you are a leader please create your group!

MBAS on Demand

Microsoft Business Applications Summit sessions

On-demand access to all the great content presented by the product teams and community members! #MSBizAppsSummit #CommunityRocks

Get Ready for Power BI Dev Camp

Power BI Dev Camp - June 24th

Mark your calendars and join us for our next Power BI Dev Camp!

Top Solution Authors
Top Kudoed Authors