Frequent Visitor
Posts: 4
Registered: ‎07-12-2017

Filter a table based on a slicer

[ Edited ]

Hello Everybody !


I'm new to power BI and so i'm trying to filter a table based on a slicer 

I have a [Date added] for the data and i want to select only rows where the date difference between [date added] and today

Here's the dax query that i came up with so far : 

Filter= IF(VALUE(DATEDIFF('Extraction devis organisation'[Date added].[Date];TODAY();DAY)) >= MIN(Slicer[SLICER Selection]) ; "O";"N")


and on the filter panel i select only rows with "O"


The slicer table has no relationships with other tables and yet it doesn't work


Does anyone have a clue why 


Thany you