Add a new column based on filter in one column and conditions in other.

[mfaisalk]

Hello,

I want to create a one new column as following ( Power query excel)

1. In the custom column shown here I have two values , Lost and New

2. When I filter on Lost,  The new column should have same dates as in "Last seen"

3. When I filter on New , The new column should have sames dates as in "First seen"

How to go about it ?

[mfaisalk · Accepted solution]

Thank you @AlB , I figured it out. By using conditional columns!

[AlB]

Hi @mfaisalk 

Can you share  a sample of the data, in text-tabular format so that the contents can be copied and the expected result for that sample?

Please accept the solution when done and consider giving a thumbs up if posts are helpful.  Contact me privately for support with any larger-scale BI needs, tutoring, etc.