Cumulative column

[ANB_13]

Good morning, 

I hope you are all well, 

I need youtr help, I would like to creat a new column in power query with the cumul of the "BI" column for each month (column : mois).

What shoud I do ?

Thank you very much

Regrds 

[DOLEARY85]

Hi,

I posted something about using a cumulative column in power query yesterday, have a look at this post:

https://community.powerbi.com/t5/Power-Query/New-column-that-adds-the-accumulative-of-the-column-val...

If I answered your question, please mark my post as solution, Appreciate your Kudos 👍

[ANB_13]

It doesn't work for me 😞

[DOLEARY85]

Can you share a screenshot of the outcome of the steps?

If I answered your question, please mark my post as solution, Appreciate your Kudos 👍

[ANB_13]

[DOLEARY85 · Accepted solution]

Ah okay, the #"Changed Type" part of the formula will need to be adapted to be the name of the previous step in your m query can you go to advanced editor and show me that?

If I answered your question, please mark my post as solution, Appreciate your Kudos 👍

[ANB_13]

It works, thank you very much !

[DOLEARY85]

No problem, happy to help 🙂