cancel
Showing results for
Search instead 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

## Helpful resources

Announcements

#### 2022 Release Wave 1 Plan

Power Platform release plan for the 2022 release wave 1 describes all new features releasing from April 2022 through September 2022.

#### Check it Out!

Click here to read more about the December 2021 Updates!

#### Calling all User Group Leaders!

Don't miss the User Group Leader meetings on January, 24th & 25th, 2022.

#### Power BI Dev Camp- January 27th, 2022

Mark your calendars and join us for our next Power BI Dev Camp!

Top Solution Authors
Top Kudoed Authors