Forum Discussion

Lutinho's avatar
Lutinho
Frequent Visitor
6 years ago
Solved

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...
  • v-eachen-msft's avatar
    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.