Forum Discussion
Solved
Calc based on dynamic date slicer
Hi, I have data like the below table. Date Category Product Test_result 1/1/2021 A xyz Pass 1/1/2021 A pqr Fail 1/1/2021 B abc Fail ...
nidhishah , Please find attached file after signature.
Measure 3 is the one you are looking for.
Measure and measure2 you can use for validation
Thanks @amitchandak ! For measure 2, the code is getting previous day's (max(date)-1). How can i change it to look for any "pass" within the date range in a slicer?
nidhishah , Please find the attached file. Created measure 5 and used it measure 3
Also, @amitchandak the measure is not consiering a dynamic slicer at all. If i move the slicer to pick a date range that doesnt contain the max date in the main data set, then the measures aren't working.
