Forum Discussion
Referencing previous row in column: Performance issues
Hey Anonymous ,
what exactly is your data source? You could check if the approach in Power Query is faster or more efficient than in DAX. Check the approach in Power Query:
Value from previous row – Power Query, M language – Trainings, consultancy (exceltown.com)
Or
Refer to Previous Row and Next Row in Power Query - Goodly
Otherwise is it possible to add an index column in Power Query? Then you can just filter the rows to [index]-1 to get the previous row. That should be faster from my feeling:
Find a Value in the Previous Row | Burningsuit
If you need any help please let me know.If I answered your question I would be happy if you could mark my post as a solution ✔️ and give it a thumbs up 👍Best regardsDenisBlog: WhatTheFact.biFollow me: twitter.com/DenSelimovic
Hey Anonymous ,
what exactly is your data source? You could check if the approach in Power Query is faster or more efficient than in DAX. Check the approach in Power Query:
Value from previous row – Power Query, M language – Trainings, consultancy (exceltown.com)
Or
Refer to Previous Row and Next Row in Power Query - Goodly
Otherwise is it possible to add an index column in Power Query? Then you can just filter the rows to [index]-1 to get the previous row. That should be faster from my feeling:
Find a Value in the Previous Row | Burningsuit