Posts filed under DAX

[DAX] Anti-Patterns Episode Two: SELECTEDVALUE() (with Daniil Maslyuk)

A lot of videos and articles teach you how to write [DAX]. In this video Daniil Maslyuk and I will show you you how avoid bad [DAX] patterns! This episode will focus on the SELECTEDVALUE function.

GUEST BIO πŸ‘€

Daniil Maslyuk, MVP, is an independent consultant and the author of the official Microsoft Power BI exam reference books.

RELATED CONTENT πŸ”—

Understanding Model Recalculation
Difference Between Table & Scalar Date Functions
Daniil's Blog
Daniil's Twitter
Daniil's LinkedIn

Posted on January 25, 2022 and filed under Power BI, DAX, Topics & Discussion.

[DAX] Anti-Patterns - Episode One (with Daniil Maslyuk)

A lot of videos and articles teach you how to write [DAX]. In this video Daniil Maslyuk and I will show you you how avoid bad [DAX] patterns!

GUEST BIO πŸ‘€

Daniil Maslyuk, MVP, is an independent consultant and the author of the official Microsoft Power BI exam reference books.

RELATED CONTENT πŸ”—

Daniil's Blog
Daniil's Twitter
Daniil's LinkedIn

Posted on January 11, 2022 and filed under Power BI, DAX, Topics & Discussion.

Improving the Time Intelligence Slicer & Avoiding Circular Dependencies

Video by: Reid Havens

I've improved my time intelligence slicer based on some feedback about a DAX error related to blank dates being evaluated. In this video we'll see how to avoid that plus also prevent any circular dependency errors as well!

RELATED CONTENT πŸ”—

Part 1: Creating MTD/QTD/YTD Filters
Part 2: Applying USERELATIONSHIP Function
Part 3: Additional Date Periods
Part 4: Fiscal Periods

Posted on September 21, 2021 and filed under DAX, Power BI, Intermediate, Slicers & Filters.

Calculating the Top Name & Value Using [DAX] in Power BI

Video by: Reid Havens

Learn how to leverage a long standing DAX pattern to calculate the top performing name/category and it's corresponding value using DAX measures in Power BI. Plus also see how to optimize the code using DAX Studio.

RELATED CONTENT πŸ”—

DAX Function (TOPN)
DAX Function (FIRSTNONBLANK)
Optimizing DAX Video Course