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