Uploaded April 2026 | Updated November 2026, 1 day ago
Start thinking in DAX instead of Excel. This interactive guide walks through everything you need to build a mental model for Power BI calculations: what DAX actually is, how measures differ from calculated columns, table and column references, star schema basics, and how filters flow from dimension to fact tables. Part 1 of a 3 part DAX Fundamentals series.
Topics covered:
Excel formulas vs DAX: what changes and why
Measures vs calculated columns: when to use each
DAX syntax: table references, column references, and measure calls
Star schema: fact tables, dimension tables, and relationships
Filter flow: how slicers and relationships shape your results
RELATED CONTENT ๐
DAX Foundations Guide (Series Part 1) -- go-ae.org/hc-yt-p1-dax-foundations-guide
DAX Context Guide (Series Part 2) -- go-ae.org/hc-yt-p1-dax-context-guide
DAX Patterns Guide (Series Part 3) -- go-ae.org/hc-yt-p1-dax-patterns-guide
Modern DAX Guide (Series Part 4) -- go-ae.org/hc-yt-p1-modern-dax-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=SpRmi6jNvM8
Blog -- havensconsulting.net/blog-and-media?utm_source=youtube-hc&utm_medium=video&utm_campaign=SpRmi6jNvM8
Blog Files -- havensconsulting.net/blog-files?utm_source=youtube-hc&utm_medium=video&utm_campaign=SpRmi6jNvM8
Files & Templates -- havensconsulting.net/files-and-templates?utm_source=youtube-hc&utm_medium=video&utm_campaign=SpRmi6jNvM8
Consulting Services -- havensconsulting.net/consulting-services?utm_source=youtube-hc&utm_medium=video&utm_campaign=SpRmi6jNvM8
Online Courses -- havensconsulting.net/online-courses?utm_source=youtube-hc&utm_medium=video&utm_campaign=SpRmi6jNvM8
Contact & Support - havensconsulting.net/contact-and-support?utm_source=youtube-hc&utm_medium=video&utm_campaign=SpRmi6jNvM8
Analytic Endeavors-- go.analyticendeavors.com/8bce8622e9
EMAIL US AT ๐ง
info@havensconsulting.net
#PowerBI #DAX #DAXFormulas #PowerBITutorial #DataModeling #StarSchema #BusinessIntelligence #PowerBITips #DataAnalytics #LearnPowerBI
Start thinking in DAX instead of Excel. This interactive guide walks through everything you need to build a mental model for Power BI calculations: what DAX actually is, how measures differ from calculated columns, table and column references, star schema basics, and how filters flow from dimension to fact tables. Part 1 of a 3 part DAX Fundamentals series.
Topics covered:
Excel formulas vs DAX: what changes and why
Measures vs calculated columns: when to use each
DAX syntax: table references, column references, and measure calls
Star schema: fact tables, dimension tables, and relationships
Filter flow: how slicers and relationships shape your results
RELATED CONTENT ๐
DAX Foundations Guide (Series Part 1) -- go-ae.org/hc-yt-p1-dax-foundations-guide
DAX Context Guide (Series Part 2) -- go-ae.org/hc-yt-p1-dax-context-guide
DAX Patterns Guide (Series Part 3) -- go-ae.org/hc-yt-p1-dax-patterns-guide
Modern DAX Guide (Series Part 4) -- go-ae.org/hc-yt-p1-modern-dax-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=SpRmi6jNvM8
Blog -- havensconsulting.net/blog-and-media?utm_source=youtube-hc&utm_medium=video&utm_campaign=SpRmi6jNvM8
Blog Files -- havensconsulting.net/blog-files?utm_source=youtube-hc&utm_medium=video&utm_campaign=SpRmi6jNvM8
Files & Templates -- havensconsulting.net/files-and-templates?utm_source=youtube-hc&utm_medium=video&utm_campaign=SpRmi6jNvM8
Consulting Services -- havensconsulting.net/consulting-services?utm_source=youtube-hc&utm_medium=video&utm_campaign=SpRmi6jNvM8
Online Courses -- havensconsulting.net/online-courses?utm_source=youtube-hc&utm_medium=video&utm_campaign=SpRmi6jNvM8
Contact & Support - havensconsulting.net/contact-and-support?utm_source=youtube-hc&utm_medium=video&utm_campaign=SpRmi6jNvM8
Analytic Endeavors-- go.analyticendeavors.com/8bce8622e9
EMAIL US AT ๐ง
info@havensconsulting.net
#PowerBI #DAX #DAXFormulas #PowerBITutorial #DataModeling #StarSchema #BusinessIntelligence #PowerBITips #DataAnalytics #LearnPowerBI








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