Forum Discussion

Syndicate_Admin's avatar
Syndicate_Admin
Icon for Administrator rankAdministrator
3 years ago
Solved

Cumulative values with start and end date

Hello I would like to achieve the following. Have two date targeting filters such as these: Select year and a final date, and that I will get the accumulated amount for each month o...
  • v-yalanwu-msft's avatar
    v-yalanwu-msft
    3 years ago

    Hi, Syndicate_Admin ;

    You could create a measure as follow:

    Measure = 
CALCULATE(SUM('Table'[value]),FILTER(ALLSELECTED('Table'),[Date]<=MAX('Table'[Date])))

    The final show:


    Best Regards,
    Community Support Team _ Yalan Wu
    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

v-yalanwu-msft's avatar
v-yalanwu-msft
Icon for Community Support rankCommunity Support
3 years ago

Hi, Syndicate_Admin ;

You could create a measure as follow:

Measure = 
CALCULATE(SUM('Table'[value]),FILTER(ALLSELECTED('Table'),[Date]<=MAX('Table'[Date])))

The final show:


Best Regards,
Community Support Team _ Yalan Wu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.