Forum Discussion
AdministratorDUPLICATE VALUES, COMBINED TABLE, HELP!
Hi Syndicate_Admin ,
I am gald that you could solve your problem by yourself. According to your screenshoot, I think ELEMENT1 and ELEMENT2 should be the same and ELEMENT has multiple duplicates lile 1043190 in sample. I think you can transform you underlying data by REMOVE DUPLICATES function in Power Query. You can remove duplicates based on multiple columns instead only on one column by using Ctrl + Left Click to select multiple columns and then Right Click and use REMOVE DUPLICATES function to transform your data.
Best Regards,
Rico ZhouIf this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
AdministratorHello friends, I was able to solve in one way and I put it here in case it brings you.
To give me the values I wanted from each one I used the Distinctive Count and since it gave me a big problem was the power I made a separate relationship with the base table, so that the visual object of the power takes it directly from the base table so it gives it to me exactly and to make the relationship take from the table that I made the combination.
I hope this contributes to someone, thank you very much!
Hi Syndicate_Admin ,
I am gald that you could solve your problem by yourself. According to your screenshoot, I think ELEMENT1 and ELEMENT2 should be the same and ELEMENT has multiple duplicates lile 1043190 in sample. I think you can transform you underlying data by REMOVE DUPLICATES function in Power Query. You can remove duplicates based on multiple columns instead only on one column by using Ctrl + Left Click to select multiple columns and then Right Click and use REMOVE DUPLICATES function to transform your data.
Best Regards,
Rico ZhouIf this post helps, then please consider Accept it as the solution to help the other members find it more quickly.