Date filter using DAX

DAX DAX Calculations
1

Hi there,

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() )

Thanks,

2

Hi,

Hard to grasp what you are after, without an example.
Suggest you watch the Time Intelligence videos, that most likely will answer your question.

Paul

Enterprise%20DNA%20Expert%20-%20Small

3

http://portal.enterprisedna.co/courses/108877/lectures/2000655

Enterprise%20DNA%20Expert%20-%20Small

4

@Brandon,

@Paul’s recommended video is an excellent one. Here’s another short one I think you’ll find very useful in addressing your particular problem.

  • Brian
5

Thanks guys, for pointing me in the direction. I was able to incorporate parts of that into my solution.