Uploaded January 2024 | Updated November 2026, 1 day ago
DAX Optimizer is a tool that performs a deep, static analysis of your DAX code, to identify possible performance bottlenecks and provide prioritized suggestions to fix the code starting on the more impactful areas.
The tool is the result of years of research and development, it was unveiled in June 2023 and has been in public preview since October 2023 β now we are very close to the general availability and almost feature complete!
We will explore the tool with Marco Russo, who participated in the development since the beginning and can provide any kind of insights about how to get the best from DAX Optimizer.
GUEST BIO (Marco Russo) π€
Marco Russo wrote several books about DAX with Alberto Ferrari. They produce articles and videos on sqlbi.com and teach DAX and data modeling classes worldwide. Marco also worked in the last few years on DAX Optimizer, a tool produced and distributed by Tabular Tools.
RELATED CONTENT π
DAX Optimizer Website -- daxoptimizer.com
DAX Optimizer Documentation -- docs.daxoptimizer.com
DAX Optimizer news -- daxoptimizer.com/blog
SQLBI -- sqlbi.com
Tabular Tools -- tabulartools.com
VIDEO CHAPTERS πΊ
0:00 - Video Start
5:00 - Start of Livestream
LET'S CONNECT! π§π½βπ€βπ§π½π
-- twitter.com/HavensBI
-- linkedin.com/in/reidhavens
-- youtube.com/c/HavensConsulting
CHECK OUT OUR MERCH STORE π
-- havens-consulting.creator-spring.com
HAVENS CONSULTING PAGES π
Home Page -- havensconsulting.net/?utm_source=youtube-hc&utm_medium=video&utm_campaign=TD_1IfISpkA
Blog -- havensconsulting.net/blog-and-media?utm_source=youtube-hc&utm_medium=video&utm_campaign=TD_1IfISpkA
Blog Files -- havensconsulting.net/blog-files?utm_source=youtube-hc&utm_medium=video&utm_campaign=TD_1IfISpkA
Files & Templates -- havensconsulting.net/files-and-templates?utm_source=youtube-hc&utm_medium=video&utm_campaign=TD_1IfISpkA
Consulting Services -- havensconsulting.net/consulting-services?utm_source=youtube-hc&utm_medium=video&utm_campaign=TD_1IfISpkA
Online Course -- havensconsulting.net/online-courses?utm_source=youtube-hc&utm_medium=video&utm_campaign=TD_1IfISpkA
Contact & Support -- havensconsulting.net/contact-and-support?utm_source=youtube-hc&utm_medium=video&utm_campaign=TD_1IfISpkA
EMAIL US AT π§
info@havensconsulting.net
#PowerBI #powerplatform #microsoft #businessintelligence #datascience #data #dataanalytics #excel #powerapps #datavisualization #dashboard #bi #analytics #dax #powerquery #fabric #tabulartools #daxoptimizer #daxformatter #sqlbi
DAX Optimizer is a tool that performs a deep, static analysis of your DAX code, to identify possible performance bottlenecks and provide prioritized suggestions to fix the code starting on the more impactful areas.
The tool is the result of years of research and development, it was unveiled in June 2023 and has been in public preview since October 2023 β now we are very close to the general availability and almost feature complete!
We will explore the tool with Marco Russo, who participated in the development since the beginning and can provide any kind of insights about how to get the best from DAX Optimizer.
GUEST BIO (Marco Russo) π€
Marco Russo wrote several books about DAX with Alberto Ferrari. They produce articles and videos on sqlbi.com and teach DAX and data modeling classes worldwide. Marco also worked in the last few years on DAX Optimizer, a tool produced and distributed by Tabular Tools.
RELATED CONTENT π
DAX Optimizer Website -- daxoptimizer.com
DAX Optimizer Documentation -- docs.daxoptimizer.com
DAX Optimizer news -- daxoptimizer.com/blog
SQLBI -- sqlbi.com
Tabular Tools -- tabulartools.com
VIDEO CHAPTERS πΊ
0:00 - Video Start
5:00 - Start of Livestream
LET'S CONNECT! π§π½βπ€βπ§π½π
-- twitter.com/HavensBI
-- linkedin.com/in/reidhavens
-- youtube.com/c/HavensConsulting
CHECK OUT OUR MERCH STORE π
-- havens-consulting.creator-spring.com
HAVENS CONSULTING PAGES π
Home Page -- havensconsulting.net/?utm_source=youtube-hc&utm_medium=video&utm_campaign=TD_1IfISpkA
Blog -- havensconsulting.net/blog-and-media?utm_source=youtube-hc&utm_medium=video&utm_campaign=TD_1IfISpkA
Blog Files -- havensconsulting.net/blog-files?utm_source=youtube-hc&utm_medium=video&utm_campaign=TD_1IfISpkA
Files & Templates -- havensconsulting.net/files-and-templates?utm_source=youtube-hc&utm_medium=video&utm_campaign=TD_1IfISpkA
Consulting Services -- havensconsulting.net/consulting-services?utm_source=youtube-hc&utm_medium=video&utm_campaign=TD_1IfISpkA
Online Course -- havensconsulting.net/online-courses?utm_source=youtube-hc&utm_medium=video&utm_campaign=TD_1IfISpkA
Contact & Support -- havensconsulting.net/contact-and-support?utm_source=youtube-hc&utm_medium=video&utm_campaign=TD_1IfISpkA
EMAIL US AT π§
info@havensconsulting.net
#PowerBI #powerplatform #microsoft #businessintelligence #datascience #data #dataanalytics #excel #powerapps #datavisualization #dashboard #bi #analytics #dax #powerquery #fabric #tabulartools #daxoptimizer #daxformatter #sqlbi




![Simplify Power BI DAX with Visual Calculations
If youve ever written a running total in DAX, you know its more work than it has any right to be. CALCULATE, FILTER, a column reference you have to get exactly right, and a quiet prayer that it behaves at the subtotal level. Visual calculations let you write RUNNINGSUM([Sales]) and get on with your day.
Theyre a calculation layer that lives inside the visual itself, working on the data thats already been aggregated rather than querying the whole model. Thats also why theyre often faster, sometimes dramatically so on DirectQuery.
I walk through the core functions (running totals, moving averages, PREVIOUS and NEXT for period comparisons, FIRST, LAST, INDEX, and RANK), then the hierarchy functions like COLLAPSE and EXPAND that make % of parent and % of grand total almost trivial. We also get into AXIS and RESET, which control the direction a calculation runs and where it restarts, because thats the part that quietly breaks peoples running totals across years.
One honest caveat. Yes, theyre easier and faster. But because each one only lives in a single visual, they can fragment your business logic across reports if youre not careful, so I cover when a visual calc is the right call and when it really should be a centralized measure.
RELATED CONTENT π
Visual Calculations Guide https://go-ae.org/hc-yt-visual-calc-guide
BECOME A CHANNEL MEMBER π
https://www.youtube.com/channel/UCjlfQwqb-0S40XQ8seYPLSw/join
CHECK OUT OUR MERCH STORE π
https://havens-consulting.creator-spring.com/
LETS CONNECT! π§π½βπ€βπ§π½ π
https://www.linkedin.com/in/reidhavens
https://www.youtube.com/c/HavensConsulting
BUSINESS PAGES π
Home Page - http://www.havensconsulting.net/?utm_source=youtube-hc&utm_medium=video&utm_campaign=VEwGH6i2aeE
Blog http://www.havensconsulting.net/blog-and-media?utm_source=youtube-hc&utm_medium=video&utm_campaign=VEwGH6i2aeE
Blog Files http://www.havensconsulting.net/blog-files?utm_source=youtube-hc&utm_medium=video&utm_campaign=VEwGH6i2aeE
Files & Templates http://www.havensconsulting.net/files-and-templates?utm_source=youtube-hc&utm_medium=video&utm_campaign=VEwGH6i2aeE
Consulting Services http://www.havensconsulting.net/consulting-services?utm_source=youtube-hc&utm_medium=video&utm_campaign=VEwGH6i2aeE
Online Courses https://www.havensconsulting.net/online-courses?utm_source=youtube-hc&utm_medium=video&utm_campaign=VEwGH6i2aeE
Contact & Support - http://www.havensconsulting.net/contact-and-support?utm_source=youtube-hc&utm_medium=video&utm_campaign=VEwGH6i2aeE
Analytic Endeavors https://go.analyticendeavors.com/86d335734f
EMAIL US AT π§
info@havensconsulting.net
#PowerBI #DAX #DataVisualization #MicrosoftFabric #BusinessIntelligence Simplify Power BI DAX with Visual Calculations](https://i.ytimg.com/vi/VEwGH6i2aeE/mqdefault.jpg)

![Communication is the New Code: Beyond Copy/Paste with GPTs (with Kurt Buhler)
The landscape of Power BI development is rapidly evolving as AI tools transform how we approach data modeling, DAX development, and report creation. While many professionals are familiar with ChatGPT, the ecosystem of AI assistance has expanded dramatically, offering specialized tools that can revolutionize your Power BI workflow.
In this comprehensive session, well explore cutting-edge AI tools that go far beyond basic chatbots:
π€ Claude Desktop & MCP Servers - Discover how Claudes advanced reasoning capabilities and Model Context Protocol (MCP) servers can provide deeper insights into your data models, suggest optimizations, and help debug complex DAX expressions with unprecedented accuracy.
β‘ GitHub Copilot for Power BI - Learn how this code completion tool adapts to Power BI development, accelerating DAX writing, M queries, and even documentation generation.
π Advanced AI Workflows - See real-world demonstrations of AI-assisted Power BI development, from automated measure generation to intelligent data modeling suggestions.
Well provide an honest assessment of these tools - the goods (incredible productivity gains), the bads (current limitations), and the uglies (potential pitfalls and over-reliance risks). Youll leave with practical strategies to integrate these AI tools into your daily Power BI development process.
Whether youre a seasoned Power BI developer or just getting started, this session will show you how communication truly is the new code in our AI-augmented world.
GUEST BIO (Kurt Buhler)π€
Kurt Buhler is a renowned Power BI expert and prolific content creator. Follow his insights and tutorials at [Kurts Blog] and connect with the community using #PowerBI #AITools #DataAnalytics #DAX #PowerPlatform #ArtificialIntelligence #DataModeling #BusinessIntelligence
RELATED CONTENT π
Data Goblins https://data-goblins.com/
LETS CONNECT! π§π½βπ€βπ§π½ π
https://twitter.com/HavensBI
https://www.linkedin.com/in/reidhavens
https://www.youtube.com/c/HavensConsulting
HAVENS CONSULTING PAGES π
Home Page http://www.havensconsulting.net/?utm_source=youtube-hc&utm_medium=video&utm_campaign=W3EvSNt2ZWg
Blog http://www.havensconsulting.net/blog-and-media?utm_source=youtube-hc&utm_medium=video&utm_campaign=W3EvSNt2ZWg
Blog Files http://www.havensconsulting.net/blog-files?utm_source=youtube-hc&utm_medium=video&utm_campaign=W3EvSNt2ZWg
Files & Templates http://www.havensconsulting.net/files-and-templates?utm_source=youtube-hc&utm_medium=video&utm_campaign=W3EvSNt2ZWg
Consulting Services http://www.havensconsulting.net/consulting-services?utm_source=youtube-hc&utm_medium=video&utm_campaign=W3EvSNt2ZWg
Online Course https://www.havensconsulting.net/online-courses?utm_source=youtube-hc&utm_medium=video&utm_campaign=W3EvSNt2ZWg
Contact & Support http://www.havensconsulting.net/contact-and-support?utm_source=youtube-hc&utm_medium=video&utm_campaign=W3EvSNt2ZWg
EMAIL US AT π§
info@havensconsulting.net Communication is the New Code: Beyond Copy/Paste with GPTs (with Kurt Buhler)](https://i.ytimg.com/vi/W3EvSNt2ZWg/mqdefault.jpg)



