Forum Discussion

PatrickByGecko's avatar
PatrickByGecko
Icon for Helper V rankHelper 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.

Mauro89's avatar
Mauro89
Icon for Super User rankSuper User
8 months ago

Hi PatrickByGecko,

 

You can create a cumulative total using a DAX measure. Here's a option you can try out:

Cumulative Quantity = 
CALCULATE(
    SUM('YourTable'[Quantity]),
    FILTER(
        ALLSELECTED('YourTable'[Date]),
        'YourTable'[Date] <= MAX('YourTable'[Date])
    )
)

If you're using a Date table (recommended):

Cumulative Quantity = 
CALCULATE(
    SUM('YourTable'[Quantity]),
    FILTER(
        ALLSELECTED('DateTable'[Date]),
        'DateTable'[Date] <= MAX('DateTable'[Date])
    )
)

 

Best regards!

PS: If you find this post helpful consider leaving kudos or mark it as solution