Forum Discussion
Relationship Causing Duplicates in Measure and Giving Incorrect Total
There are 3 Tables, Dim, Tab1, and Tab 2 with the relationship defined below, Dim Table: Key A B C D Tab1: Key Ref Data A ABCD 10 A ABCD 10 B IJKL 20 ...
Hi Anonymous
You can use the append feature in PowerQuery to implement your needs.
When you add the "ref" column to the table, the result can only be like this:
Best Regards,
Jayleny
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi Anonymous
You can use the append feature in PowerQuery to implement your needs.
When you add the "ref" column to the table, the result can only be like this:
Best Regards,
Jayleny
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.