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

Microsoft is giving away 50,000 FREE Microsoft Certification exam vouchers. Get Fabric certified for FREE! Learn more

Reply
orangebloss
New Member

Returning Column Name of first non- Null value

I have a CSV file I'm using as a source, I'm needing to return the column name of the first non-null value in a row. 

 

In Excel I'd use a simple index match. I've worked out how to return the first non null value but still can't quite fathom how to return the column name.

 

Any help very much appreciated.

1 ACCEPTED SOLUTION
slorin
Super User
Super User

Add a List.RemoveFirstN

List.Skip(List.RemoveFirstN(List.Zip({Record.FieldValues(_), Record.FieldNames(_)}),4), each _{0}=null){0}{1}

Stéphane 

View solution in original post

4 REPLIES 4
slorin
Super User
Super User

Add a List.RemoveFirstN

List.Skip(List.RemoveFirstN(List.Zip({Record.FieldValues(_), Record.FieldNames(_)}),4), each _{0}=null){0}{1}

Stéphane 

Brilliant thank you!!!

slorin
Super User
Super User

Hi

Add a new column

List.Skip(List.Zip({Record.FieldValues(_), Record.FieldNames(_)}), each _{0}=null){0}{1}

 Stéphane

Thanks - that's almost there, however the columns I'm searching start at column 5 (first four columns are populated) how would I change this to accomodate this?

 

It also seems to return the same result for every row?

Helpful resources

Announcements
March PBI video - carousel

Power BI Monthly Update - March 2025

Check out the March 2025 Power BI update to learn about new features.

March2025 Carousel

Fabric Community Update - March 2025

Find out what's new and trending in the Fabric community.

Top Kudoed Authors