Forum Discussion
Post PartisanText column from 2 tables
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!
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
3 Replies
- VijayP
Community Champion
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
