Forum Discussion

jcgutierro's avatar
jcgutierro
Frequent Visitor
6 years ago

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]{[Índic...
Need Help
v-juanli-msft's avatar
v-juanli-msft
Icon for Community Support rankCommunity Support
6 years ago

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.