Forum Discussion
Anonymous
3 years agoNot applicable
Combining Totals from 2 different tables
Hi everyone, I need a help regarding combining the results of 2 different source tables in Power BI. Please see below: The first table is static, with manual input, where the dates defi...
Anonymous
3 years agoNot applicable
Hi ryan_mayu ,
Yes I did. (Step 4)
I am thinking, I think I am able to create the calculation I need.
Though it is a different approach, your sample gave me an idea to do it.
Here is my thought:
1. Clean the 2 soruce table, remove un needed columns from actual and target
2. Make the names of common columns identical for both table
3. Append the 2 tables. This will just add another column which is not present on the other table.
4. Create a computation matrix on the fields dividing the 2 concerned columns
5. Arrange the columns in the matrix as usual.
Feel free to comment if you have a better suggestion or the procedure I did have a consequence.
Thank you so much for your help and time!
Your sample help me so much!