Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 years ago

Filter 2 Relative Dates

Hi,

 

I'm looking to filter a visual with 2 relative dates (see below). However, if I apply this to the visual it applies AND logic but I want OR logic, i.e., filter if the date is in the last 7 days OR in the next 30 days. I'm thinking this isn't out of the box and I'll need DAX but aren't sure what that would be.

 

Thanks! 🙂

 

 

3 Replies

  • amitchandak's avatar
    amitchandak
    Super User
    3 years ago

    Anonymous , Relative date is based on today. You can do that by creating a measure based on today without using a slicer. You can use this measure in the visual or visual level filter

     

     

    This Month Today =
    var _min = today() -7
    var _max =today()+30
    return CALCULATE([Net], FILTER('Date','Date'[Date] >=_min && 'Date'[Date] <= _max))

     

    Net is measured and net's table is joined with date table 

     

     

    refer https://medium.com/chandakamit/cheat-sheet-power-bi-time-intelligence-formulas-using-today-654f26e27304

    • Anonymous's avatar
      Anonymous
      Not applicable
      3 years ago

      Hi - what does Net refer to? And do I need to create the date table - where does that come from?

    • Anonymous's avatar
      Anonymous
      Not applicable
      3 years ago

      Hi amitchandak would love some more help if you could please 🙂