No video
Actuals Vs Budgets Analysis in Power Query.
Рет қаралды 18,734
Күн бұрынIn this video, I will be sharing with you the amazing Group By feature in Power Query.
With the help of Group By, I have grouped different columns and perform an operation to get the desired result in a new column.
In the end, I used simple DAX measures to prepare ACTUAL Vs BUDGET variance analysis and prepared some visuals.
@kamalmuhammad9988 7 ай бұрын
Very simply and nicely explained.
@PhuongNguyen-lx7wc 2 жыл бұрын
Thanks Syed, the sharing is useful and easy to follow
@tlee7028 2 жыл бұрын
Thank you for sharing ! this is so helpful!
@mahmoudalshami1557 Жыл бұрын
Excellent Bro Jazak Allah Khair Greeting from Yemen I hope you can share empty files
@TheMujahid87 11 ай бұрын
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
@erickcruz4639 2 жыл бұрын
the variance column is not adding correctly
@felicitavalan7186 Жыл бұрын
Hi Syed, one question why do I get the actual and budgeted sales in the Same column ?
@mazchen 2 жыл бұрын
Why did you need to add the "Type" columns?
@mashokhan8811 2 жыл бұрын
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
奧特羅羅 Ultraman
Рет қаралды 6 МЛН
Kenji Explains
Рет қаралды 849 М.
Jason Davidson
Рет қаралды 10 М.
Maven Analytics
Рет қаралды 110 М.
justB
Рет қаралды 5 М.
excelisfun
Рет қаралды 48 М.