PP09 | Actual Vs Budget | 2 Fact Tables in a Data Model

[@WaqasKhan-sp3sn]

Excellent. Masterpiece

[@aaaexcelenglish]

Thank you 😊

[@axeemx]

This is what I was looking for. Thank you for the video. This is a masterclass.

[@aaaexcelenglish]

Great, Happy that you found what you was looking for, thank you

[@RoyalGate-to8rm]

Hi. Also put target table and explain thank you

[@aaaexcelenglish]

Great suggestion! I'll keep that in mind for future videos.

[@Egyptian_Fisher]

Very insightful

[@aaaexcelenglish]

Thank you 🙏

[@gowrisankarrao6529]

Loved it

[@eniolaadekoya5623]

hi i seems not to get the way you set up the date in the budget table

[@mufycw]

In this video, you calculated total budget by using sum function why you didnt use SUMX function like you did in sales table?

[@aaaexcelenglish]

The structure of the budget table is different, the revenue already calculated unlike the actual, I had to calculate the revenue using quantity and discount from the fact table and the price column from the lookup table