Forum Discussion
kmilarov
Helper II
Helper IIMerge only differences in the rows in a power query
Folks, I have a query with a column TagID that I use as a unique value. And many additional columns with different values. but , for some rows I have multiple different values in the same column th...
Based on your description, I created data to reproduce your scenario. The pbix file is attached in the end.
pls try another variant
kmilarovHelper II
Helper IIThank you, Ahmedx. I am trying to implement the formula/steps with the real complex file. Could you advise at what step did you create and insert the trans formula ? I am entering it within the table , but When creating it - I got and error:
An error occurred in the ‘Table’ query. Expression.Error: We cannot convert a value of type Function to type Table.
Details:
Value=[Function]
Type=[Type]
kmilarovHelper II
Helper IIdisregard this. I managed to fix it as per your pbix file. It works now very well. Thank you!