Actuals vs. Budget for financial statements

[ammartino44]

Hello. I'm working on creating financial statements in power pivot/power bi. Should I use seperate data tables (actuals/budget) or the same one? Does anyone have any examples? 

[v-qiuyu-msft]

Hi @ammartino44,

In my opinion, it would be better to create separate actual and budget table, then build the relationship between those tables refer to this article: Create and manage relationships in Power BI Desktop.

Although I didn't find exact sample about budget and actual online, you can refer to these samples to build your own data model and reports:  Samples for Power BI service.

Best Regards,
Qiuyun Yu

[CheenuSing]

Hi @ammartino44

Check out the link

https://community.powerbi.com/t5/Desktop/Compare-actual-with-budget-in-two-overate-tables/td-p/65228

If it works for you accept this as solutions and also give KUDOS.

Cheers

ChsenuSing