Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
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êsUser | Count |
---|---|
128 | |
108 | |
100 | |
64 | |
62 |
User | Count |
---|---|
136 | |
113 | |
102 | |
71 | |
60 |