Uploaded October 2026 | Updated November 2026, 17 hours ago
π If your company needs help building professional Power BI reports like this, fill out this form and our team will get in touch:
https://in.bigin.online/org60031607649/forms/book-a-call
π Get the visual from this video, plus access to all my Power BI courses with Goodly Insider:
courses.goodly.co.in/insider
Budget vs Actuals is one of the most common reporting requirements in Power BI, but the calculation can become tricky very quickly once the budget and actual data are stored at different levels of detail.
In this video, I explain how to build Budget vs Actuals in Power BI through three levels of complexity, starting with a simple monthly budget model and gradually moving towards more realistic scenarios involving grain mismatch, bridge tables and rolling budgets.
We begin with the basics: preparing the budget data in Power Query, building the data model, creating measures for sales and budgets, and handling cases where monthly budgets should not appear at the daily level.
Next, we look at a more challenging scenario where actual sales are recorded by product but budgets are available only at the product category level. I show you how to handle this grain mismatch using a bridge table and a clean Power BI data model without relying on a many-to-many relationship.
Finally, we build a rolling Budget vs Actuals report where actual sales are shown up to a selected month and budget figures automatically take over for the remaining months of the year. We use DAX, an inactive relationship, a pseudo calendar table and conditional formatting to make the final visual easy to understand.
If you work in finance, FP&A, reporting or Power BI, this video will help you understand how to model and calculate Budget vs Actuals in more realistic business scenarios.
#PowerBI #BudgetVsActuals #DAX #FinancialReporting
===== LINKS π =====
Blog π° - goodly.co.in/blog
Corporate Training π¨βπ« - goodly.co.in/training
Need my help on a Project π»- goodly.co.in/consulting
Join my free Power BI Community - Goodly Circle - goodlyinsider.simplero.com/page/716271
===== CHAPTERS =====
00:00 - Intro
0:33 - Level 1
9:41 - Level 2
17:38 - Level 3
18:41 - Level 3 Part 1
22:10 - Level 3 Part 2
30:26 - Level 3 Part 3
32:06 - Level 3 Part 4
===== CONTACT π =====
Twitter - twitter.com/chandeep2786
LinkedIn - linkedin.com/in/chandeepchhabra
Email - goodly.wordpress@gmail.com
===== WHO AM I? =====
A lot of people think that my name is Goodly, it's NOT ;)
My name is Chandeep. Goodly is my full-time venture where I share what I learn about Excel and Power BI.
Please browse around, you'll find a ton of interesting videos that I have created :) Cheers!
π If your company needs help building professional Power BI reports like this, fill out this form and our team will get in touch:
https://in.bigin.online/org60031607649/forms/book-a-call
π Get the visual from this video, plus access to all my Power BI courses with Goodly Insider:
courses.goodly.co.in/insider
Budget vs Actuals is one of the most common reporting requirements in Power BI, but the calculation can become tricky very quickly once the budget and actual data are stored at different levels of detail.
In this video, I explain how to build Budget vs Actuals in Power BI through three levels of complexity, starting with a simple monthly budget model and gradually moving towards more realistic scenarios involving grain mismatch, bridge tables and rolling budgets.
We begin with the basics: preparing the budget data in Power Query, building the data model, creating measures for sales and budgets, and handling cases where monthly budgets should not appear at the daily level.
Next, we look at a more challenging scenario where actual sales are recorded by product but budgets are available only at the product category level. I show you how to handle this grain mismatch using a bridge table and a clean Power BI data model without relying on a many-to-many relationship.
Finally, we build a rolling Budget vs Actuals report where actual sales are shown up to a selected month and budget figures automatically take over for the remaining months of the year. We use DAX, an inactive relationship, a pseudo calendar table and conditional formatting to make the final visual easy to understand.
If you work in finance, FP&A, reporting or Power BI, this video will help you understand how to model and calculate Budget vs Actuals in more realistic business scenarios.
#PowerBI #BudgetVsActuals #DAX #FinancialReporting
===== LINKS π =====
Blog π° - goodly.co.in/blog
Corporate Training π¨βπ« - goodly.co.in/training
Need my help on a Project π»- goodly.co.in/consulting
Join my free Power BI Community - Goodly Circle - goodlyinsider.simplero.com/page/716271
===== CHAPTERS =====
00:00 - Intro
0:33 - Level 1
9:41 - Level 2
17:38 - Level 3
18:41 - Level 3 Part 1
22:10 - Level 3 Part 2
30:26 - Level 3 Part 3
32:06 - Level 3 Part 4
===== CONTACT π =====
Twitter - twitter.com/chandeep2786
LinkedIn - linkedin.com/in/chandeepchhabra
Email - goodly.wordpress@gmail.com
===== WHO AM I? =====
A lot of people think that my name is Goodly, it's NOT ;)
My name is Chandeep. Goodly is my full-time venture where I share what I learn about Excel and Power BI.
Please browse around, you'll find a ton of interesting videos that I have created :) Cheers!










