Forum Discussion
Relative DAX date filter
Hi
This is most likely extremely easy but I have not found a solution for this yet. I need to config my date slicer to start from 31/08/2020 until TODAY. I tried DATESBETWEEN function but that's not working for me:
Relative date = DATESBETWEEN('mee v_MasterData_Dates'[date_bkey], 31/08/2020, TODAY())Anonymous , Typically you have to create a flag like this and use
if( [Date] >=eomonth(today(),-1) && [Date] <= today(),1,0)
or
if( [Date] >=date(2020,08,31) && [Date] <= today(),1,0)
1 Reply
Anonymous , Typically you have to create a flag like this and use
if( [Date] >=eomonth(today(),-1) && [Date] <= today(),1,0)
or
if( [Date] >=date(2020,08,31) && [Date] <= today(),1,0)