Text column from 2 tables

[setis]

Dear all;

I have the following "North" and "South" tables related to a common "Cases tables"

I have a Measure to place in a table with the casesID from "Cases table" with the amount from both tables. 

Can I do the same thing with the description? I know that I can use MAX or CONCATENATEX but I am expecting one line per description with its respective amount. Like this:

Thanks in advance!

[VijayP]

@setis 

If I have to deal with it, I will apend both North and South Table in Power Query editor so that i need not do much to get the infor in the final Table.

Hope this is a solution for your question and if you find this as answer to your question, please mention as solution and share your Kudos.

You can watch my Youtube videos at www.youtube.com/perepavijay

Regards

Vijay Perepa

[setis]

@VijayP  thanks, I was wondering if it was possible to do it on a measure as well.

[VijayP · Accepted solution]

You can use the UNION function and then combine them into another Tbale and then from there you can follow the same procedure that suggests