date in calculated column changes with the selected date in page filter

[12Bowers12]

Hello, everyone,

In the calculated column, there is a date. In the page filter, there a date filter. If the date changes, the date in the calculated column changes accorrdingly.

For instance, if the page filter changes to 05/31/23, the date in the calculated column also changes to 05/31/23.

I would like to appreciate your help first.

Dennis

[v-shex-msft]

Hi @12Bowers12,

In fact, current power bi does not support create dynamic calculated column/table based on filter effects. They are work on different levels and you can't use the child level to affect its parent.

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

[Ritaf1983]

Hi @12Bowers12 
It's hard to figure out what you need.

Please provide sample data that covers your issue or question completely, in a usable format (not as a screenshot).
https://community.powerbi.com/t5/Community-Blog/How-to-provide-sample-data-in-the-Power-BI-Forum/ba-...
Please show the expected outcome based on the sample data you provided.

https://community.powerbi.com/t5/Desktop/How-to-Get-Your-Question-Answered-Quickly/m-p/1447523