515: DAX Complexity & Power Query ETL 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/