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 […]
Exponential Moving Average in Power Query (EMA) Read More »
I am sure people spend more time and effort cleaning and organizing their data when they need to perform data analysis in Excel, Power BI or any other tool. You do not always receive data in tabular and normalized formats for you to straightaway use the analysis tools like Pivot Tables, Filtering, Chatting and data
Pivot, Unpivot and Transpose Data with Power Query Read More »
Allocating amounts such as contracts, prepayment, revenue, cost, etc. across different date ranges is a common Excel challenge that can be solved in many ways. Let’s assume you have some rent contracts with start date, end date, and the amount which needs to be split into months based on the exact number of days in
Split Amount across Months Using Power Query in Excel and Power BI Read More »