cancel
Showing results for
Did you mean:

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Helper II

## Ho to calculate the cumulative of a mesure, month by month

hello,

I have a measure that calculates a sum of a column of the sales history table according to the month and the year chosen on two slicers month and year (doing conditions based on choosen month and year in a slicer) I want to make another mesure which makes me the accumulation of the first mesure when I choose several months knowing that the sum must be = the sum of the first measure month by month between a minimum month chosen and a maximum month chosen since on the month filter I have the possibility of choosing several months how can i do that?
it's as if I have to make a sum on the result of a function with entry of each function one month among the months chosen on the slicer total = function(minchosenmonth,chosenyear)+function(month2,chosenyear) ... function(maxchosenmonth,chosenyear

simple sum gives me wrong value

Thank you for any help

1 ACCEPTED SOLUTION
Super User

If the slicer is choosing a range of dates from your Date table then you could do

``````Total =
var summaryTable = ADDCOLUMNS( VALUES('Date'[Year month]), "@val", [Existing measure])
return SUMX( summaryTable, [@val])``````
4 REPLIES 4
Super User

If the slicer is choosing a range of dates from your Date table then you could do

``````Total =
var summaryTable = ADDCOLUMNS( VALUES('Date'[Year month]), "@val", [Existing measure])
return SUMX( summaryTable, [@val])``````
Helper II

Hello,

It works! thank you very much !

Super User

@ouafaa ,  Not very clear

You can try a measure like

Cumm Sales = CALCULATE(SUM(Sales[Sales Amount]),filter(allselected('Date'),'Date'[date] <=max('Date'[date])))

If this does not help
Can you share sample data and sample output in table format? Or a sample pbix after removing sensitive data.

Helper II

Hello,

Thank you for your help but it does not work.

My PBIX is too large and contains sensitive data, I will create a sample one juste like an exemple or juste copy some excpected results and will share it so you can see what i'm trying to do

Thank you again

Announcements

#### Europe’s largest Microsoft Fabric Community Conference

Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.

#### Power BI Monthly Update - August 2024

Check out the August 2024 Power BI update to learn about new features.

#### Fabric Community Update - August 2024

Find out what's new and trending in the Fabric Community.

Top Solution Authors
Top Kudoed Authors