topic Re: Filter 2 Relative Dates in DAX Commands and Tips

Filter 2 Relative Dates

Anonymous — Tue, 27 Sep 2022 01:34:38 GMT

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

Re: Filter 2 Relative Dates

amitchandak — Tue, 27 Sep 2022 02:00:35 GMT

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

Re: Filter 2 Relative Dates

Anonymous — Tue, 27 Sep 2022 04:56:58 GMT

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

Re: Filter 2 Relative Dates

Anonymous — Thu, 29 Sep 2022 21:37:17 GMT

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