Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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?
Hi @jcgutierro
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
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
102 | |
53 | |
21 | |
12 | |
12 |