Custom Filter - DAX

[nataliesmiy1357]

Hello!  I am looking to create a date filter/measure/column with this criteria

Past 3 months data ( June 2024 - Today)

Past 6 months data ( March 2024 - Today)

Past 12 months data ( September 2024 - Today)

All data (January 2019 - Today)

Thanks in advance!

[Selva-Salimi]

Hi @nataliesmiy1357 

one easy way that I recommend is to write a calculated column in your Dim_Date which can be written as follows:

Column =

var tday= today() return

calculate(DISTINCTCOUNT('Table'[month]), filter ('Table', 'Table'[month] >= EARLIER('Table'[month]) && 'Table'[date]<=tday))

If this post helps, then I would appreciate a thumbs up and mark it as the solution to help the other members find it more quickly. 

[Ritaf1983 · Accepted solution]

Hi @nataliesmiy1357 
You can use related date functionality of the date slicer to achieve it :

Or to create the ranges slicer according to your needs, please refer the linked video guide:
https://www.youtube.com/watch?v=3SmHtNf0QQ0

If my answer was helpful please give me a Kudos and accept as a Solution.