ISAFTER DAX Function

The ISAFTER DAX function is used to return a record after the start position specified in condition, and returns the result as a Boolean.

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 the second parameter.

If the sort order is descending, the comparison to be done is second parameter less than the first parameter.

Syntax

ISAFTER(<scalar_expression>, <scalar_expression>, sort_order , <scalar_expression>, <scalar_expression>, sort_order…)

Parameters

scalar expression – Any 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.

Sample data set for example

Let’s Get Started

Create a New column and write below DAX formula

Flg = ISAFTER(TempData[Product], "B", ASC)

This formula will return True for all records after B Product.  Here, Product order is ASC.

ISAFTER DAX Power BI

Now change the Product order DESC and see the result- It will return True for before B products.

Flg = ISAFTER(TempData[Product], "B", DESC)

ISAFTER DAX with DESC Order

ISAFTER DAX with Measure

Create a measure with below DAX formula-

ISAFTER DAX =
CALCULATE (
    SUM ( TempData[Sales] ),
    FILTER ( TempData, ISAFTER ( TempData[Product], "B", ASC))
)

See result below, only return Product after B.

ISAFTER function With Measure

Hope you enjoyed the post, you can refer Other DAX functions: DAX functions