Report Portal

The IN operator in DAX

This article describes the IN operator in DAX, which simplifies logical conditions checking whether a certain value is included in a list of values or expressions.


The new IN syntax has been available in Power BI since November 2016. This syntax will be also available in future versions of Analysis Services (after SQL Server 2016). In order to support this new operator, DAX also introduced two new syntaxes, table and row constructor, which enables the creation of “anonymous” tables that can be used to compare the value of two or more columns instead of a single one.



Tags: dax, tabular


2007-2015 VidasSoft Systems Inc.