Skip to content
515: DAX Complexity & Power Query ETL Tips episode artwork

Mar 31, 2026 1 hr 7 min

515: DAX Complexity & Power Query ETL Tips

from Explicit Measures Podcast Hosted by PowerBI.Tips

Mike & Tommy dive into DAX complexity and Power Query ETL tips, tackling how to structure complex measures that balance readability and performance across nested time intelligence, dynamic filters, and multi-grain data. They explore advanced Power Query techniques for reducing refresh times in Fabric Dataflows Gen2 and SharePoint integrations, with practical advice on optimizing step folding and reusing logic across queries. Get in touch: Send in your questions or topics you want us to discuss by tweeting to @PowerBITips with the hashtag #empMailbag or submit on the PowerBI.tips Podcast Page. Visit PowerBI.tips: https://powerbi.tips/ Watch the episodes live every Tuesday and Thursday morning at 730am CST on YouTube: https://www.youtube.com/powerbitips Subscribe on Spotify: https://open.spotify.com/show/230fp78XmHHRXTiYICRLVv Subscribe on Apple: https://podcasts.apple.com/us/podcast/explicit-measures-podcast/id1568944083‎ Check Out Community Jam: https://jam.powerbi.tips Follow Mike: https://www.linkedin.com/in/michaelcarlo/ Follow Tommy: https://www.linkedin.com/in/tommypuglia/

Episode details come from the podcast's RSS feed.

Embed this episode

Ready to play

515: DAX Complexity & Power Query ETL Tips

0:00 1:07:12

No transcript yet.

Requests help us decide what to transcribe next.

Frequently asked questions

How long is this episode of Explicit Measures Podcast?

This episode is 1 hour and 7 minutes long.

When was this Explicit Measures Podcast episode published?

This episode was published on March 31, 2026.

Can I download this Explicit Measures Podcast episode?

Yes. Use the download control on the episode player to save the publisher-provided media file.