• Skip to main content
  • Skip to footer

Curbal

Learn how to grow your business with your data and Power BI

  • Resources
    • DAX Glossary
    • Download Center
    • Template Apps
    • Data Stories Gallery
    • Solution Gallery
  • Courses
    • Introduction to Power BI – FREE Online course
    • Power Query Online Training for Power BI
    • M Language Online Course: The unofficial and Practical Reference Guide
  • Blog
  • Shop
    • Courses
    • Swag
    • Downloads
    • Donations
  • Cart
  • Register/ Log In
    • Become a Member
    • Log In
    • My account
    • My Courses
  • Contact
You are here: Home / CM Tooltip Glossary Pro+ / TREATAS

TREATAS

posted on February 2, 2018

« Back to Glossary Index

Syntax

TREATAS(table_expression, <column>[, <column>[, <column>[,…]]]} )

Tutorial with example

In this video we will go through the DAX function TREATAS.
The TREATAS DAX function allows us to create virtual relationships within tables or pass filters to tables that are not related.

Download example file:

Link to sample pbix here

Remarks

  • The number of columns specified must match the number of columns in the table expression and be in the same order.If a value returned in the table expression does not exist in the column, it is ignored. For example, TREATAS({“Red”, “Green”, “Yellow”}, DimProduct[Color]) sets a filter on column DimProduct[Color] with three values “Red”, “Green”, and “Yellow”. If “Yellow” does not exist in DimProduct[Color], the effective filter values would are “Red” and “Green”.Best for use when a relationship does not exist between the tables.
Was this helpful?
[Total: 1    Average: 5/5]
« Back to Index

Reader Interactions

Comments

  1. Kamal Mukhi

    May 19, 2018 at 8:25 pm

    Hi Ruth,

    The link to the sample pbix file goes to sqlbi.com

    Could you please check?

    Thanks & Regards,
    Kamal Mukhi

    Reply
    • Ruth Pozuelo Martinez

      May 21, 2018 at 4:17 pm

      Hi,
      Yes, it is meant to go there. You can download the example (similar) there 🙂
      /Ruth

      Reply

Let us know your thoughts... Cancel reply

Footer CTA

Join our community of +12,500 professionals

Become a Member

Subscribe to YouTube

About us

Curbal AB
Kopparbergsvägen, 6
722 13 – Västerås
Sweden

OrgNo:5569680852 | VAT:SE556968085201

 

Location:

© Copyright 2014-2019 · Curbal AB · All Rights Reserved · Privacy Policy · Terms of Service · Refund Policy · Log In