Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 years ago
Solved

How to calculate column by groups in Power Query

HI! I am using this code to calculate my previous value from calculated column /(1+Rate) in Power Query  Deflator = List.Transform(List.Skip(List.Accumulate(#"Changed Type3"[Rate], {1}, (s,c)=> s &...
Need Help
  • wdx223_Daniel's avatar
    wdx223_Daniel
    3 years ago

    NewStep=Table.FromRecords(List.Accumulate(Table.ToRecords(#"Changed Type3"),{{},[]},(x,y)=>let a=Record.TransformFields(x{1},{y[Group],each (_??1)/(1+y[Rate])},2) in {x{0}&{y&[Deflator=Record.Field(a,y[Group])]},a}){0})

wdx223_Daniel's avatar
wdx223_Daniel
Community Champion
3 years ago

your real data is too big to use this solution

you can try to group the data firstly

Anonymous's avatar
Anonymous
Not applicable
3 years ago

wdx223_Daniel could end condition help ?