Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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.
Write it like this:
{{"Max SOC", each List.FirstN([State of Charge], each _ <> null){0}, type nullable number})
--Nate
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
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....
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})
In a column or a row?
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.