Forum Discussion
Solved
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...
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() 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.