Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago
Solved

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 ...
Need Help
  • amitchandak's avatar
    amitchandak
    5 years ago

    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)

amitchandak's avatar
amitchandak
Super User
5 years ago

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)