I am a new Power BI user, And I am trying to achieve the following:
I have the following main table (example):
ID | SUB_FEATURE |
I have the following 3 tables that defines sets of sub-features to feature:
I need to create a new table that groups the ID to feature using the definition table:
ID | FEATURE |
for each ID in the main table, I'd like to see what sub-feature it has, and based of the sub-fetures list, check which feature does it match.
Wasn't able to find similiar example in the forum.
Thanks in advance!
Solved! Go to Solution.
By my tests, the last solution of Greg_Deckler should achieve your requirement.
In addition, you also could have a reference of my attachment. I append your three tables as a new table in Query Editor.