Forum Discussion

ask4atish's avatar
ask4atish
Icon for Advocate III rankAdvocate III
6 years ago

Summarize three table fields in one table

Hi, I want to create a table visual where data is coming from three different tables which are linked with each other on a key.  Table 1:   Sourceno amount A1 12 A2 85 A3 61 ...
Need Help
Tips and Tricks
Mariusz's avatar
Mariusz
Icon for Community Champion rankCommunity Champion
6 years ago

Hi ask4atish 

 

You can append Table 2 and Table 3 in Power Query, but before you will need to rename both customer and vendor columns to  customer-vendor

 

Or use Union Dax Function

 

Best Regards,
Mariusz

If this post helps, then please consider Accepting it as the solution.

Please feel free to connect with me.
LinkedIn

 

 

 

  • ask4atish's avatar
    ask4atish
    Icon for Advocate III rankAdvocate III
    6 years ago

    Hi Mariusz ,

    I followed the steps provided by you. However, now amount field is showing blank or 0 whenever I perform sum on this.