Forum Discussion
actuals vs. forecast calculate difference between two tables
Dear community, i am rather new to PowerBi and data analysis, thus i hope my question is not considred as too stupid.. i have a table containing all sales actuals of 2018 and 2019 and another ta...
Hi,
When you create one table containing both actuals and forecast you can combine this. Both 2 tables and are fact tables, so here you prefer to create 1 new/combined fact table. Creating one Combined table can be done via Append in the Query Editor.
See this link for PBI Desktop file.
FilipFireFlyBI
Resolver I
Resolver IHi,
When you create one table containing both actuals and forecast you can combine this. Both 2 tables and are fact tables, so here you prefer to create 1 new/combined fact table. Creating one Combined table can be done via Append in the Query Editor.
See this link for PBI Desktop file.