Actuals Vs Budgets Analysis in Power Query.

[@kamalmuhammad9988]

Very simply and nicely explained.

[@PhuongNguyen-lx7wc]

Thanks Syed, the sharing is useful and easy to follow

[@tlee7028]

Thank you for sharing ! this is so helpful!

[@mahmoudalshami1557]

Excellent Bro Jazak Allah Khair Greeting from Yemen I hope you can share empty files

[@erickcruz4639]

the variance column is not adding correctly

[@TheMujahid87]

I think instead to import two data set one for budget and one for actual, it could be import only one and then a copy of the same could be make through applied steps. At back end there will be one file and the model will be lighter then the method you applied sir

[@felicitavalan7186]

Hi Syed, one question why do I get the actual and budgeted sales in the Same column ?

[@mazchen]

Why did you need to add the "Type" columns?

[@mashokhan8811]

Salaam can you share the source data Sayed Bhai

[@mohammadsahilsiddiqui8995]

Please provide exercise file

[@ObonyeMarage]

Your Variance % measure is incorrect. The denominator should be Budget not Actual