Dynamic Column based on Date

[NikkiG12]

I'm sorry if this isn't the right place for this. 

My data includes Order Date, Order Date Year; this contains 2022, 2023 and 2024 data. I also have a column of first order date which can range from 1999 to 2024. I want to be able to list existing customer/new customer based on First Order Date but I want to be able to use the Order Date Year as my filter/splicer. 

For example is the Order Date Year = 2022, then all first order dates in 2022 would be new, everything older would be existing and 2023 and 2024 would be blank. Same thing if the Order Date Year is 2023 or 2024. 

Is this possible and if so how?

[Anonymous]

Hi @NikkiG12 

Can you provide detailed sample pbix file and the results you expect.So that I can help you better. Please remove any sensitive data in advance.

Best Regards,

Jayleny