Relative DAX date filter

[Anonymous]

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())

[amitchandak · Accepted solution]

@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)