Forum Discussion
Show next 5 years data.
Hi.
I want to display next 5 years data according to the slicer selection.
For example, if I select 2016 in the slicer then my matrix should show Total Sales for next 5 years viz(2017,2018,2019,2020,2021).
Any help would be appreciated.
Regards,
Ashlesha
Hi Anonymous ,
According to your description, I did the following tests:
M_ = VAR a = YEAR ( SELECTEDVALUE ( 'Table'[Date] ) ) RETURN CALCULATE ( SUM ( 'Table'[Value] ), FILTER ( ALL ( 'Table' ), YEAR ( 'Table'[Date] ) > a && YEAR ( 'Table'[Date] ) < a + 5 ) )
If the problem is still not resolved, please provide detailed error information and let me know immediately. Looking forward to your reply.
Best Regards,
Henry
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
2 Replies
HI Anonymous
You need to use a measure and date table; I don't know how your data looks like, but try something like this:
measure=
Var _SD=selectedvalue[Date column form date table in the slicer])
Var _SD5 = _SD+5
return
calculate(sum([Sales],filter(table, [date]>=_SD&&[date]<=_SD5))If this post helps, please consider accepting it as the solution to help the other members find it more quickly.
Appreciate your Kudos!!
Hi Anonymous ,
According to your description, I did the following tests:
M_ = VAR a = YEAR ( SELECTEDVALUE ( 'Table'[Date] ) ) RETURN CALCULATE ( SUM ( 'Table'[Value] ), FILTER ( ALL ( 'Table' ), YEAR ( 'Table'[Date] ) > a && YEAR ( 'Table'[Date] ) < a + 5 ) )
If the problem is still not resolved, please provide detailed error information and let me know immediately. Looking forward to your reply.
Best Regards,
Henry
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
