Get certified in Microsoft Fabric—for free! For a limited time, the Microsoft Fabric Community team will be offering free DP-600 exam vouchers. Prepare now
Hi All,
I am having Table like the below image in the Power Query ,
I need to find a result like this , Finding top parent name for each childs in Power Query.
@Praiciya-07 , The best duplicate the table and remove columns other than Object id and name and remove duplicates and then use merge query and join the parent id of the current table with the object id of new table.
Merge Tables (Power Query) : https://youtu.be/zNrmbagO0Oo
Result is not coming as per the expection uisng above method, any other way to find
Check out the October 2024 Power BI update to learn about new features.
Learn from experts, get hands-on experience, and win awesome prizes.
User | Count |
---|---|
108 | |
108 | |
108 | |
90 | |
61 |
User | Count |
---|---|
171 | |
138 | |
132 | |
102 | |
86 |