Forum Discussion
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 da...
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
Hi amitchandak would love some more help if you could please 🙂