TREATAS - DAX Guide

TREATAS: Treats the columns of the input table as columns from other tables.

This video is part of DAX Guide, the online guide to all the DAX functions, with links to related content and compatibility matrix with all the versions of Power BI, Azure Analysis Services (AAS), SQL Server Analysis Services (SSAS), SQL Server Data Tools (SSDT), and Power Pivot for Excel.


#dax #powerbi #ssas #tabular #analysisservices #powerpivot

[rcb]

I recently found myself having to build a paginated report based on an existing model in PowerBI service. However, I had no authority to modify or update that model, and the owners were unwilling/unable to make changes as well. TREATAS was hugely useful in this scenario where I needed to make calculations on tables which had missing relationships to the date table. I wouldn't have been able to do so without your earlier videos about the function, Thank you so much for sharing all this wonderful information with us.

[danielsiffredi]

Grazie mile maestro! Never used treatas but now I get it 👏 - easier than using filters with multiple arguments and && símbols. Thanks again

[clementejosemartinezserpas]

Thank you. This one is hard to understand, but get the feeling.

[earlnoli]

it is a weird way to do In clause, but the multiple columns I can finally understand its power unless I do some concatenation. Not sure though how it handles null values in one of the columns.