Create allocation table and visualize it in a Gantt Charts with matrix in Power Query
ฝัง
- เผยแพร่เมื่อ 28 ก.ย. 2024
- In this video I will show you how you can create an allocation table in Power query and display the results in a Gantt chart using only the Matrix available in Power BI.
Here you can download all the pbix files: curbal.com/don...
SUBSCRIBE to learn more about Power and Excel BI!
/ @curbalen
Our PLAYLISTS:
- Join our DAX Fridays! Series: goo.gl/FtUWUX
- Power BI dashboards for beginners: goo.gl/9YzyDP
- Power BI Tips & Tricks: goo.gl/H6kUbP
- Power Bi and Google Analytics: goo.gl/ZNsY8l
☼☼☼☼☼☼☼☼☼☼
POWER BI COURSES:
Want to learn Power BI? How about you take one of our courses? Here you can find the available courses:
curbal.com/cou...
☼☼☼☼☼☼☼☼☼☼
ABOUT CURBAL:
Website: www.curbal.com
Contact us: www.curbal.com/...
▼▼▼▼▼▼▼▼▼▼
If you feel that any of the videos, downloads, blog posts that I have created have been useful to you and you want to help me keep on going, here you can do a small donation to support my work and keep the channel running:
curbal.com/pro...
Many thanks in advance!
▲▲▲▲▲▲▲▲▲▲
************
************
QUESTIONS? COMMENTS? SUGGESTIONS? You’ll find me here:
Linkedin ► goo.gl/3VW6Ky
Twitter ► @curbalen, @ruthpozuelo
Facebook ► goo.gl/bME2sB
#CURBAL #SUBSCRIBE
Hi Ruth, perfectly works to allocate monthly budget in to daily budget. Thanks
My pleasure:)
Today I was just figuring out how! Thanks so much! I came to “there must be a list function”...getting there. 😎
You will , well done!!
Great video. This is awesome!!
Neat solution. I did not face such requirement, but I'll keep it in my favorites. I actually do similar task when I, for instance, have to create a risk evaluation using different sets of threshold values. Just add a Cartesian product, explode it, and then use different thresholds for different scenarios.
Ahhh, clever!!
Excellent step by step video!! Could you please make a video on how to put data in a classic Gantt chart visualisation in Power BI?
Here:
m.th-cam.com/video/80vDPtunnj4/w-d-xo.html
Dear madam thank-you so much fr such informative video but m new to power query can you please guide me how to see ur power query series in order from bigginer to expert..
Working on that, stay tuned!
great thanks con you do it direct in power BI by dax
more powerquery examples please Ruth! really good video , simple and useful. thanks for putting it all together
Will do, promise :)
super cool, really like it
Thank you Ruth!👍
Amazing!! ur the best!! ty i will use that on my work :D
Glad I did it then :)
Hi ruth, great video (again)! Really valuable as start and end date + an amount is usually provided. Is there an easy way to take into account workings days / weekends? Especially for resource allocation the weekend are to be excluded because of.. weekend. Let me know :)
Fair point, in my case I didn't have to, but I can see how that would be the norm. Added to my list!
Great video Ruth. How scalable is this approach, eg if you had 1000s of orders covering 1000s of days? Ive used List in PQ in the past and it bombed the performance when trying to compute the intervals. Also, could something similar be achieved in DAX, using USERELATIONSHIP against a calendar table? Thanks!
Well, the bigger the data, the slower it will get, but I haven't tried it with really big datasets.
Try it, if it is too slow, do it at the source or try the DAX approach I will show on tomorrow's video.
awesome! youre the real MVP! more power to you
Thanks! I love it when people get excited about Power Query! :)
Hi Ruth, again after one year...i would like to thank you for this idea to split my monthly budget to daily budget. It works awesome well.
Excellent to hear :)
At 4.11, Lists is not visible properly
True, you can see the contents after I expand it.
Very cool Ruth! I can think in a different uses for this technique.
Great!