Тёмный

Allocation Calculations in Power BI | Case Study 

Goodly
Подписаться 92 тыс.
Просмотров 8 тыс.
50% 1

How to Tackle Granularity Differences in Power BI?
In this video, we explore the intricacies of Allocation Calculation in Power BI. We examine the challenges associated with handling data at varying granularities and demonstrate how to effectively address allocation problems with data spanning from transaction level to month level.
Watch as we demonstrate step-by-step how to approach, build models, lay down calculations, and present solutions in a meaningful way using Power BI.
===== ONLINE COURSES =====
✔️ Master 'M' in Power Query -
goodly.co.in/learn-m-powerquery/
✔️ Mastering DAX in Power BI -
goodly.co.in/learn-dax-powerbi/
✔️ Power Query Course-
goodly.co.in/learn-power-query/
===== LINKS 🔗 =====
Blog 📰 - www.goodly.co.in/blog/
Corporate Training 👨‍🏫 - www.goodly.co.in/training/
Need my help on a Project 💻- www.goodly.co.in/consulting/
Download File ⬇️ - goodly.co.in/allocation-calcu...
===== CONTACT 🌐 =====
Twitter - / chandeep2786
LinkedIn - / chandeepchhabra
Email - goodly.wordpress@gmail.com
===== WHO AM I? =====
A lot of people think that my name is Goodly, it's NOT ;)
My name is Chandeep. Goodly is my full-time venture where I share what I learn about Excel and Power BI.
Please browse around, you'll find a ton of interesting videos that I have created :) Cheers!

Наука

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

 

21 май 2024

Поделиться:

Ссылка:

Скачать:

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

Добавить в:

Мой плейлист
Посмотреть позже
Комментарии : 24   
@GoodlyChandeep
@GoodlyChandeep 2 месяца назад
Download the file ⬇- goodly.co.in/allocation-calculation-power-bl/ Awesome Courses on Power BI, Power Query & M Language - goodly.co.in/products
@dtaylor6767
@dtaylor6767 Месяц назад
Another excellent video. You are perfect at demonstrating real-life useable Power BI tips and tricks.
@przemekmaj3576
@przemekmaj3576 2 месяца назад
I love your videos, thanks for it. Although the first part could be caluclated simpler: knowing your spendings 554 and total allocation 1199,34 you can calculate share of spending in calculation which is 554 / 1199,34 = 46,19%. Knowing that % on a monthly level, just multiply each allocation value by it, therefore achieving exactly the same ie. last row 6 * 46,19% = 2,8. But i understand educational function of video. keep up the good work
@rudneyrocha
@rudneyrocha 2 месяца назад
Thank You so much!!! Your videos is shorts, precise and objective!! 👏🏼👏🏼👏🏼👏🏼👏🏼
@josephabuo6027
@josephabuo6027 2 месяца назад
Clean and precise! Wonderful work here Boss.
@unnikrishnansanthosh
@unnikrishnansanthosh 2 месяца назад
to the point and very clear, thank you for sharing
@alexrosen8762
@alexrosen8762 2 месяца назад
Very useful tutorial explained in a clear and easy to understand way 👌🙏👌
@anillpatel
@anillpatel 2 месяца назад
Brilliant video presentation. Very well explained.
@NirRobinson
@NirRobinson 2 месяца назад
this is video is super useful and open your mind to think where i can test it in my models thanks
@chrism9037
@chrism9037 2 месяца назад
Excellent video as always thanks Chandeep!
@dilipinamdarpatil6301
@dilipinamdarpatil6301 2 месяца назад
Thank you 🙏
@rajkumarrajan8059
@rajkumarrajan8059 2 месяца назад
Simple and Powerful
@emanueledelzoppo5164
@emanueledelzoppo5164 2 месяца назад
Genius
@Bhavik_Khatri
@Bhavik_Khatri 2 месяца назад
Awesome
@bagofwords1915
@bagofwords1915 2 месяца назад
Thanks Chandeep, this is super helpful. Can you please make a video on allocations in PQ if there is a way that is more efficient than doing it by merging ‘grouped by’ tables ?
@gurvindersingharora5301
@gurvindersingharora5301 2 месяца назад
Hello Sir, Could you make a video explaining when to combine ALL function with Filter Function in Dax ?
@salahaldeen7924
@salahaldeen7924 2 месяца назад
how awesome was that
@lionels839
@lionels839 2 месяца назад
Thanks but how to know what Channel is best?
@rudneyrocha
@rudneyrocha 2 месяца назад
Hi Chandeep! I would like to know which has better performance, when performing some type of calculation, is it better in Power Query M, or DAX?
@ankitmarodia2009
@ankitmarodia2009 2 месяца назад
I need your help in one of scenario, I m struggling to get in Power bi for my project. Can you help me on this
@mohanram5475
@mohanram5475 2 месяца назад
Hi chandeep can you provide EMI options for your course?
@GoodlyChandeep
@GoodlyChandeep 2 месяца назад
working on it.. will take a bit :)
@9994772606
@9994772606 2 месяца назад
Very nice thanks, but "App send " only on sale day alone may not be, even on no sale day also spending for ads will be.But ur explanation is nice, for ur criteria thanks again
Далее
5 Surprising Power Query Tricks You Need to Know!
14:14
Use CONCATENATEX to Create Smart Visuals in Power BI
20:02
10 Steps to Optimize Your Data Model in Power BI
13:41
5 ways to export data from Power BI
19:31
Просмотров 3,1 тыс.
Visual Calculations in Power BI
8:51
Просмотров 39 тыс.
Build a Slicer Panel in Power BI Like a PRO
20:40
Просмотров 61 тыс.
Don't make these CALCULATE Function Mistakes! ⚠️
10:09
Pivot Tables in Power BI !?
26:25
Просмотров 41 тыс.