LightNews — News, ranked by scholars

Alex Power[s]

“Thank you for this challenge. I was looking to practice more M language, anything related to PQ, I love it!” - #30DQUERY Participant

Seriously, thank you and I hope you look back after 30 days and are proud of the growth you achieved and the new connections made helping others.

November 18, 2024 at 11:52 AM

Alex Power[s]

@itsnotaboutthecell.com

My life's work. Query Folding In An Hour - 2021.

#PowerQuery #30DQUERY

November 18, 2024 at 10:04 AM

Alex Power[s]

@itsnotaboutthecell.com

https://www.youtube.com/playlist?list=PLKW7XPyNDgRCorKNS1bfZoAO3YSIAVz3N

30 Day Challenge: Query Folding - #30DQUERY

For 30 days you will be presented with a daily query fold...

www.youtube.com

November 18, 2024 at 8:46 AM

Alex Power[s]

@itsnotaboutthecell.com

30 Days. 30 #PowerQuery Query Folding Challenges. Subscribe to stay up to date, share your own solutions using the hashtag #30DQUERY

YouTube: https://www.youtube.com/playlist?list=PLKW7XPyNDgRCorKNS1bfZoAO3YSIAVz3N

Note: There's no one right answer, but there is a wrong one, don't...

November 18, 2024 at 8:34 AM

Alex Power[s]

@itsnotaboutthecell.com

Checking #Reddit, #Twitter, #LinkedIn, #Facebook and #YouTube for #30DQUERY submissions from the #Excel and #PowerBI community. The only way we get to the top of the mountain is if we go together, love seeing you all helping each other out.

#PowerQuery #MDBA #BetterTogether 💛💚

November 18, 2024 at 8:34 AM

Alex Power[s]

@itsnotaboutthecell.com

DAY 3 - Query Folding Challenge - #30DQUERY - The native query might start getting a bit ugly with this one. Watch the order of applied steps!

Beautify M: https://powerqueryformatter.com

#PowerQuery #PowerBI #Excel...

November 18, 2024 at 8:34 AM

Alex Power[s]

@itsnotaboutthecell.com

The war wages on. #Spaces vs. #Tabs - make that #30DQUERY beautiful.

#PowerQuery #M #Excel #PowerBI

November 18, 2024 at 8:34 AM

Alex Power[s]

@itsnotaboutthecell.com

DAY 4 - Query Folding Challenge - #30DQUERY - MATH! Cursed MATH!... You got this though.

Beautify M: https://powerqueryformatter.com

#PowerQuery #PowerBI #Excel #PowerPlatform #M

https://www.youtube.com/playlist?list=PLKW7XPyNDgRCorKNS1bfZoAO3YSIAVz3N

November 18, 2024 at 8:34 AM

Alex Power[s]

@itsnotaboutthecell.com

DAY 5 - Query Folding Challenge - #30DQUERY - Double, doubly, query folding troubles.

Beautify M: https://powerqueryformatter.com

#PowerQuery #PowerBI #Excel #PowerPlatform #M

https://www.youtube.com/playlist?list=PLKW7XPyNDgRCorKNS1bfZoAO3YSIAVz3N

November 18, 2024 at 8:34 AM

Alex Power[s]

@itsnotaboutthecell.com

DAY 6 - Query Folding Challenge - #30DQUERY - I'm sure you'll want to get even with me after this one.

Beautify M: https://powerqueryformatter.com

#PowerQuery #PowerBI #Excel #PowerPlatform #M

https://www.youtube.com/playlist?list=PLKW7XPyNDgRCorKNS1bfZoAO3YSIAVz3N

November 18, 2024 at 8:33 AM

Alex Power[s]

@itsnotaboutthecell.com

Quick Q for the #30DQUERY crew. Have you started looking back at some of your own queries? Any optimization opportunities you’ve been able to realize to reduce dataset refresh times?

November 18, 2024 at 8:33 AM

Alex Power[s]

@itsnotaboutthecell.com

DAY 7 – Query Folding Challenge - #30DQUERY - The key to this one is a solution that's future proofed.

Beautify M: https://powerqueryformatter.com

#PowerQuery #PowerBI #Excel #PowerPlatform #M

https://www.youtube.com/playlist?list=PLKW7XPyNDgRCorKNS1bfZoAO3YSIAVz3N

November 18, 2024 at 8:33 AM

Alex Power[s]

@itsnotaboutthecell.com

#M

https://www.youtube.com/playlist?list=PLKW7XPyNDgRCorKNS1bfZoAO3YSIAVz3N

30 Day Challenge: Query Folding - #30DQUERY

For 30 days you will be presented with a daily query fold...

www.youtube.com

November 18, 2024 at 8:33 AM

Alex Power[s]

@itsnotaboutthecell.com

https://github.com/itsnotaboutthecell/powerquerym/tree/master/%2330DQUERY

powerquerym/#30DQUERY at master · itsnotaboutthecell/powe...

Power Query M. Contribute to itsnotaboutthecell/powerquer...

github.com

November 18, 2024 at 8:33 AM

Alex Power[s]

@itsnotaboutthecell.com

#M

https://www.youtube.com/playlist?list=PLKW7XPyNDgRCorKNS1bfZoAO3YSIAVz3N

30 Day Challenge: Query Folding - #30DQUERY

For 30 days you will be presented with a daily query fold...

www.youtube.com

November 18, 2024 at 8:33 AM

Alex Power[s]

@itsnotaboutthecell.com

#30DQUERY got a shout out on Office Flash Friday! If you aren't already subscribed to @toddkitta and @dsplinter's week-in-review - DO IT. NOW! It's a great show that condenses the fire hoses worth of content that's constantly being pushed....

November 18, 2024 at 8:19 AM

Alex Power[s]

@itsnotaboutthecell.com

DAY 8 – Query Folding Challenge - #30DQUERY - This one may end up being a bit of a leap.

Beautify M: https://powerqueryformatter.com

#PowerQuery #PowerBI #Excel #PowerPlatform #M

https://www.youtube.com/playlist?list=PLKW7XPyNDgRCorKNS1bfZoAO3YSIAVz3N

The page is temporarily unavailable

powerqueryformatter.com

November 18, 2024 at 8:19 AM

Alex Power[s]

@itsnotaboutthecell.com

DAY 9 – Query Folding Challenge - #30DQUERY - The list is way too long for how I would try to pivot out of this tricky one, including making sure it actually loads.

Beautify M: https://powerqueryformatter.com

#PowerQuery #PowerBI #Excel #PowerPlatform...

The page is temporarily unavailable

powerqueryformatter.com

November 18, 2024 at 8:19 AM

Alex Power[s]

@itsnotaboutthecell.com

DAY 10 – Query Folding Challenge - #30DQUERY - The temple run is always better when going with friends.

Beautify M: https://powerqueryformatter.com

#PowerQuery #PowerBI #Excel #PowerPlatform #M

https://www.youtube.com/playlist?list=PLKW7XPyNDgRCorKNS1bfZoAO3YSIAVz3N

The page is temporarily unavailable

powerqueryformatter.com

November 18, 2024 at 8:19 AM

Alex Power[s]

@itsnotaboutthecell.com

#30DQUERY - "MY" Solutions for Day's 1 thru 10. Seriously, the only right answer is the one that folds. You can always play with the code to get it to perform better. Notice that I use Table.Join() quite a bit as this avoids the expanding column....

November 18, 2024 at 8:19 AM