cancel
Showing results for 
Search instead for 
Did you mean: 

Fabric is Generally Available. Browse Fabric Presentations. Work towards your Fabric certification with the Cloud Skills Challenge.

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
PBI November 2023 Update Carousel

Power BI Monthly Update - November 2023

Check out the November 2023 Power BI update to learn about new features.

Community News

Fabric Community News unified experience

Read the latest Fabric Community announcements, including updates on Power BI, Synapse, Data Factory and Data Activator.

Power BI Fabric Summit Carousel

The largest Power BI and Fabric virtual conference

130+ sessions, 130+ speakers, Product managers, MVPs, and experts. All about Power BI and Fabric. Attend online or watch the recordings.

Top Solution Authors