Forum Discussion
Set default limits for between date filter
Hello to you, my issue is pretty simple to explain but I haven't found anything to solve it. I have a normal date filter with "between" mode: I need to model it so that when I op...
So generally you would create a calculated column to flag last month dates and then use that as a filter in your slicer.
Thank you Greg_Deckler for answering.
I already tried but if I use this filed as a visual filter it doesn't work. I see it works if I use a date column on my data table but I am using data coming from Calendar function (my field is Date = CALENDAR(MIN(My_Date); MAX(My_Date)) ) and it looks not influenced by the filter you are suggesting.
So is that Date a table in the model?
Greg_Deckler yes, it comes from a table built with Calendar fuction right to create this date field