Forum Discussion
Lutinho
6 years agoFrequent Visitor
Creating classification column by matching multiple columns from other table
Dear Power BI community, I am trying to classify rows in my dummy data based on 4 columns; country, area, subarea and name. I am trying to create a logic somehow like this: - If in a row in...
- 6 years ago
Hi Lutinho ,
According to your requirements, the logic needs 16 IF formulas at least. Considering the amount of data and the complexity of your logic, this may lead to very low performance.
So I don't recommend that you use Power BI to complete it.
v-eachen-msft
6 years agoCommunity Support
Hi Lutinho ,
According to your requirements, the logic needs 16 IF formulas at least. Considering the amount of data and the complexity of your logic, this may lead to very low performance.
So I don't recommend that you use Power BI to complete it.
Lutinho
6 years agoFrequent Visitor
Thanks for your reply. Was hoping there was some strong Power BI function to take care of this. Unfortunately, there isn't. Have a great day!