Firstnonblankvalue in M

[GeekAlfPro]

Hello,

i'm looking for the equivalent of firstnonblankvalue in M.

Thanks !

[v-stephen-msft]

Hi @GeekAlfPro ,

Since we only need to get the first non-null value, our idea can be converted to delete the unnecessary null value first, and add the custom column to return the first row by group.

Best Regards,

Stephen Tao

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[watkinnc · Accepted solution]

Write it like this:

{{"Max SOC", each List.FirstN([State of Charge], each _ <> null){0}, type nullable number})

--Nate

[GeekAlfPro]

Thanks @watkinnc 

it almost works, but i have some errors

Expression.Error: There were not enough items in the enumeration to complete the operation.
Details:
    [List]

that's strange because i have a value with Dax for the day and the internal_id that i checked

[GeekAlfPro]

I have about 880000 rows, can it explain the error message ?

i'm stuck with this issue...

[GeekAlfPro]

i checked my datas and i still don't understand why it works with dax but not with M

to check, i remove the {0} of your formula to get a list :

the list is empty, despistes i have datas....

[GeekAlfPro]

hello @watkinnc ,

in a column, i want the firstnonblankvalue in a group.

i tried this but, it returns me a list not a single value : 

= Table.Group(Source, {"Internal_id", "timestamp"}, 
{{"Max SOC", each List.FirstN({[State of Charge]}, each _[State of Charge]<> null), type nullable number})

[watkinnc]

In a column or a row?