Filter

Return to: Calculated Member Builder Function List

Returns the set resulting from filtering a set based on a search condition.

Syntax

Filter(«Set», «Search Condition»)

Example

Filter(SampleSet, (Sales,[1996]) < (Sales, [1995]))

returns

{Paris, Buffalo}

if these cities declined in sales.