Forum Discussion
Dynamically select date slicer
Hi All,
I wanted to select the dates dynamically depending upon which month it is.
I.e. - for example, currently it is March 2023 so in the date slicer historical dates till March 2023 must be se...
Hi truptis
For current Month want move slicer automatically created one Calculated Column in that column you need to set one text Name like "Current Month " or Any other name is your Wish. we can achieve this way only .I'm Achieve .
Month 1 = Var __Mon=FORMAT('Date'[Date],"mmm")
var __Yr=FORMAT('Date'[Date],"YYYY")
Return
Var _Result=
IF(__Mon=FORMAT(TODAY(),"MMM"),IF(__Yr=FORMAT(TODAY(),"YYYY"),"Current Month",FORMAT('Date'[Date],"MMM")))
Return
IF(_Result=BLANK(),FORMAT('Date'[Date],"MMM"),_Result)
If have helpful to you Give kudos and accepeted a solution.
Thanks,
Thennarasu