Accumulated column

[Anonymous]

Hi guys I need your help,

I work in an industrial company wich has 4 production lines.

I´ve already had three columns: Date, Line, Units produced (each day for each line)

I need an extra column with the accumulative units from Monday to Sunday for each line.

Basically:

-Line 1:

Monday: X units

Tuesday: Y + X units

Wednesday: Z + Y + X units

....

And the same every weeek for EACH line.

Do you know what´s the way to do it, or what formula can I use?

Thank you soo much!!

[v-yuta-msft]

@Anonymous ,

The info you give is not complete, could you please share some sample data and clarify more details about your requirement?

Regards,

Jimmy Tao

[Anonymous]

Hello Jimmy,

Basically I have four important columns: Day, Line, teoric units, and Real manufactured units:

I need TWO EXTRA columns with the accumulated teoric and real units per WEEK and LINE.

The final objetive is obtain something like this:

Here you can see we have filtered by week and in the second tablet we need to see:

- On Monday: Monday Teoric and Real Units

- On Tuesday: Monday + Tuesday Teoric and Real Units

- On Wednesday: Monday + Tuesday + Wedenesday Teorica nd Real Units

....

Do you think is it possible? I´m spending so much time to get this accumulated columns but I can´t find the way to obtain them...

Thank you so much!

[amitchandak]

@Anonymous , refer if My WTD blog can help you

https://community.powerbi.com/t5/Community-Blog/Week-Is-Not-So-Weak-WTD-Last-WTD-and-This-Week-vs-Last-Week/ba-p/1051123

It do have pbix attached

[Anonymous]

Thank you so much amitchandak, I tried to follow your steps but unfortunately I didn´t get my result. I think the accumulated I need is a little bit more complicated because we need to filter by line too... Could you please have a look the photos I´ve just upload to replied to Jimmy?

Thank you soo much!