Table of contents
TOC
Collapse the table of content
Expand the table of content

IN Function

Owen Duncan|Last Updated: 10/5/2018
|
1 Contributor

Returns True if the scalar value shows up in at least one row of the input relation.

Syntax

IN 

Parameters

TermDefinition
scalar expression
table expression

Return Value

Remarks

Example

Filtered Sales:=CALCULATE (
        [Internet Total Sales], 'Product'[Color] IN { "Red", "Blue", "Black" }
    )

See Also

© 2018 Microsoft