This feels like magic! Talk about an excel guru!

@AccessAnalytic

12 күн бұрын

Cheers, thanks for the kind comment.

Thank you for sharing!!!😊 your videos are not only Excel lessons but also maths. Very clear and logical explanation.

@AccessAnalytic

7 күн бұрын

I appreciate the kind comment. Thank you.

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

7 күн бұрын

Glad to help.I appreciate you taking the time to let me know you found it useful

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

12 күн бұрын

Yes Power BI evolved out of the Excel data model / power pivot. DAX was designed with Excel users in mind. DAX & The Data Model kzread.info/head/PLlHDyf8d156XzYqAiOd4iLVzJM6ESiaDa Glad it’s opened up some possibilities

Loved the CONCATENATEX tip, Wyn! A beautiful solution from end to end. Thank you! 🎉

@AccessAnalytic

11 күн бұрын

Thank you Celia, greatly appreciated.

Very neat solution. I've never seen Integer(divide) used before.

@AccessAnalytic

12 күн бұрын

Thanks, I’ve probably only used it a handful of times in real life.

I adore your quick Power Query techniques videos. Many thanks for that 💌

@AccessAnalytic

12 күн бұрын

Very kind of you to say so

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

12 күн бұрын

Thank you. Yes that's a nice touch.

What an awesome tutorial! Learned a lot of new things. Thank you so much!😊

@AccessAnalytic

10 күн бұрын

I appreciate you taking the time to let me know you found it useful

Great techniques! Many thanks, Wyn.

@AccessAnalytic

12 күн бұрын

You’re welcome

Really stunning 🙏👍 Love the clarity of the explanation. Many thx

@AccessAnalytic

12 күн бұрын

I appreciate you taking the time to let me know you found it useful

Wow! This is fantastic, Wyn. You are a star!

@AccessAnalytic

11 күн бұрын

Very kind of you. Thanks 😄

Brilliant ....Excel and Power query in action¡¡¡ Thanks for sharing.

@AccessAnalytic

11 күн бұрын

You’re welcome. Thanks for taking the time to leave a kind comment

Great solution!

@AccessAnalytic

12 күн бұрын

Thank you 😀

Wow! Excellent Wyn

@AccessAnalytic

12 күн бұрын

Thanks. I appreciate the kind comment.

Nice solution Wyn!

@AccessAnalytic

12 күн бұрын

Cheers Grainne

Love it, I’m certainly going to use this.

@AccessAnalytic

9 күн бұрын

Excellent. Thanks for taking the time to let me know.

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

12 күн бұрын

Cheers, this was inspired by a real life scenario. Every now and again Modulo and Integer Divide come in useful 😁

Amazing!!! Thank you very much for sharing.

@AccessAnalytic

11 күн бұрын

You’re very welcome 😀

Another great video. Thanks very much Wyn

@AccessAnalytic

6 күн бұрын

Thanks so much

Simply wow❤

@AccessAnalytic

12 күн бұрын

☺️ thanks

This is beautiful, thanks!

@AccessAnalytic

10 күн бұрын

Thank you for the very kind comment

Brilliant. Thanks

@AccessAnalytic

3 күн бұрын

You’re welcome

Very interesting and useful ! Thank you!

@AccessAnalytic

10 күн бұрын

You’re welcome. I appreciate you taking the time to let me know you found it useful

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

11 күн бұрын

Thanks. I think a groupby on Session would give session count

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

5 күн бұрын

Thank you. Dynamic array functionality does open a huge array of options. The new PIVOTBY will take it further again 👍🏼

Very useful video. Thanks!!

@AccessAnalytic

10 күн бұрын

I appreciate you leaving a comment to let me know. Thank you 😀

Just great 😁

@AccessAnalytic

11 күн бұрын

Thank you 🙏🏼

Amazing

@AccessAnalytic

5 күн бұрын

Cheers

It is a great video, Thank you

@AccessAnalytic

12 күн бұрын

You’re welcome, thank you

Genius ❤

@AccessAnalytic

12 күн бұрын

Thank you 🙏🏼

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

5 күн бұрын

I don’t quite understand sorry. What do you mean by dynamic range?

I can't remember is there a way to update the query in Power BI from a slicer?

@AccessAnalytic

10 күн бұрын

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