Optimizar codigo power query promedio movil

Try a Table.Buffer over a as well

 a = Table.Buffer(Table.SelectRows(BufferedTable, each [Mark_Real_Proyeccion] = "Real")),

Basically - try using a buffer whereever you are refrencing an entiry multiple times.

Monitor resource utilization - Table.Buffer is not free.

remove some of the buffers again and add in other places. Sometimes buffers make it slower.

If you want real help then you would want to provide sample data that clearly shows the issue.  So more than a handful of rows.

Hi luis-fer-va ,
Thanks for reaching out to the Microsoft fabric community forum.

Please check out this document: Best practices when working with Power Query - Power Query | Microsoft Learn
Especially check out the part containing "Create reusable functions" If you find yourself in a situation where you need to apply the same set of transformations to different values, creating a Power Query custom function that can be reused as many times as you need could be beneficial.

Check this document: Why does my query run multiple times - Power Query | Microsoft Learn and try disabling features like background analysis.

Please try these steps and check if they result in improvement of efficiency. I hope my suggestions give some ideas on how to improve efficiency.

If you find this post helpful, please mark it as an "Accept as Solution" and consider giving a KUDOS.
Thanks and Regards