Forum Discussion
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 ...
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.