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.
Anonymous
When you say active filtering do you mean filter on dates or on other fields?
Can you also share the file with us, and a sample of the desired output?
The filter is done by a slicer currently :).
I have created an example file. I'd like the Custom Column (Column_MaxDate) to return the same value as the Measure (Measure_MaxDate) does.
You can find the example file in the link below. If prompted a password use 'PBI'
https://transfernow.net/280sp1x9l54t
Again thanks for helping :)
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