Last 3 week and the cumulative since the beginning of the year

[Anonymous]

Hi,
I would like in this table to see only the last three weeks and the cumulative total from 1/1, do you know a way to remove the rest of the year from the display and keep the cumulative total value from 1/1?

Thanks.

[v-stephen-msft · Accepted solution]

Hi @Anonymous ,

First, you could create a measure below to return the cumulative total from 1/1.

cumulative since the beginning of the year = CALCULATE(SUM('Table'[Value]),FILTER(ALLSELECTED('Table'),[Date]<=MAX('Table'[Date])&&[Date]>=DATE(YEAR([Date]),1,1)))

Then set up show items  when the value is in the last 21 days.

Best Regards,

Stephen Tao

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

[Anonymous]

Hello, the three weeks must keep their value and not the cumulative, only the total must be a cumulative