Forum Discussion
Solved
Firstnonblankvalue in M
Hello, i'm looking for the equivalent of firstnonblankvalue in M. Thanks !
Write it like this:
{{"Max SOC", each List.FirstN([State of Charge], each _ <> null){0}, type nullable number})
--Nate
hello Anonymous ,
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})