I want to create a custom column that returns me the value of another column cell if the text contains a specific word.
If the text doesn't contain the word I am looking for, then return null.
What would be the IF statement in Power Query?
Example:
Column Name: Office
Account: 640.000011 Expatiate
Office: BR Brussels
Department: AD
Office: SU Seoul
Desired Result: Insert a new column that shows only rows values like "Office: BR Brussels" and Office: SU Seoul, the rest of column values are nulls.
.
If the text doesn't contain the word I am looking for, then return null.
What would be the IF statement in Power Query?
Example:
Column Name: Office
Account: 640.000011 Expatiate
Office: BR Brussels
Department: AD
Office: SU Seoul
Desired Result: Insert a new column that shows only rows values like "Office: BR Brussels" and Office: SU Seoul, the rest of column values are nulls.
.