Consider the situation. I have column CompanyName that are associated with rows of another coumn called Type. These are "Chain" ,"NF", "FF", and "DF"
Consider that Costco and Publix are both Chains, but read as NF. Which is wrong.
How do I create a calculated column or expression that places these names into the right Type, "Chain." This is going to be on a large scale of data with multiple other company names as well.
Solved! Go to Solution.
Hi @park ,
Maybe something like this?
You could create a nested if statement with all your conditions. Here an example
Here the code:
if [CompanyName] = "Publix" or [CompanyName] = "Costco" then "Chain" else [Type]
Alternatively, you could create an own mapping table according to your definition and then you merge the mapping table with your large table on CompanyName.
Let me know if this helps! 🙂
Thanks! This look like it might work. I will try in a second 🙂
Will this work for approximate matches too? Like lets say I have Publix #1 - Publix #100
Thank you! And if I have lets say 20 different company names, I can continue the OR statement as many times as needed? Or does it only work for two arguments
Hi @park ,
This should work for as many arguments. Please keep in mind that someone needs to update that code in case new companies are added. A better way would probably be to fix that data issue in the source itself (just saying 🙂 )
Power BI release plans for 2023 release wave 1 describes all new features releasing from April 2023 through September 2023.
Make sure you register today for the Power BI Summit 2023. Don't miss all of the great sessions and speakers!
We had a great 2022 with a ton of feature releases to help you drive a data culture.