Forum Discussion
Set default limits for between date filter
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
So can't you add your flag column to that table?
Greg_Deckler if you mean adding the flag column to the visual level filter, yes I can but it has no effects and dates still remain to normal range without being influenced by it. I see it doesn't happen if I don't use Calendar date but a date field from my data, but I need Calendar because I need every single day and not just days for which there is a record.
Anonymous
You may refer to the post below.
Thanks v-chuncz-msft this is pretty simple but good. I already thought to it, I'd like to know if there is a way to do it without adding any visual but simply open the report with dates already set on last month.
