Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
Hi Experts
I am trying to filter my data using a month slicer - however it onlu gives me the values fro Mar 21 and the slicer returns back zero values of all other periods in 2021.
Sample file
https://www.dropbox.com/s/xcuyv21vuz9vg51/test_.pbix?dl=0
Solved! Go to Solution.
@Anonymous , Try
lastest month = month(maxx(allselected('Date'), 'Date'[Date])) -1
or
lastest month = month(maxx(allselected('DimDate'), 'DimDate'[Date]))
let rest be the same as of now
Hi, @Anonymous
Please try to change your filter like below.
Hi, My name is Jihwan Kim.
If this post helps, then please consider accept it as the solution to help other members find it faster.
If this post helps, then please consider accepting it as the solution to help other members find it faster, and give a big thumbs up.
Hi Kim - Not working giving me a constant value..
@Anonymous , In all you Measures in the table you have filtered on lastest month , which based on today().
Ideally it should be maxx(allselected('Date'), 'Date'[Date]), if you want slicer to work
Can you kindly post the full measure here and i should be able to do the rest.
Thanks
@Anonymous , Try
lastest month = month(maxx(allselected('Date'), 'Date'[Date])) -1
or
lastest month = month(maxx(allselected('DimDate'), 'DimDate'[Date]))
let rest be the same as of now
thank you amit
User | Count |
---|---|
98 | |
90 | |
82 | |
73 | |
67 |
User | Count |
---|---|
115 | |
102 | |
98 | |
71 | |
66 |