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.