Forum Discussion
Custom Filter - DAX
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!
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=3SmHtNf0QQ0If my answer was helpful please give me a Kudos and accept as a Solution.
2 Replies
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=3SmHtNf0QQ0If my answer was helpful please give me a Kudos and accept as a Solution.
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() returncalculate(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.
