TREATAS function to handle missing relationship in the model

TREATAS function in dax is used to establish virtual relationship between two tables in Power BI model. We can use one or more than one columns for filtering the tables.

Handling relationships is an essential aspect of any data modeling exercise. If done correctly, it can save a lot of time and effort. Though Power BI offers many-to-many relationships, but at times it adds many complexities. And hence, experts advise caution while using many-to-many relationships in Power BI.

For more useful blogs, please visit Learn DAX