Forum Discussion

PatrickByGecko's avatar
PatrickByGecko
Helper V
8 months ago
Solved

cumulative suite through time

Hi everybody, Underneath I have a suite of quantities each month, I mean => 4,3,2,1 etc.. . I would like to get the cumulative suite of theses quantities, I mean => 4, 7, 9, 10 etc.. How can I do ...
Need Help
  • Jihwan_Kim's avatar
    Jihwan_Kim
    8 months ago

    Hi,

    One of ways to achieve this is to use visual calculation.

    I tried to create a sample pbix file like below, and please check the below image and the attached pbix file.

     

     

  • v-venuppu's avatar
    v-venuppu
    8 months ago

    Hi PatrickByGecko ,

    May I ask if you have resolved this issue? Please let us know if you have any further issues, we are happy to help.

    Thank you.

cengizhanarslan's avatar
cengizhanarslan
Super User
8 months ago

Hi, if you want to have cumulative over time in total try below:

Cumulative Quantity =
VAR CurrentDate =
    MAX ( 'Calendar'[Date] )
RETURN
CALCULATE (
    [Quantity],
    FILTER (
        ALL ( 'Calendar'[Date] ),
        'Calendar'[Date] <= CurrentDate
    )
)

 If you want it to be reset each year then below:

Cumulative Quantity YTD =
TOTALYTD(
    [Quantity],
    'Calendar'[Date]
)