Forum Discussion

setis's avatar
setis
Post Partisan
6 years ago
Solved

Text 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!

Need Help
  • VijayP's avatar
    VijayP
    6 years ago

    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's avatar
    VijayP
    Community Champion
    6 years ago

    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's avatar
      setis
      Post Partisan
      6 years ago

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

      • VijayP's avatar
        VijayP
        Community Champion
        6 years ago

        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