Forum Discussion
Problem in selecting Max date
HI, Anonymous
calculated column and calculate table can't be affected by any slicer. you could create a measure instead of column.
Notice:
1. Calculation column/table not support dynamic changed based on filter or slicer.
(So MAX(table[column]) will return fixed value)
2. Measure can be affected by filter/slicer, so you can use it to get dynamic summary result.here is reference:
https://www.sqlbi.com/articles/calculated-columns-and-measures-in-dax/
Best Regards,
Lin
Anonymous
Try the following DAX formula:
Column = CALCULATE(MAX('Calendar'[Date]), ALL('Master Table'))Master Table is my fact table and Calendar is the custome calendar table.
You can change them based on your needs
Hi themistoklis
Thanks for the reply.
Unfortunately, this returns the max of the Calendar date table, without taking the active filtering into consideration.