Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
Hi all,
I have the below measure but it is not producing the correct result.
Solved! Go to Solution.
Hi, @yaman123
It’s wrong to get the month like 'x2>=x1-12&&x2<=x1'. If you have a month slicer, and you want to filter data in table viusal, you can put the following measure in filter pane and set 1.
measure =
IF (
DATEDIFF ( MAX ( 'Table'[FROM DATE] ), SELECTEDVALUE ( 'Date'[Date] ), MONTH ) <= 12,
1,
0
)
If it doesn’t solve your problem, please share some sample data and your desired result ,and feel free to ask me.
Best Regards
Janey Guo
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi, @yaman123
It’s wrong to get the month like 'x2>=x1-12&&x2<=x1'. If you have a month slicer, and you want to filter data in table viusal, you can put the following measure in filter pane and set 1.
measure =
IF (
DATEDIFF ( MAX ( 'Table'[FROM DATE] ), SELECTEDVALUE ( 'Date'[Date] ), MONTH ) <= 12,
1,
0
)
If it doesn’t solve your problem, please share some sample data and your desired result ,and feel free to ask me.
Best Regards
Janey Guo
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi,
Thanks for that. I think that gives me what i require
@yaman123 , refer to my video on the same topic if that can help
https://www.youtube.com/watch?v=44fGGmg9fHI
Hi,
That doesnt help.
I would like to show the past 12 months of transfers
User | Count |
---|---|
124 | |
108 | |
99 | |
62 | |
62 |
User | Count |
---|---|
137 | |
115 | |
102 | |
71 | |
61 |