Posts filed under DAX

[DAX] Anti-Patterns Episode Three: Table Functions (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 how to avoid unnecessary table functions and the difference between table and scalar functions!

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 February 15, 2022 and filed under Power BI, DAX, Topics & Discussion.

[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.