Skip to main content
Showing results for 
Search instead for 
Did you mean: 

Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.

Find articles, guides, information and community news

Most Recent
Community Support
Community Support

This is an article about how to skip null values to add index columns.


Super User
Super User

Use Case - There are scenarios where you will be required to find the first/last non null value in a row. For example, to answer the questions:

1. What was the first sales amount done by a sales person? - This means that you will have to find first non-null from 2017 to 2022. For example, for Greg this is 688.

2. What was the last sales amount done by a sales person - This means that you will have to find last non-null from 2017 to 2022. Hence for Laura, this is 753.

Of course, if more years are added in the beginning or end, the formula should support the flexibility of Power Query i.e. if more columns are added, the result should include those columns as well.


Helpful resources

Join Blog
Interested in blogging for the community? Let us know.