Solved: List Accumulate in power query to create YTD of cu...

jaco1951 · ‎10-08-2018

Hi

I have a list of currenices on monthly level, I would like to make a YTD column and I have tried with list.accumulate without any success.

Does anyone know how I can make this in Power Query?

I have multiple years, and multiple currencies. I want to create a new column "Currency Rate YTD by currency".

Thanks

Br Espen

v-chuncz-msft · ‎10-09-2018

@jaco1951,

You may take a look at the following post.

https://community.powerbi.com/t5/Desktop/How-to-do-a-running-Sum-by-group-in-Power-Query/m-p/290123

Community Support Team _ Sam Zha
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

View solution in original post

v-chuncz-msft · ‎10-09-2018

@jaco1951,

You may take a look at the following post.

https://community.powerbi.com/t5/Desktop/How-to-do-a-running-Sum-by-group-in-Power-Query/m-p/290123

Community Support Team _ Sam Zha
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

List Accumulate in power query to create YTD of currenices

Helpful resources

Join us at the Microsoft Fabric Community Conference

Power BI Monthly Update - February 2025

Fabric Community Update - February 2025

How to Get Your Question Answered Quickly

Join us at the 2025 Microsoft Fabric Community Conference