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

ISONORAFTER Function (DAX)

Owen Duncan|Last Updated: 5/22/2018

A boolean function that emulates the behavior of a ‘Start At’ clause and returns true for a row that meets all of the condition parameters.

This function takes a variable number of triples, the first two values in a triple are the expressions to be compared, and the third parameter indicates the sort order. The sort order can be ascending (default) or descending.

Based on the sort order, the first parameter is compared with the second parameter. If the sort order is ascending, the comparison to be done is first parameter greater than or equal to second parameter. If the sort order is descending, the comparison to be done is second parameter less than or equal to first parameter.

Syntax

ISONORAFTER(<scalar_expression>, <scalar_expression>sort_order] [,scalar_expression>, <scalar_expression>, [sort_order][,…])  

Parameters

TermDefinition
scalar expressionAny expression that returns a scalar value like a column reference or integer or string value. Typically the first parameter is a column reference and the second parameter is a scalar value.
sort order(optional) The order in which the column is sorted. Can be ascending (ASC) or descending (DEC). By default the sort order is ascending.

Return Value

True or false.

Example

Table name: ‘Info’

CountryStateCountTotal
INDJK20800
IND`MH251000
INDWB10900
USACA5500
USAWA10900
FILTER(Info, ISONORAFTER(Info[Country], “IND”, ASC, Info[State], “MH”, ASC))  
© 2018 Microsoft