Forum Discussion
Triple Exponential Moving Average in Power Query M
Hi jsflint ,
The logic seems to be a little complex that may reduce Power Query performance.
In this case, It's suggested to connect to the excel file directly.
Refer to:
Best practices when working with Power Query | Microsoft Docs
Watch Your Steps! Power Query Performance Caution for Power BI
A comprehensive guide to Power BI performance tuning - SQLGene Training
Best Regards,
Eyelyn Qin
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
I'm trying to avoid doing the calculations in Excel, then linking to it because it will then require me to manually update the spreadsheet in order to update the report. I need the live report to connect, then have Power Query make the calculations for the EMAs and TEMA.