Power Pivot Principles: The A to Z of DAX Functions – ISAFTER
19 August 2025
In our long-established Power Pivot Principles articles, we continue our series on the A to Z of Data Analysis eXpression (DAX) functions. This week, we look at ISAFTER.
The ISAFTER function

In DAX queries, the so-called "Start At" clause is an optional component used within an ORDER BY clause to specify the starting point for the results returned by an EVALUATE statement. It effectively filters the result set to include only rows that are equal to or after a specified value(s) in the context of the defined sort order.
The ISAFTER function is a Boolean function that emulates the behaviour of a 'Start At' clause and returns TRUE for a row that meets all the condition parameters.
ISAFTER(scalar_expression, scalar_expression[, sort_order
[, scalar_expression, scalar_expression[, sort_order]]…)
There are two [2] main arguments in this function:
- scalar expression: this is any expression that returns a scalar value such as a column reference, an integer or a string value. Typically, the first parameter is a column reference and the second parameter is a scalar value
- sort order: (optional) this is the order in which the column is sorted. This may be ascending (ASC) or descending (DEC). By default, the sort order is ascending.
It should be noted that the ISAFTER function:
- is similar to ISONORAFTER. The difference is ISAFTER returns true for values sorted strictly after the filter values, where ISONORAFTER returns true for values sorted on or after the filter values
- is not supported for use in DirectQuery mode when used in calculated columns or with row-level security (RLS) rules.
As an example, let's say we have the following table named Info:

We want to return all rows that appear after the combination
- Country/Region = "AUS"
- State = "VIC".
when sorted alphabetically (ASC) on both columns. Here is the DAX query:

This will return the following table:

Come back next week for our next post on Power Pivot in the Blog section. In the meantime, please remember we have training in Power Pivot which you can find out more about here. If you wish to catch up on past articles in the meantime, you can find all of our Past Power Pivot blogs here.