Forum Discussion

CMMaliniJoshi's avatar
2 years ago
Solved

Alternate for Table.Group / Table.AggregateTableColumn, Slow power query data loading

Dear All I have created a Query based on below mentioned data Ac_no Maturity_Amount Maturity_Date 1 388211 25.09.2023   I have to calculate Interest on Maturity amount as...
  • ImkeF's avatar
    2 years ago

    Hi CMMaliniJoshi ,
    just saw that you have an unbuffered reference to the table here still - that might cause the slow performance:
    Added_Custom = Table.AddColumn(Changed_Type, "Day", each {Number.From([Maturity_Date])..Number.From(List.Max(dROI[Date_Upto]))}),

    Cannot do any more here. Further help would need the data itself, but for me, this would then run into consultancy services that I would have to charge for.
    You might want to consider opening separate threads for it and make sure to include sample data to it so folks can follow the desired logic.