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

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})

  • Anonymous's avatar
    Anonymous
    Not applicable
    3 years ago

    wdx223_Daniel It works in Power Query but when I wanna use it in PBI there is error : Expression.Error: Evaluation resulted in a stack overflow and cannot continue.

    Is there some way to fix it ?

    • 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 ?