Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Hi team,
Want to make a relation between 1 to many from Table_B to Table_A.
In TABLE_B there are duplicated values.
How can I detect this duplicated values from Table_B? ( real table has many rows..)
Any other solution?
TABLE A | TABLE B | |||||
CLIENT | ORDER | REF | REVEN | CLIENT | ORDER | |
A | P100 | XX | 100 | A | P100 | |
A | P100 | ZZ | 110 | A | P101 | |
A | P101 | XX | 120 | B | A102 | |
A | P101 | YY | 130 | B | A102 | |
B | A102 | BB | 140 | |||
B | A102 | CC | 150 |
thanks,
Solved! Go to Solution.
@ADRICHECKIN , Delete duplicate as suggest by @MFelix .
Also you need a concatenated column in both tables to join
Key = [Client] & "-" & [Order]
Hi @ADRICHECKIN ,
Is this problem solved?
If it is solved, please always accept the replies making sense as solution to your question so that people who may have the same question can get the solution directly.
If not, please let me know.
Best Regards,
Icey
@ADRICHECKIN , Delete duplicate as suggest by @MFelix .
Also you need a concatenated column in both tables to join
Key = [Client] & "-" & [Order]
Hi @ADRICHECKIN,
On the query editor select all row from table b and remove duplicates that should clean the information.
Regards
Miguel Félix
Proud to be a Super User!
Check out my blog: Power BI em PortuguêsCovering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
113 | |
97 | |
85 | |
70 | |
61 |
User | Count |
---|---|
151 | |
121 | |
104 | |
87 | |
67 |