Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
I want to compare two cell values in column 'Unique Customer', and 'Promo ID'. Unique Customer value can be repeatable, based on the date, with or without 'Promo ID'. I like to create a new column looking up entire column of unique Customer. if any of the unique customer containts Promo Id, I want to tag that Unique Customer as Y. Please help.
This is not in my Excel folder source | |||
New Column | |||
Unique Customer | Promo ID | VFP Customer | |
A AHAMED LEBBE/MANSO | 222023 | Y | |
A AHAMED LEBBE/MANSO | Y | ||
AABID/MAHMMOUDMR | 222023 | Y | |
AABID/MAHMMOUDMR | Y | ||
AABOEN/STIANMR | N | ||
AADITYA | N |
Solved! Go to Solution.
Just paste the code I have provided in formula bar.
''YourPreviousStepName'' was just a place holder for the previous step in your query.
Since it has more than 1 word in its name it should be formated as #"Unique Customer".
Dear Jakinta,
Much appreciated the help.
You can try with step below after your step/table with columns "Unique Customer" & "Promo ID".
= Table.RemoveColumns ( Table.Combine( Table.Group( Table.DuplicateColumn( YourPreviousStepName, "Promo ID", "Helper"), {"Unique Customer"}, {{"A", each Table.AddColumn (Table.FillDown (Table.FillUp (_, {"Helper"}), {"Helper"}), "VFP Customer", each if [Helper] <> null then "Y" else "N" ), type table }})[A]), "Helper")
Much appreciated your help. However please see the error as shown in the photo
Just paste the code I have provided in formula bar.
''YourPreviousStepName'' was just a place holder for the previous step in your query.
Since it has more than 1 word in its name it should be formated as #"Unique Customer".