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
Write it like this:
{{"Max SOC", each List.FirstN([State of Charge], each _ <> null){0}, type nullable number})
--Nate
Thanks Anonymous
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
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....