Forum Discussion

ringovski's avatar
ringovski
Icon for Helper II rankHelper II
4 years ago
Solved

Cumulative Total in Card

Hi All, I would like to show the cumulative total waste in card for the month selected in the slicer. I already the cumulative(running total) working in a table, but in a card it only shows the curr...
Help appreciated
  • v-xiaosun-msft's avatar
    v-xiaosun-msft
    4 years ago

    Hi ringovski ,

    According to your description, here is my solution.

    I created a sample directly from the “Month Short Name” and “Total Waste” you gave.

    Create a DATE table and put it into slicer. Note that the relationship between the two dates should be established.

     

    Create a measure and put it into a card.

    Numeric Value =
CALCULATE (
    SUM ( 'Table'[Total Waste] ),
    DATESYTD ( 'Table'[Month Short Name] )
)

    Select the month you need and you will get the final output:

     

    Best Regards,
    Community Support Team _ xiaosun

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

v-xiaosun-msft's avatar
v-xiaosun-msft
Icon for Community Support rankCommunity Support
4 years ago

Hi ringovski ,

According to your description, here is my solution.

I created a sample directly from the “Month Short Name” and “Total Waste” you gave.

Create a DATE table and put it into slicer. Note that the relationship between the two dates should be established.

 

Create a measure and put it into a card.

Numeric Value =
CALCULATE (
    SUM ( 'Table'[Total Waste] ),
    DATESYTD ( 'Table'[Month Short Name] )
)

Select the month you need and you will get the final output:

 

Best Regards,
Community Support Team _ xiaosun

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.