I’m hoping there is a simple way to create a date filter using DAX rather than editing the ‘filters’ section. I can easily do it in the filters section but would prefer not to have to edit the report frequently.
An example of what I’m trying to do is to filter dates to = dates before the first day of last month. Or even dates before today.
Is there a way to DAX these two filters? I tried this measure but it didn’t work:
measure = DATESBETWEEN( Dates[Date], FIRSTDATE( Dates[Date] ), TODAY() )