Total count for next years

[GrimReaperX]

Hello,

I would like to show Total Count for the next 5 years from today when I select certain year in the year slicer. It will be dynamic and If i select year 2024 it should show total count for next 5 years starting from 2024. If i do not select any date, it should show total count for next 5 years from today.

I tried some formulas however result was same as the total count.

Thank you very much in advance

[v-xinruzhu-msft · Accepted solution]

Hi @GrimReaperX 

You can refer to the following example.

The slicer table

The data table

Create a measure

Measure = IF(ISFILTERED('Table (2)'[Column1]),CALCULATE(SUM('Table'[Column2]),FILTER('Table','Table'[Column1]>SELECTEDVALUE('Table (2)'[Column1])&&'Table'[Column1]<=SELECTEDVALUE('Table (2)'[Column1])+5)),CALCULATE(SUM('Table'[Column2]),FILTER('Table','Table'[Column1]>YEAR(TODAY())&&'Table'[Column1]<=YEAR(TODAY())+5)))

Then put the column of slicer table to the slicer and create a table visual and put the data of data table and measure  to the visual.

Output

When the silicer is not chosen.

When the slicer is chosen

Best Regards!

Yolo Zhu

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