Posts filed under DAX

Testing Your Code Using the [DAX] Query View!

Video by: Reid Havens

See some examples on how to leverage the DAX query view to save some of your test code, and staging tables. A great improvement from having to save hidden test and development report pages in your PBIX file. Tune in to learn more!

RELATED CONTENT πŸ”—

Jeffrey Wang Livestream
Working with DAX Query View

Download Report From The Blog Files Page
Posted on February 6, 2024 and filed under DAX, Power BI Features.

Identifying & Optimizing DAX Patterns (Case-Study)

Video by: Reid Havens

Walk through a client case-study with me as I identify and optimize repeating DAX patterns. The end result having less lines of code, simpler logic, and faster performance. Tune in to learn more!

Download Report From The Blog Files Page
Posted on January 2, 2024 and filed under DAX, Intermediate.

(Livestream Replay) DAX Query View Best Practices & Historical Context - with Jeffrey Wang

DESCRIPTION πŸ“„

The November Desktop release's public preview of the DAX Query View has ignited excitement among the DAX community. This feature represents the first new view since the inception of Desktop, joining the existing trio of Report View, Data View, and Model View. This addition is poised to transform the way DAX programmers approach their craft, encouraging them to write their own DAX queries more frequently.

A common challenge with DAX lies in its flexibility, as multiple methods often exist to achieve similar results. DAX queries are no exception; the community has already begun discussing various functions capable of producing comparable query results. In this episode, we will delve into the recommended functions and patterns for writing DAX queries. We aim to demystify the best practices recommended by the product team by exploring the historical context of their development.

GUEST BIO πŸ‘€

Jeffrey has over twenty years of experience in the BI industry and joined the Microsoft SQL Server Analysis Services team in 2004. As a co-inventor of the DAX programming language, Jeffrey has watched it grow from an unknown language to one that is widely used worldwide. His latest projects in DAX include the development of the recently announced Visual Calculations.

RELATED CONTENT πŸ”—

LinkedIn
Blog

Download ZIP From The Blog Files Page
Posted on December 29, 2023 and filed under Livestreams, DAX, Power BI Features, Power BI.

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?

Download Report From The Blog Files Page
Posted on December 26, 2023 and filed under DAX.