Forum Discussion
Solved
Sum base on multiple columns from another table
Hi Everyone! I cannot figure out how to sum column Invoiced Quantity from Last Quarter Sales table into my Inventory table based on the ProductCode and LocationCode conditions Currently I have: ...
Hello AngelArteagaH
I created a new column on both tables which concatenates ProductCode and LocationCode.
The new column was created using Power Query.
Then Joined the tables on this column (1 to many relationship).
Finally I created a simple sum formula to get the last quarter sales.
PowerBI file attached
themistoklis
Community Champion
Community ChampionHello AngelArteagaH
I created a new column on both tables which concatenates ProductCode and LocationCode.
The new column was created using Power Query.
Then Joined the tables on this column (1 to many relationship).
Finally I created a simple sum formula to get the last quarter sales.
PowerBI file attached
Thanks, it works like a charm
