Create Date column that does not react to filter

[thhmez7]

Hi,

how can I create a date column that does not react to a filter interaction? For example:

If I select any Product, the date column (Modifiedon) on the right should not change and still show all dates.

I want to do it with a new DAX column, so it's without "Edit interactions" in PBI desktop. In my case it's also important to create a column and not a measure.

Thank you.

[thhmez7]

Thank you, this sounds good. However I realize my use case is slightly different, so hope you don't mind me making another thread about it.

[v-yadongf-msft · Accepted solution]

Hi @thhmez7 ，

This is my test table:

Please try following DAX to create a new table:

NewTable = VALUES('Table'[Modifiedon])

Don't create relationships between two tables:

The result you want:

Best regards,

Yadong Fang

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.