Time intelligience filter

[thampton]

I need to create a report level filter with these fields: Today (CurrentDay), Weekly, MTD, YTD. I have a date table, and could use relative date filtering, but would like to just have four options to choose from. Is this possible? 

[javirmerino]

I found that the below blog has some really great resources on time intellegence, including some custom DAX to determine a WTD value;

https://www.dutchdatadude.com/ultimate-time-based-calculations-cheat-sheet-for-dax-power-bi-includin...

A

[dax · Accepted solution]

Hi @thampton ,

You could try to refer to my sample for details.

Best Regards,
Zoe Zhi

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.