Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Reply
ammartino44
Helper III
Helper III

Actuals vs. Budget for financial statements

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? 

2 REPLIES 2
v-qiuyu-msft
Community Support
Community Support

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

Community Support Team _ Qiuyun Yu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
CheenuSing
Community Champion
Community Champion

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

Did I answer your question? Mark my post as a solution and also give KUDOS !

Proud to be a Datanaut!

Helpful resources

Announcements
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

Find out what's new and trending in the Fabric Community.