Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
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
Solved! Go to Solution.
Hi @amunshi ,
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.
Hi @amunshi ,
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.
HI @amunshi
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!!
User | Count |
---|---|
139 | |
113 | |
103 | |
73 | |
63 |
User | Count |
---|---|
136 | |
125 | |
107 | |
70 | |
61 |