Тёмный

Actuals Vs Budgets Analysis in Power Query. 

Syed Ali Mahmood
Подписаться 456
Просмотров 18 тыс.
50% 1

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.

Опубликовано:

 

30 дек 2020

Поделиться:

Ссылка:

Скачать:

Готовим ссылку...

Добавить в:

Мой плейлист
Посмотреть позже
Комментарии : 11   
@kamalmuhammad9988
@kamalmuhammad9988 7 месяцев назад
Very simply and nicely explained.
@PhuongNguyen-lx7wc
@PhuongNguyen-lx7wc 2 года назад
Thanks Syed, the sharing is useful and easy to follow
@mahmoudalshami1557
@mahmoudalshami1557 Год назад
Excellent Bro Jazak Allah Khair Greeting from Yemen I hope you can share empty files
@tlee7028
@tlee7028 2 года назад
Thank you for sharing ! this is so helpful!
@erickcruz4639
@erickcruz4639 2 года назад
the variance column is not adding correctly
@felicitavalan7186
@felicitavalan7186 Год назад
Hi Syed, one question why do I get the actual and budgeted sales in the Same column ?
@TheMujahid87
@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
@mazchen
@mazchen Год назад
Why did you need to add the "Type" columns?
@mashokhan8811
@mashokhan8811 Год назад
Salaam can you share the source data Sayed Bhai
@mohammadsahilsiddiqui8995
@mohammadsahilsiddiqui8995 Год назад
Please provide exercise file
@ObonyeMarage
@ObonyeMarage Год назад
Your Variance % measure is incorrect. The denominator should be Budget not Actual
Далее
Actual v/s Rolling Budget in Power BI
19:23
Просмотров 12 тыс.
Power Query - Avoid "Helper Queries" (+10 Cool Tricks)
18:40
Variance Analysis Example Actuals vs Budget
17:59
Просмотров 36 тыс.
Create a Budget v Actual Chart
6:03
Просмотров 44 тыс.