How to Use the Power BI DAX function ISONORAFTER

ISONORAFTER is a DAX function that returns the last occurrence of a value in a column that occurs after a specific date. In other words, it helps you find the last instance of a specific value after a given date.


The syntax for using the ISONORAFTER function in Power BI is as follows:

ISONORAFTER(❰column❱, ❰value❱, ❰date_column❱)

- `❰column❱`: The column containing the values you want to search.

- `❰value❱`: The value you want to search for.

- `❰date_column❱`: The column containing the dates you want to use for filtering.


Suppose you have a table called Sales that contains the following columns:

- Date

- Product

- Amount

You want to find the last sale for a specific product after a given date. To do this, you can use the ISONORAFTER function as follows:

=ISONORAFTER(Sales[Date], Sales[Product], “1/1/2021”)

This formula will return the last occurrence of the specific product after January 1st, 2021.

Tips for Using ISONORAFTER

Here are some tips for using the ISONORAFTER function effectively:

1. Use a date column for filtering

The ISONORAFTER function requires a date column for filtering. Make sure that you have a column in your table that contains the dates you want to use for filtering.

2. Use the function with other functions

The ISONORAFTER function is often used in conjunction with other DAX functions, such as MAX and FILTER. For example, you can use the MAX function to find the maximum value of a column, and then use ISONORAFTER to find the last occurrence of that value after a given date.

3. Test your formula

Always test your formula to make sure that it is returning the results you expect. You can use the DAX formula bar in Power BI to test your formulas.

The ISONORAFTER function is a powerful tool for finding the last occurrence of a value after a given date in Power BI. By understanding the syntax and tips for using this function, you can create more effective reports that provide valuable insights into your data.

Power BI DAX Training Courses by G Com Solutions (0800 998 9248)

Upcoming Courses

Contact Us


    Your Name (required)


    Email (required)


    Training Course(s)

    Your Message

    Upload Example Document(s) (Zip multiple files)