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
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.