12-20-2018 06:04 AM
Thanks @AlB. I understood your meaning that a variable is a constant only within the context (row) where it is first calculated.
Good discussion thread. Thanks all!
12-20-2018 06:12 AM
When defining the variable and comparing it with the maximum value it can or not recalculate the variable.
If you are using a card it will pick up the full dataset and return the maximum date value so "table context", however when having a table visual you get into the row context of the visual and for each line the maximum value of date is "recalculated" for each interaction of the date.
So it's recalculating in a context enviroment.
Glad I could help.