Forum Discussion
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 ...
Hello ask4atish ,
You may use Power Query for getting the desired output:
- Merge Table 1 with Table 2 on Source no. and extract Customer Name
- Merge the result table above with Table 3 on Source no. and extract Vendor
- Comine the two columns table2.CustomerName and table3.Vendor
- Remove SourceNo column
You may find sample pbix file here
Cheers!
Vivek
If it helps, please mark it as a solution
Kudos would be a cherry on the top 🙂
https://www.vivran.in/
Connect on LinkedIn
