Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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 the dummy data, the 4 columns match the same combination as in of the 4 columns in the lookup table --> take the classification from the lookup table.
- If the column values don't match, insert missing.
The lookup table can be interpreted like this:
- The 2nd row will result in all rows having country code 035, regardless of the other column values (since they are empty), will get the classification 'Pie'.
- 21st row will will result in all rows having country code 005 AND name AKKE will also get the classification 'Pie'.
I have no idea how to get this done in Power BI. Does anyone have a solution? Thanks in advance. The attached dummy data contains many rows, I hope that is not a problem.
Dummy data that needs to be classified:
https://drive.google.com/file/d/1qyysu-f5HktutCR372Nx8jS0EbnGNkSv/view
Classification/lookup table:
https://drive.google.com/file/d/1Mpb8-XnQY2kP8NkUhqs9pixV39Ee8tV7/view
Thanks in advance, again 🙂
Solved! Go to Solution.
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.
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.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
111 | |
100 | |
80 | |
64 | |
58 |
User | Count |
---|---|
146 | |
110 | |
93 | |
84 | |
67 |