ฝัง
- เผยแพร่เมื่อ 3 ธ.ค. 2020
- - - - - My Courses - - - -
✔️ Mastering DAX in Power BI -
goodly.co.in/learn-dax-powerbi/
✔️ Power Query Course-
goodly.co.in/learn-power-query/
✔️ Master Excel Step by Step-
goodly.co.in/learn-excel/
✔️ Business Intelligence Dashboards-
goodly.co.in/learn-excel-dash...
- - - - Download File and Blog Post - - - -
www.goodly.co.in/allocation-c... - วิทยาศาสตร์และเทคโนโลยี
Great video! Great explanation!
Excellent...very well explained! I see several advantages of your process over my Power Query (PQ) based allocation strategies. I typically do more of the allocation work in Power Query, which does involve adding more columns in Power Query, so dataset becomes bigger, but fewer dax calcs and relationships to build in Power BI report. And using PQ also requires using Dax Summarize in some instances due to aggregations in PQ. And finally, doing a lot more of the work in PQ can also limit the ability to benefit from many great Power BI AI features, since PQ data calcs and aggregations would adversely effect the Power BI logic capabilities. So, I see a lot of potential benefits of your approach over doing building the bulk of the allocation process in Power Query. Thanks for sharing.
I generally use Dax for all calculations.
I get the speed and agility by using Dax over Power Query
After taking your DAX course, the concept you introduce in TH-cam can be understood fast and easily, Thanks Chandeep!
Thanks Elaine..I am glad I could help. Let me know if you have questions
Very helpful, thank you, Chandeep :)
Thank you so much for the walkthrough. What do think about creating a variable with the cost table and adding a column their instead of the physical table?
Thanks! This was helpful!
Glad it was helpful!
Excellent Chandeep! More great content from Goodly. Thanks for sharing :)) Thumbs up!!
Thanks a ton
Very well explained, great video!
Glad you liked it!
Excellent buddy
well Explained
What a great method... Thank you, helped a LOT.
What if though (appart from allocating category-specific spend) I need to additionaly allocate general-type spending like rent lets say. That should be allocated accross all sales lines. How should I adjust your method?
👌
Hello, Great Video. When it comes to DAX efficiency: Could using a variable (VAR) in the cost allocating calculation have similar impact on performance as helper calculation column?
Thanks Filip!
The VAR would still be created in each row of the Sales Table... I suspect that it won't have an impact.
Hello Chandeep, thanks for this excellent video, I have a doubt hope you can support me. I have a question, how do you handle it if I have a cost that I need to allocate to all product (also to categories) additional to the costs defined for each category?
Greetings from Lima, Peru
You browse the entire YT ecosystem to find a solution and after trial and mostly errors you remember good old Goodly and suddenly the problem is solved! I made a slight variation by adding the concat column of the cost table in power query to follow best practice…
Hey Chandeep
What if I want the allocation to avoid allocating to the entire year in the case I report in a current year (2023 for instance)?
Awesome video!!
Is it possible to allocate a variable number based on sales contribution? Unlike here where the cost is in a separate table.
e.g. User will input the TARGET VALUE then the measure will distribute that X value based on share.
Thank you so much!! :)
The input values can be driven from an Excel file or the enter data option. There isn't a way to type data in PowerBI