Forum Discussion
Solved
Combining data from
Hi, I want to combine two tables by including all values. Below I represented it with sample data on how I want to have the table. Table1: Date Unit Subunit Value1 05.2021 A A1 1...
After doing NidhiBhusari solution you can use group by in Power Query Editor to give you desired result. As it will combine the same row and SUM all the values in Value1, Value2
You can use Merge Queries in Power Query Editor to combine data
https://www.c-sharpcorner.com/article/merge-two-tables-in-power-bi/
https://blog.enterprisedna.co/how-to-merge-queries-in-power-bi/
Hi, Thanks for the answer, but it doesn't work when the columns date, unit and subunit don't match exactly. It gives the following result: