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
I have about 880000 rows, can it explain the error message ?
i'm stuck with this issue...
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....