Forum Discussion
Solved
merge queries
Hello, I have 3 tables: In table 1 I have the sum price of the product that name is 'ORANGE". The number of product is 201619038. name number sum orange 201619038 95,608.13 In table...
thank you, I will try to fix it
The short answer is you can't get exactly what you described in your last entry. You can get a table that is pretty close, but the Sum column will repeat.
The best you could do is start with Table 3 and merge in the contents of 1 and 2.
Alternatively you could bring all 3 tables into Power BI and create relationships from 3 -> 1 and 3 -> 2, then build the table inside your visuals instead, using Table 3 as the row headers.
thank you, I will try to fix it