Forum Discussion

PKPK90's avatar
PKPK90
Icon for Helper I rankHelper I
3 years ago

Dynamic date filter based on slicer selection

Hi, what I want to change in my code is to use slicer selected value to filter OrderDate, right now I have date function which is hard coded.  I have created Calendar table which can be useful but ...
Prateek97's avatar
Prateek97
Icon for Resolver III rankResolver III
3 years ago

Hi,

Instead of 'FILTER(PurchaseOrders,PurchaseOrders[OrderDate]>DATE(2022,08,01))', you can try writing 
FILTER(PurchaseOrders,PurchaseOrders[OrderDate]>SELECTEDVALUE(Calendar[Date])).

 

Please mark as answer if works.