Blog Post

Power BI Community Blog
2 MIN READ

Finding First/Last non null value in a row in Power Query M Language

Vijay_A_Verma's avatar
Vijay_A_Verma
Most Valuable Professional
4 years ago
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 pe...
Updated 4 years ago
Version 2.0
how to
Nulls
Power Query
tips & tricks
Vijay_A_Verma's avatar
Most Valuable Professional
Joined August 03, 2021
View Profile
Power BI Community Blog
On this blog you will find articles, guides and information created by our community members and, from time to time, roundups and community news. If you are interested in becoming a community blog author, send a private message to Natalie_iTalent. An overview of the community blogs can be found here.
Sairam's avatar
Sairam
Frequent Visitor
3 years ago

In the first case (Row) it will continue to be a table in the second case(Column) it will be a scalar value