Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago
Solved

Split rows by date in Power Query with running total condition

Hi, guys,   I've tried to create a table in Power Query which gives me a Receivable amount by document and date. It works fine with a small scale of data, but I need help with adjusting these calcu...
Need Help
Anonymous's avatar
Anonymous
Not applicable
5 years ago

Thanx, MFelix ,but it's not the only case. Mainly this table is for calculating receivables aging, because when I have 1 mln. row it quite difficult to have quick calculations about debt aging dynamics and overdue debts for historical dates.

MFelix's avatar
MFelix
Super User
5 years ago

Hi Anonymous ,

 

Not really sure if this is the best approach for your model since you will be replicating the model into several millions lines more.

 

Calling out to ImkeF  the best M language expert out here she can give you a hand on optimizing this this on power query for sure.