cancel
Showing results for
Did you mean: Frequent Visitor

IN function?

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

...

2 ACCEPTED SOLUTIONS  Super User

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

Did I answer your question? Mark my post as a solution, this will help others!

Proud to be a Super User!
I accept Kudos 😉
Hamburg, Germany  Microsoft

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

2 REPLIES 2  Microsoft

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  Super User

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

Did I answer your question? Mark my post as a solution, this will help others!

Proud to be a Super User!
I accept Kudos 😉
Hamburg, Germany  