Forum Discussion

fmouhcine's avatar
fmouhcine
Frequent Visitor
3 years ago
Solved

Add new calculated Column for Monthly Cumulative total based on date & category

Dear Community,   I will need your support please I want to add a calculated column to an existing table where I do have: Date / Country / Volume   Below you can see an example from Excel were I ...
Need Help
Show and Tell
Tips and Tricks
fmouhcine's avatar
fmouhcine
Frequent Visitor
3 years ago

Hi amitchandak 

 

Many thanks for your reply - that works however the main objective is to have the monthly cumulative, meaning the cumulative must be rest at the beginning of each month.

So I have added additional conditions to mutch the month & the year as below:

VAR _Cumul = SUMX(
                FILTER(Table,
                [Ctry] = EARLIER([Ctry]) &&
                [Date] <= EARLIER([Date]) &&
                MONTH([Date]) = Month(EARLIER([date])) &&
                YEAR([Date]) = YEAR(EARLIER([date]))),
                [Volume]
                )
 
Cheers.
Mouhcine