Allocation Calculations in Power BI | Case Study
ฝัง
- เผยแพร่เมื่อ 21 พ.ค. 2024
- 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! - วิทยาศาสตร์และเทคโนโลยี
Download the file ⬇- goodly.co.in/allocation-calculation-power-bl/
Awesome Courses on Power BI, Power Query & M Language - goodly.co.in/products
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
Thank You so much!!! Your videos is shorts, precise and objective!! 👏🏼👏🏼👏🏼👏🏼👏🏼
Clean and precise! Wonderful work here Boss.
Brilliant video presentation.
Very well explained.
Very useful tutorial explained in a clear and easy to understand way 👌🙏👌
to the point and very clear, thank you for sharing
Excellent video as always thanks Chandeep!
this is video is super useful and open your mind to think where i can test it in my models
thanks
Thank you 🙏
Simple and Powerful
Awesome
how awesome was that
Hello Sir,
Could you make a video explaining when to combine ALL function with Filter Function in Dax ?
Genius
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 ?
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?
Thanks but how to know what Channel is best?
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
Hi chandeep can you provide EMI options for your course?
working on it.. will take a bit :)
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