Forum Discussion
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...
Hi Anonymous ,
you have to use this approach to make it run faster:
Memory efficient clustered running total in Power BI – The BIccountant
MFelix
Super User
Super UserHi 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.
ImkeF
Community Champion
Community ChampionHi Anonymous ,
you have to use this approach to make it run faster:
Memory efficient clustered running total in Power BI – The BIccountant