Hi Mynda,
Following your PowerBI course. Very nice and interesting!
In this 3.06 you made a 1.05 calculation and for the total that seems to work.
But when you look closer to the values in the Asian part, something seems wrong: Brown and Smith seems to be mixed up?
The question of course is if this is correct and how to fix this when you ran into such a thing?
thanks for looking!
Frans
Hi Frans,
If you're multiplying the budget amount by 1.05 then you won't get the same result because the 'next year budget' measure is based on the actuals x 1.05.
It's probably confusing because the table I build in this lesson contains budget and next year budget. If you check your math against the actuals in the table in the top left of the screen you'll see it's correct.
Mynda
Ah, of course! I compared the two values in this table. But you're right (of course) it's budget versus actual which made it confusing. Thanks!
Frans
