Forum Discussion
Helper IITotal count for next years
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
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.
1 Reply
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.