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
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