Using Slicer max date as a if conditional for column

[PBI_5]

Hi everyone, 

Im having trouble trying to get the max date from my slicer as a variable for the column that i want. currently i have measure to get the selected date. But while using this measure in another table, no value is copied.

this is the measure maxdate6 i created

as you can the measure has gotten the value but when i try to copy into a column in a table, nothing comes up

Can anyone help with this, any other way is also appriciated.

[v-shex-msft]

Hi @PBI_5,

Power bi does not support create dynamic calculated column/table based on filter. They do not work on the same level, and you can't use their child to affect its parent level.

Notice: the data level of power bi(from parent to child level)

Database(external) -> query table(query, custom function, query parameters) -> data model table(table, calculate column/table) -> data view with virtual tables(measure, visual, filter, slicer)

Regards,

Xiaoxin Sheng

[amitchandak]

@PBI_5 , You can not use slicer value in a calculated column, you can only use that in a measure