Forum Discussion
Excel formula into m-language
Hi forum, I am new to m-language and hope that someone can help me convert this excel formula into m-code? 🤞😊
NewStep=Table.FromRecords(List.Accumulate(Table.ToRecords(PreviousStepName),{{},[]},(x,y)=>{x{0}&{y&[Sum tid=if y[CreateAt]=x{1}[CreateAt]? then y[Tid]-x[Tid]? else null]},y}){0})
This method seems a better one.
But bro, getting an error in this method.
Can you help?
I hope for a reply to resolve and learn the same.
Thank you.