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