Very neat solution. I've never seen Integer(divide) used before.
@AccessAnalytic
3 ай бұрын
Thanks, I’ve probably only used it a handful of times in real life.
@karolinab9749
2 ай бұрын
Thank you for sharing!!!😊 your videos are not only Excel lessons but also maths. Very clear and logical explanation.
@AccessAnalytic
2 ай бұрын
I appreciate the kind comment. Thank you.
@sledgehammer-productions
3 ай бұрын
First time seeing a sensible use case for an index starting at 0. Also realising that the datamodel in a pivot table kind of looks like things you can do in Power BI (Power BI equals (to me) Dax, and probably the measures too). Mind blown.
@AccessAnalytic
3 ай бұрын
Yes Power BI evolved out of the Excel data model / power pivot. DAX was designed with Excel users in mind. DAX & The Data Model kzitem.info/door/PLlHDyf8d156XzYqAiOd4iLVzJM6ESiaDa Glad it’s opened up some possibilities
@anteus64
2 ай бұрын
wow, this is extremely useful. I always had firewall issues because of the (as just learnt) navigation element in the parameters - thank you for solving this.
@AccessAnalytic
2 ай бұрын
Glad to help.I appreciate you taking the time to let me know you found it useful
@montmraaa
3 ай бұрын
This is excellent. I believe that adding a macro that executes to refresh the pivot table whenever the max capacity value changes, making the update dynamic, would be a great final addition.
@AccessAnalytic
3 ай бұрын
Thank you. Yes that's a nice touch.
@chrishartnell8936
8 күн бұрын
Very elegant solution. You make Excel fun!
@AccessAnalytic
8 күн бұрын
Thank you. I appreciate the kind comment
@rtrbs8383
3 ай бұрын
I adore your quick Power Query techniques videos. Many thanks for that 💌
@AccessAnalytic
3 ай бұрын
Very kind of you to say so
@hubertorhant8884
3 ай бұрын
Really stunning 🙏👍 Love the clarity of the explanation. Many thx
@AccessAnalytic
3 ай бұрын
I appreciate you taking the time to let me know you found it useful
@GrainneDuggan_Excel
3 ай бұрын
Nice solution Wyn!
@AccessAnalytic
3 ай бұрын
Cheers Grainne
@CeliaAlvesSolveExcel
3 ай бұрын
Loved the CONCATENATEX tip, Wyn! A beautiful solution from end to end. Thank you! 🎉
@AccessAnalytic
3 ай бұрын
Thank you Celia, greatly appreciated.
@westleyempeigne6541
Ай бұрын
Love that video Wyn, especially how you integrated the parameter!
@AccessAnalytic
Ай бұрын
Cheers!
@ferdinandsantos6680
3 ай бұрын
What an awesome tutorial! Learned a lot of new things. Thank you so much!😊
@AccessAnalytic
3 ай бұрын
I appreciate you taking the time to let me know you found it useful
@baskis69
3 ай бұрын
Brilliant ....Excel and Power query in action¡¡¡ Thanks for sharing.
@AccessAnalytic
3 ай бұрын
You’re welcome. Thanks for taking the time to leave a kind comment
@iankr
3 ай бұрын
Great techniques! Many thanks, Wyn.
@AccessAnalytic
3 ай бұрын
You’re welcome
@nebo-land
3 ай бұрын
Great solution!
@AccessAnalytic
3 ай бұрын
Thank you 😀
@RonDavidowicz
3 ай бұрын
Great video, not sure how I’d make use of these concepts, but I’ll keep them in the back of my mind. Thank you.
@AccessAnalytic
3 ай бұрын
Cheers, this was inspired by a real life scenario. Every now and again Modulo and Integer Divide come in useful 😁
@BMG21
3 ай бұрын
Wow! This is fantastic, Wyn. You are a star!
@AccessAnalytic
3 ай бұрын
Very kind of you. Thanks 😄
@chrism9037
3 ай бұрын
Wow! Excellent Wyn
@AccessAnalytic
3 ай бұрын
Thanks. I appreciate the kind comment.
@grahamparker7729
3 ай бұрын
Love it, I’m certainly going to use this.
@AccessAnalytic
3 ай бұрын
Excellent. Thanks for taking the time to let me know.
@kppptt
8 сағат бұрын
A great lesson! The explanation is very clear and easy to understand. In the example, which query is more important, "Attendee Data" or "Date"?
@abhishekupadhyay6938
3 ай бұрын
Amazing!!! Thank you very much for sharing.
@AccessAnalytic
3 ай бұрын
You’re very welcome 😀
@Michael_Alaska
3 ай бұрын
That is fantastic! Considering the example, it would be useful if there was some way to balance the count among the sessions. For example, for a max class size of 6 with 7 students signed up it spread them out as 4-3 instead of 6-1.
@AccessAnalytic
3 ай бұрын
Thanks. I think a groupby on Session would give session count
@PSModelling
2 ай бұрын
Very nice, would have probably used a formula approach to try to solve this so interesting to see it done in a more robust way in Power Query.
@AccessAnalytic
2 ай бұрын
Thank you. Dynamic array functionality does open a huge array of options. The new PIVOTBY will take it further again 👍🏼
@petercompton538
2 ай бұрын
Another great video. Thanks very much Wyn
@AccessAnalytic
2 ай бұрын
Thanks so much
@josuezuniga5347
3 ай бұрын
This is beautiful, thanks!
@AccessAnalytic
3 ай бұрын
Thank you for the very kind comment
@ursvenky6394
3 ай бұрын
Simply wow❤
@AccessAnalytic
3 ай бұрын
☺️ thanks
@lekonom9106
Ай бұрын
Thx for the Measure magic.
@AccessAnalytic
Ай бұрын
You’re welcome.
@kennethstephani692
Ай бұрын
Great video!!
@AccessAnalytic
Ай бұрын
Cheers!
@RadAlzyoud
2 ай бұрын
Brilliant. Thanks
@AccessAnalytic
2 ай бұрын
You’re welcome
@ChristosKolokotronis
3 ай бұрын
Very interesting and useful ! Thank you!
@AccessAnalytic
3 ай бұрын
You’re welcome. I appreciate you taking the time to let me know you found it useful
@naveenpragash7584
3 ай бұрын
Very useful video. Thanks!!
@AccessAnalytic
3 ай бұрын
I appreciate you leaving a comment to let me know. Thank you 😀
@muhammadTayyab
3 ай бұрын
Just great 😁
@AccessAnalytic
3 ай бұрын
Thank you 🙏🏼
@AnbarasuAnnamalai
3 ай бұрын
It is a great video, Thank you
@AccessAnalytic
3 ай бұрын
You’re welcome, thank you
@MahanteshMinajagi
2 ай бұрын
Amazing
@AccessAnalytic
2 ай бұрын
Cheers
@swannous
3 ай бұрын
Genius ❤
@AccessAnalytic
3 ай бұрын
Thank you 🙏🏼
@Unknow496
2 ай бұрын
Is it possible to use multiple values for the dynamic range? I normally use a difference solution for the dynamic values and to update sql queries (date range), (product), (value range for filters), etc. I would love to see a video explaining more about it and more examples.
@AccessAnalytic
2 ай бұрын
I don’t quite understand sorry. What do you mean by dynamic range?
@matthewbraun3939
3 ай бұрын
I can't remember is there a way to update the query in Power BI from a slicer?
@AccessAnalytic
3 ай бұрын
Matthew, as far as I know only a direct query can utilises a slicer learn.microsoft.com/en-us/power-bi/connect-data/desktop-dynamic-m-query-parameters In power bi desktop you can set up a power query parameter which can then be input manually on each refresh
Пікірлер: 76