How to get max value of date range slicer in calculated column, if I use fact column in slicer

[Anonymous]

Please suggect DAX expression,
Thanks in advance.

[v-jayw-msft]

Hi @Anonymous ,

It is not supported for a calculated column value to be changed according to the slicer value you selected.

It is by design, you may submit an idea.

Ideas (powerbi.com)

Best Regards,

Jay

[HoangHugo]

no, friend, we only have one direction: your data table (calculted columns) >>> query >>>> visualiation (slicers). does not have reverse way. You need find other ways.

[Anonymous]

It is working fine, when I use as a mesure. But I need the max date selected value in calculated column.

[HoangHugo]

Hi

max_date =MAX ([your date column])

[Anonymous]

In the calculated column, returning Max value of the slicer not the selected max value.