Forum Discussion

learner03's avatar
learner03
Post Partisan
4 years ago
Solved

Merging tables query

I have below 2 tables-SO and SO_lines I want the output table as such that the new table should only contain those SO that are in SO table and the quantity column should be the the sum of only quant...
Need Help
  • sevenhills's avatar
    sevenhills
    4 years ago

    Assuming your relatioship is like this

     

    Create a table as

     

     

    Add filter 

     

    Your output will be 

     

     

Ashish_Mathur's avatar
Ashish_Mathur
Super User
4 years ago

Hi,

You may download my PBI file from here.

Hope this helps.