Forum Discussion

ask4atish's avatar
ask4atish
Advocate 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
Community 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
Advocate 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.