Forum Discussion

thhmez7's avatar
thhmez7
Helper III
3 years ago

Create date column that keeps the first date filter after filtering a data row

Hello,

 

in my use case I want to create a date column that keeps the first date filter of selecting months (1st step) when a product is selected next.

 

1st step: Select Month 1 and 2 (from a date table):

2nd step: Select a product, that has a date. When I do that, the date column on the bottom right should still show the dates from the month filter (month 1 and 2).

 

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

 

Thank you.

1 Reply