Get certified in Microsoft Fabric—for free! For a limited time, the Microsoft Fabric Community team will be offering free DP-600 exam vouchers. Prepare now
Hi,
I am using two table one table data is
this is the correct sales value
Customer_Code | CustomerName | ItemCode | ItemName | Sum(Qty) | Sum(Amount) |
0001 | a | p001 | f | 10 | 200 |
0002 | b | p002 | g | 10 | 200 |
0003 | c | p002 | h | 20 | 300 |
Second table just have an information that requred to marge to first table
bomitem | Item Name | Product BOM | UOM |
p001 | f | ||
t | 1 | ||
y | 1 | ||
u | 1 | ||
g | |||
r | 1 | ||
t | 1 | ||
u | 1 | ||
h |
when i marge this two table it give me a result of
Customer_Code | CustomerName | ItemCode | ItemName | Product BOM | Sum(Qty) | Sum(Amount) |
0001 | a | p001 | f | t | 10 | 200 |
f | y | 10 | 200 | |||
f | u | 10 | 200 | |||
0002 | b | p002 | g | r | 10 | 200 |
g | t | 10 | 200 | |||
g | u | 10 | 200 | |||
0003 | c | p002 | h | 20 | 300 |
But correct result after marging shoud be
Customer_Code | CustomerName | ItemCode | ItemName | Product BOM | Sum(Qty) | Sum(Amount) |
0001 | a | p001 | f | t | 10 | 200 |
f | y | |||||
f | u | |||||
0002 | b | p002 | g | r | 10 | 200 |
g | t | |||||
g | u | |||||
0003 | c | p002 | h | 20 | 300 |
Kindly help to get this resolved
Hi @nksahay ,
You could try merge queries feature with right outer join as below.
The problem is the product for item f is blank, why it will be "t" in the result?
Best Regards,
Jay
Hi Friends,
Can any one help me in this
Thanks in advance
Check out the October 2024 Power BI update to learn about new features.
Learn from experts, get hands-on experience, and win awesome prizes.
User | Count |
---|---|
115 | |
112 | |
105 | |
95 | |
58 |
User | Count |
---|---|
174 | |
147 | |
136 | |
102 | |
82 |