Forum Discussion
Power BI Data model
Maybe you can try power query editor -> Merge queries, please reference the following article. This will let you know how to merge tables to one table.
In your case, first copy the ExpenseTable so that if there are any errors you can have a backup, and rename it.
Then use the merger queries under the home tab set as the following show:
Click ok and expend the new column, select Actual:
You will get the result you want. i put pbix file in the end.
If you need to do the calculations in the desktop, I have also shown them in the pbix file. If I misunderstood you please let me know.
Best Regards
Community Support Team _ chenwu zhu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Maybe you can try power query editor -> Merge queries, please reference the following article. This will let you know how to merge tables to one table.
In your case, first copy the ExpenseTable so that if there are any errors you can have a backup, and rename it.
Then use the merger queries under the home tab set as the following show:
Click ok and expend the new column, select Actual:
You will get the result you want. i put pbix file in the end.
If you need to do the calculations in the desktop, I have also shown them in the pbix file. If I misunderstood you please let me know.
Best Regards
Community Support Team _ chenwu zhu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.