Forum Discussion
Solved
Create custom column based on two other columns
Hello. I would like to add to a formula to a custom column I have written for changing row values based on another column, but I only want to base it off one value. Consider that I have two c...
Use this
= if List.Contains({"Publix","Walmart"},[Company], Comparer.OrdinalIgnoreCase) and [Type]="NF" then "CH" else [Type]👍 It's been a pleasure to help you | Help Hours: 11 AM to 9 PM (UTC+05:30)
How to get your questions answered quickly -- How to provide sample data
Use this
= if List.Contains({"Publix","Walmart"},[Company], Comparer.OrdinalIgnoreCase) and [Type]="NF" then "CH" else [Type]👍 It's been a pleasure to help you | Help Hours: 11 AM to 9 PM (UTC+05:30)
How to get your questions answered quickly -- How to provide sample data