Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
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?
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
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
User | Count |
---|---|
140 | |
113 | |
104 | |
77 | |
64 |
User | Count |
---|---|
135 | |
120 | |
101 | |
71 | |
61 |