First non blank value across columns (M language)

[Anonymous]

Hi,

is there a way for me to produce the below result in power query using m language?

I have a table of time and I need to grab the first non blank across the columns (horizontally)
in excel i am using this forumula: =INDEX(A2:J2,MATCH(TRUE,INDEX((A2:J2<>0),0),0))

I would perfer power query over DAX in this case because i need to join this table to another and would rather not load all the not needed columns.

TIA.

[amitchandak · Accepted solution]

@Anonymous , are you a raking min of 4 columns ?

Refer this https://www.mrexcel.com/board/threads/powerquery-calculate-min-across-multiple-columns-for-each-record.1084547/

[Anonymous]

Thank you 🙂 I knew it was much simplier then a long if statement 🙂