The ultimate Fabric, Power BI, SQL, and AI community-led learning event. Save €200 with code FABCOMM.
Get registeredEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends September 15. Request your voucher.
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 @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....
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})
In a column or a row?