Forum Discussion
Dynamic Custom Date Column with DAX
Hi, In the date slicer, From DATE_1 to DATE_2, I want to fix DATE_2 as Today(), the DATE_1 can be customized. I am thinking of adding a new column using DAX by going into Modelling > New Column >...
Hihi, thank you for your reply.
I don't get it much. Can you guide more specifically?
Thank you in advance 😄
If the timezone isn't the issue, just:
1) Select the slicer you're pointing to in your screenshot.
2) In the 'Filters on this visual' section, change date slicer to 'Relative date' (it might be set to 'Advanced' or 'Basic')
3) Set to In the last 10 years and be sure to tick 'Include today'
This should do the same thing without needing to create a calculated column and will update unlike the calculated column which will only update if you refilter the slicer.