Filter 2 Relative Dates

[Anonymous]

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! 🙂

[amitchandak]

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

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

[Anonymous]

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