IN function?

[quantfinRguy]

Is there a DAX function that test whether or not the target is in a column?

For example, ....(x, DATA) returns TRUE() or FALSE() whether or not x is in the column

DATA

1

2

3

4

5

6

...

[TomMartens · Accepted solution]

Hey,

there are two functions I would start with. The 1st function is IN (actually IN is more like an operator then a function but nevertheless ...

You can use something like this

IF(15 IN
    VALUES('Calendar'[MonthNoIndex])
    ,"Yes"
    ,"No"
    )

This little statement checks if 15 is contained in the table returned by VALUES(). Be aware that IN checks if something in a table.

This would also work

IF(15 IN
    {13, 14, 15}
    ,"Yes"
    ,"No"
    )

The 2nd function that can be of interest, could be CONTAINS().

I hope this gets you started.

Regards

Tom 

[v-huizhn-msft · Accepted solution]

Hi @quantfinRguy,

As @TomMartens posted, you you can create measure using IN function.

This is my sample table, please a measure using the formula below.

Measure = IF(4 IN VALUES(Test[Date]),"Yes","No")

Create a table visual to display the result.



For another thing, you can create a calculated column using the formula below to get expected result.

Column = IF(Test[Date]=4,"Yes","No")

Best Regards,
Angelia

[TomMartens · Accepted solution]

Hey,

there are two functions I would start with. The 1st function is IN (actually IN is more like an operator then a function but nevertheless ...

You can use something like this

IF(15 IN
    VALUES('Calendar'[MonthNoIndex])
    ,"Yes"
    ,"No"
    )

This little statement checks if 15 is contained in the table returned by VALUES(). Be aware that IN checks if something in a table.

This would also work

IF(15 IN
    {13, 14, 15}
    ,"Yes"
    ,"No"
    )

The 2nd function that can be of interest, could be CONTAINS().

I hope this gets you started.

Regards

Tom