Custom column: IF equals to one of multiple value

[Anonymous]

Hi,

As the title indicate, I am looking for solutions for creating a custom column using an IF statement based on whether the value of that column matches any values in the providing list.
In SQL, the query is something like:

SELECT count( case when column_a in (101, 133, 150, 168, 199, 323, 456, 888, 999) then 1 else 0)

The screenshot is a simplified approach to describe my question. Please advise how to approach this goal in adding custom column windows. Thank you in advance!

[AlexisOlson]

@mahoneypat gave a good M version of this.

If you happen to want to do this DAX instead, it would look like this:

IF ( [age] IN { 30, 40, 50 }, 1, 0 )

[mahoneypat · Accepted solution]

Try usinig List.Contains like this instead.

= if List.Contains({30,40,50}, [age]) then 1 else 0

Pat