Forum Discussion
Solved
Merge multiple rows
Hi, I'm a relatively new user to PowerBI and I really find this software amazing. However, I'm kind of stuck with one issue that I need help with. I have a folder as a source (with about 3000...
Hi DimaLnk,
If I understand your issue you have the same ID with all the same values except in some rows that have blanks, this can be sorted by doing a group by in the query. Based on you example you need to do a group by UniqueID and Attr1 (both are text fieds), then do the max for the other 3 attributes, this should work as you need, considering that the lines are always the same if you have different values per UniqueID the Max may not work as you need.
Please check if this works for what you need.
Regards,
Mfelix
