Posts filed under DAX

Revisiting Common Calculation Group Patterns in Power BI!

Video by: Reid Havens

Because of the recent release of adding calculation groups directly from Power BI Desktop. We'll explore three common calculation group patterns and use-cases. Tune in to learn more!

RELATED CONTENT 🔗

Semantic Model View & Calculation Groups
Auto-Scaling for [DAX] KPI Cards?

Posted on December 26, 2023 and filed under DAX.

IMPROVED - IBCS Styled Bullet Charts (SVG) in Power BI!

Video by: Reid Havens

Join Daniel Marsh-Patrick and myself as we explore a NEW and IMPROVED SVG image template to add an IBCS (International Business Communication Standards) inspired bullet chart to your native matrix or table visuals in Power BI Desktop!

RELATED CONTENT 🔗

IBCS Bullet Chart
Buy Daniel a Coffee
Deneb AppSource
Daniel's Website

Posted on December 12, 2023 and filed under Intermediate, Visualizations, DAX.

(Livestream Replay) Demystifying [DAX] Evaluation Context - with Brian Grant

DESCRIPTION 📄

“DAX Evaluation Context”, just the name alone strikes fear into the heart of even seasoned Power BI developers. The reality however, is that Evaluation Context in DAX isn’t hard to understand, it’s simply hard to describe. In this session Brian Grant will use a technique called "Formula Decomposition" to visually break down a big DAX formula into a chain of smaller, bit-sized sub-formulas; this in turn will create the platform needed for Brian to make the concepts of Evaluation Context both clear to understand and easy to remember.

At the end of the presentation you will both have a clear idea of how to visualize Row and Filter Context, and also understand how the sub-formulas leverage these contexts to produce the answers you see on a Power BI page. Furthermore, the next time you look at a big intimidating DAX formula, you will know how to break it down into bite sized chunks so they can be understand one at a time.

GUEST BIO 👤

Hailing from the East side of beautiful Portland Oregon, Brian is a Senior Business Analytics consultant with local data heroes Skypoint. Having spent his early years deep in the study of acting and screenwriting, he finally graduated Summa Cum Laude with a degree in Economics. His driving belief is that the biggest barrier most people face when learning technology isn't technology at all, but language. Taught the right way, most people can learn most things; helping people learn skills that are "too technical" for them is his greatest joy. He is the author of the Elements of DAX series on YouTube.

RELATED CONTENT 🔗

Blog
LinkedIn
YouTube

(Livestream Replay) Visual Calculations – Making [DAX] Easier - with Jeroen ter Heerdt

DESCRIPTION 📄

This is it. The day that the way that DAX became easier. After this, how you write DAX changes forever. Learn all about it in this session! The Power BI team has been working on exciting things related to DAX calculations, specifically targeted at making it easier to add typical business-type calculations (such as running totals or vs-first). Would you believe it if we told you that you don’t even have to type DAX anymore and still be able to get complex calculations done quickly? In this session, we will talk about this exciting new feature! Join this session to learn more about this new feature which will make writing DAX statements so much easier and faster. Get ready to get your mind blown! See the future, today.

GUEST BIO 👤

Jeroen ter Heerdt is a Product Manager with Microsoft. He works on Power BI and is passionate about "all things data"; whether it is about databases, data warehousing, BI, big data, data visualizations, self-service BI, advanced analytics, real-time BI or anything even remotely related to data or insight. He strives to apply these concepts in his life as much as possible. Jeroen combines enthusiasm, vision, and hands-on experience into his talks.

RELATED CONTENT 🔗

Blog
LinkedIn
Understanding Visual Calculations