Registro anterior Power Query M

[jcgutierro]

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?

[v-juanli-msft]

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 Regards

Maggie

[v-juanli-msft]

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
Maggie

Community 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.