Combinations And Permutations In Power Query

[@melissa3558]

What an amazing video Brian!
Like combinatorial analysis for dummies (I mean that in the best possible way - should anyone wonder)

[@josephansah]

Kudos Brian. Such a well explained video. It made what I have found to be tricky in the past seem like a walk in the park.

[@EnterpriseDNA]

Hi Mojo Jojo, thanks for the continued support!

[@DroneEyesInTheSkies]

Great video!! Thank you for sharing!

[@EnterpriseDNA]

Hi Raphael, glad that you appreciated our content! If you haven't yet, you can subscribe to our channel to see all our upcoming Power BI and Power Platform video tutorials and announcements. Cheers!

[@OzduSoleilDATA]

Good and thorough! I like. 🙌

[@EnterpriseDNA]

Hi Excel On Fire, glad that you appreciated our content! If you haven't yet, you can subscribe to our channel to see all our upcoming Power BI and Power Platform video tutorials and announcements. Cheers!

[@OzduSoleilDATA]

Yup! I subscribed and look forward to watching and learning. 👍🏽

[@pntgrl80]

Great Video!

[@EnterpriseDNA]

Hi Gabriella Penitente, glad you appreciated the video. You can subscribe to our channel to see all our upcoming Power BI video tutorials.
Here’s the link: czcams.com/channels/y2rBgj4M1tzK-urTZ28zcA.html

[@user-wx3dn3il2f]

I mainly use python library for permutation and combination! but power query seems be more powerful and easy to apply for any case(Power Query is familiar with may excel user)

[@EnterpriseDNA]

Hi 김차수, glad you appreciated the video. You can subscribe to our channel to see all our upcoming Power BI video tutorials.
Here’s the link: czcams.com/channels/y2rBgj4M1tzK-urTZ28zcA.html

[@SairamBalasubramaniam]

Thank you! Kudos for looking from a management science perspective. Can this code be extrapolated to solve a travelling salesman problem where we incorporate the distance matrix. Can we incorporate a solver feature using M

[@EnterpriseDNA]

Hi Sairam,
Thank you for posting your query onto our channel. We really appreciate you taking your valuable time to post it.
Well it's always a little bit difficult to judge and provide the results without looking at the data structure, model and working of the PBIX file for the reference.
And therefore we encourage you to please write back to us onto our Community Forum by providing the proper description of the problem that you're facing along with the PBIX file for the reference as well as the mock-up results that you're trying to achieve where our members as well as experts team will be able to assist you in a better and efficient manner. Below is the link of the forum provided for the reference.
Hoping you find this useful. Subscribe to our CZcams channel so that you don't miss out on any updates pertaining to the Power BI. You can also join our Power BI group on LinkedIn to receive latest updates on Power BI. Below are the links provided for the reference purposes.
Cheers,
Enterprise DNA
forum.enterprisedna.co/
czcams.com/channels/y2rBgj4M1tzK-urTZ28zcA.html
www.linkedin.com/groups/12004506/

[@speulstra]

where exactly can I find this?I do have a membership, If I look on your site I can not find the model and or code

[@EnterpriseDNA]

Hi @speulstra - please do send us a message with your Enterprise DNA On-Demand account details for verification along with your concern at [e-mail] for further assistance. Thank you!

[@DinoAMAntunes]

Hi, Please i am Trying to find an example for Cartesian Product in Power Query. Multiple tables with multiple column in the same workbook, with some equal transformation and some diferents. Any example please. Tks in advance

[@EnterpriseDNA]

Hello Dino Antunes,
thank you for posting your query onto our channel.
We're providing some of the link of the articles as well as videos based onto this topic.
For furthermore queries, you can also reach out to us onto our Community Forum where our members as well as experts team will be able to assist you in a better and efficient manner. Below is the link of the forum provided for the reference as well.
Hoping you find this useful and meets your requirements that you've been looking for.
Happy Learning!!!
czcams.com/video/F32rLlSzEzQ/video.html
radacad.com/cartesian-product-in-power-query-multiply-all-sets-of-all-pairs-in-power-bi
czcams.com/video/4FsFJPuN6Ro/video.html
forum.enterprisedna.co/

[@abdulazimsulman2496]

Hello there, pardon my ignorance. Is the code for the custom function available or do I have to buy it?

[@EnterpriseDNA]

Hi Abdul, thanks for posting your comment in the video. All pbix file/datasets/code are available for download in the Enterprise DNA Online, which is accessible via Membership. Find link below. Thanks!
portal.enterprisedna.co/

[@user-wx3dn3il2f]

why do you this m function expresiion? List.Transform(_,Text.From) is it essential for your function?

[@EnterpriseDNA]

Hello 김차수,
thank you for posting your query onto our channel.
Well yes, it's absolutely essential into the function that we've created. It works as a "Delimiter" into the function and separates the locations using the "," (symbol - comma).
For furthermore queries, you can also reach out to us onto our Community Forum where our members as well as experts team will be able to assist you in a better and efficient manner. Below is the link of the forum provided for the reference.
Hoping you'll find this useful and helpful.
Happy Learning!!!
forum.enterprisedna.co/