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 defined always starts at first of the month(eg. 1/1/23, 2/1/23, etc) while in the second table, dates varies.
My end goal is to calculate the percentage achieve from the target to the actual live data.
I tried to merge the table data but their respective result changed.
I also tried to have a one way relationship between the common field of the table which is the department but still, does not displayed the correct values.
Also, either of the 2 values can have an additional department, which ever is updated first, it may be first table or the second table.
So my final approach is to have the 2 tables having separate visuals but have a third table with their combined result. But I cant figure out how to achieve this.
Can anyone help me with this? A step by step guide would be much appreciated.
Thank you in advance.
Thank you for your response.
The table have a date column. It is the Qtr 1, Qtr2, etc. You can expand/drill those columns to display by months. As I mentioned, the dates are in this format: (eg. 1/1/23, 2/1/23, etc)
|Qtr 1||Qtr 2|
They are not in same data source. The Target table is a user defined table, while the Actual table comes from another live source though they reside on same database.
Sorry but it seems that I cant attach an excel or zip file on here so, I can only give a screenshot of the sample data. Please see below images.
Hi @ryan_mayu ,
I tried to do your sample, however I have a zero result.
Actually, I am newbie in PowerBI and started using the application 3 days ago.
All other reports were already done exept of the final result which is computation of Actual/Target.
So here are the steps I did:
1. Create a department table
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!
Check out the November 2023 Power BI update to learn about new features.
Read the latest Fabric Community announcements, including updates on Power BI, Synapse, Data Factory and Data Activator.
130+ sessions, 130+ speakers, Product managers, MVPs, and experts. All about Power BI and Fabric. Attend online or watch the recordings.