Uploaded July 2026 | Updated November 2026, 1 day ago
If you've ever written a running total in DAX, you know it's 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.
They're a calculation layer that lives inside the visual itself, working on the data that's already been aggregated rather than querying the whole model. That's also why they're 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 that's the part that quietly breaks people's running totals across years.
One honest caveat. Yes, they're easier and faster. But because each one only lives in a single visual, they can fragment your business logic across reports if you're 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 -- go-ae.org/hc-yt-visual-calc-guide
BECOME A CHANNEL MEMBER π
-- youtube.com/channel/UCjlfQwqb-0S40XQ8seYPLSw/join
CHECK OUT OUR MERCH STORE π
-- havens-consulting.creator-spring.com
LET'S CONNECT! π§π½βπ€βπ§π½ π
-- linkedin.com/in/reidhavens
-- youtube.com/c/HavensConsulting
BUSINESS PAGES π
Home Page - havensconsulting.net/?utm_source=youtube-hc&utm_medium=video&utm_campaign=VEwGH6i2aeE
Blog -- havensconsulting.net/blog-and-media?utm_source=youtube-hc&utm_medium=video&utm_campaign=VEwGH6i2aeE
Blog Files -- havensconsulting.net/blog-files?utm_source=youtube-hc&utm_medium=video&utm_campaign=VEwGH6i2aeE
Files & Templates -- havensconsulting.net/files-and-templates?utm_source=youtube-hc&utm_medium=video&utm_campaign=VEwGH6i2aeE
Consulting Services -- havensconsulting.net/consulting-services?utm_source=youtube-hc&utm_medium=video&utm_campaign=VEwGH6i2aeE
Online Courses -- havensconsulting.net/online-courses?utm_source=youtube-hc&utm_medium=video&utm_campaign=VEwGH6i2aeE
Contact & Support - havensconsulting.net/contact-and-support?utm_source=youtube-hc&utm_medium=video&utm_campaign=VEwGH6i2aeE
Analytic Endeavors-- go.analyticendeavors.com/86d335734f
EMAIL US AT π§
info@havensconsulting.net
#PowerBI #DAX #DataVisualization #MicrosoftFabric #BusinessIntelligence
If you've ever written a running total in DAX, you know it's 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.
They're a calculation layer that lives inside the visual itself, working on the data that's already been aggregated rather than querying the whole model. That's also why they're 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 that's the part that quietly breaks people's running totals across years.
One honest caveat. Yes, they're easier and faster. But because each one only lives in a single visual, they can fragment your business logic across reports if you're 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 -- go-ae.org/hc-yt-visual-calc-guide
BECOME A CHANNEL MEMBER π
-- youtube.com/channel/UCjlfQwqb-0S40XQ8seYPLSw/join
CHECK OUT OUR MERCH STORE π
-- havens-consulting.creator-spring.com
LET'S CONNECT! π§π½βπ€βπ§π½ π
-- linkedin.com/in/reidhavens
-- youtube.com/c/HavensConsulting
BUSINESS PAGES π
Home Page - havensconsulting.net/?utm_source=youtube-hc&utm_medium=video&utm_campaign=VEwGH6i2aeE
Blog -- havensconsulting.net/blog-and-media?utm_source=youtube-hc&utm_medium=video&utm_campaign=VEwGH6i2aeE
Blog Files -- havensconsulting.net/blog-files?utm_source=youtube-hc&utm_medium=video&utm_campaign=VEwGH6i2aeE
Files & Templates -- havensconsulting.net/files-and-templates?utm_source=youtube-hc&utm_medium=video&utm_campaign=VEwGH6i2aeE
Consulting Services -- havensconsulting.net/consulting-services?utm_source=youtube-hc&utm_medium=video&utm_campaign=VEwGH6i2aeE
Online Courses -- havensconsulting.net/online-courses?utm_source=youtube-hc&utm_medium=video&utm_campaign=VEwGH6i2aeE
Contact & Support - havensconsulting.net/contact-and-support?utm_source=youtube-hc&utm_medium=video&utm_campaign=VEwGH6i2aeE
Analytic Endeavors-- go.analyticendeavors.com/86d335734f
EMAIL US AT π§
info@havensconsulting.net
#PowerBI #DAX #DataVisualization #MicrosoftFabric #BusinessIntelligence

![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)








