Getting Better At Dax Understanding Treatas Function

This is a fun video in which we try to solve an interesting DAX puzzle while learning how to use TREATAS() DAX function. As a bonus I also show you how to debug variables that house a table inside. For that I do a bit of a tutorial on CANCATINATEX() function.

The data set is very simple, we only have two tables. The Sales table stores Date, Customer, Product and Sales columns to track our sales. The Prices table has a price information for every product. To make things interesting, we do not have a relationship between our two tables.

The puzzle is to figure out what was the highest price that each customer has every paid for the products that he/she has purchased.

Link to blog: businessintelligist.com/2020/07/21/getting-better-at-dax-understanding-treatas-function/

Author

Ariyani

Como educador, estou profundamente engajado no desenvolvimento dos estudantes em ambiente escolar, adotando métodos pedagógicos que valorizam conexões genuínas e são movidos por inovação e fervor. É minha vocação guiar os alunos na jornada de se tornarem uma geração notável, empregando estratégias de ensino amplamente aclamadas por prestigiadas instituições acadêmicas ao redor do globo - preview.pbjmanagement.co.uk