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.
Hello ,
Below is 2 tables -
table 1 -
Table 2 -
Doing left outer join on table 1 with table 2 on file # and brining out release # from table 2. When am expanding am getting this output which is wrong-- the records are getting duplicated with release #'s with 14 records. Actual out put should be in 3rd screen shot should be 7 records the release # are duplicating . Please advice.
Hello Thankyou for your reply, Join should be on both File # and TG/Amount then the outcome is coming as expected.
Yes if Join on only File# behaviour is right output is wrong.
Why should the first line in your first table be release 273545 and not 273526? What identifies it as belonging with 273545? The behaviour you are seeing is exactly how a left outer join on File# only should work.
Covering 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 |
---|---|
106 | |
98 | |
75 | |
63 | |
62 |
User | Count |
---|---|
139 | |
104 | |
104 | |
80 | |
66 |