Forum Discussion
Solution to turn a hard coded DAX Table OR filter into one which works with a Date Slicer
HI I’ve got a Power Bi issue relating to a periodic report where I report on the number of cases closed during a reporting period (those with a completion date) AND any which have status of New or O...
Hi misx4
Thank you for you reply and I have attempted something like that as a work-around, which filters the data for the previous month (from today) - I just wondered if it was possible to make the report more dynamicso that it would work with a slicer? Thank you
('ICC'[Date Completed] >= DATE(YEAR(TODAY()), MONTH(TODAY()) - 1, 1) &&
'ICC'[Date Completed] <= EOMONTH(TODAY(), -1))
Hi SinclairUser
You can create a measure then put it to the related visual filter
e.g
Measure =
IF (
SELECTEDVALUE ( 'ICC'[Date Completed] ) IN VALUES ( 'Slicer'[Date] ),
1,
0
)
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.