cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Anis Helper II
Helper II

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

Re: calculate the cumulative

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.

Highlighted
Anis Helper II
Helper II

Re: calculate the cumulative

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
Announcing the New Spanish Forum

Announcing the New Spanish Forum

Do you need help in Spanish? Check out our new Spanish community section.

April 2020 Community Highlights

April 2020 Community Highlights

Info on our Super Users, MBAS content and badges, and updates to our support articles. - Read the full Community Highlights.

MBAS Gallery 2020

MBAS Gallery 2020

Watch Microsoft Business Applications Summit sessions on-demand.

Top Solution Authors
Top Kudoed Authors