In this article, I will be sharing a technique using List.Accumulate function to calculate the Exponential Moving Average (EMA) in Power Query. When it comes to recursive operations, the List.Accumulate is indispensable and becomes handy in scenarios of this nature. Read through the blog and download the attached PBIX file to learn more.
I will be sharing a solution on solving the EMA using DAX which provides more control on the slicing and dicing in one of my upcoming blog posts.
Continue Reading . . .
Fowmy Abdulmuttalib is a Microsoft-certified business intelligence professional with extensive experience in finance, accounting and data analytics. Currently, he is employed by McDonald’s Saudi Arabia as the Head of ERP and Business Intelligence. He is interested in everything data-related, he likes to share his passion and knowledge with the data community.