Forum Discussion
How to sum the values
Hi Experts, I have the Actual table and Plan table, I have appended the tables and created new table. The problem is, i have period in Actual table but not in Plan, so what i have done is I j...
Best option is to keep the Plan and Actual as 2 seperate tables, and create common dimension tables around it, thereby making a Star Schema. You can watch the below video for more info:
https://www.sqlbi.com/tv/budgeting-with-power-bi-pass-austria/