Forum Discussion
Registro anterior Power Query M
Hola a tod@s.
Tengo una query con 120 mil. registros, he creado un Índice para numerar el registro actual y lo utilizo para recuperar el registro anterior a través de =RegistroAnterior[Fecha]{[Índice]-1} .Al ejecutar lo explicado, llega a tardar 6 minutos en mostrar el dato.
¿Pueden decirme alguna opción o solución que agilice la query en Power Query M?
2 Replies
Hi jcgutierro
It seems your code(RegistroAnterior[Fecha]{[Índice]-1}) would iterate every row for mutiple times.
There is an easy way to achieve the goal: find the previous date for each ID.
https://www.youtube.com/watch?v=xN2IRXQ2CvI
If these method still slow for your scenario, try to speed up it with Table.buffer, List.generate,,ect
Performance tip for List.Generate (1): Buffer your tables in Power BI and Power Query
Table.Buffer for cashing intermediate query results or how workaround Unnecessary Queries Issue
Best Regards
MaggieCommunity Support Team _ Maggie Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.Hi jcgutierro
Is this problem sloved?If it is sloved, could you kindly accept it as a solution to close this case?If not, please let me know.Best RegardsMaggie
