Running Total by Month & by Product

srehman

Board Regular
Joined
Jan 4, 2020
Messages
210
Office Version
  1. 2016
Platform
  1. Windows
Hi Team,

i have tried many DAX function try to resolve this issue but no success. i want running total of products by each month separately, Jan will show running total of all products which are in Jan , then Feb then March

Desire results as below

1655296290812.png



Sample Data

Running total 2nd.xlsx
EFG
3SKUMonth-YYYYTotal Orders
4151631691/01/2021545
5151631692/01/2021488
61692124912/01/2021332
71692232913/01/2021278
8162984997/01/2021191
9264399896/01/2021263
10264399899/01/2021168
112863996911/01/2021194
126295357914/01/2021317
13629589993/01/2021474
146414552910/01/2021199
15695913994/01/2021250
16695913995/01/2021336
17695913998/01/2021387
18132411398/02/2021303
19151295699/02/202185
20151314292/02/2021336
21151314291/02/2021442
221692124912/02/2021287
231692232913/02/2021266
24162984997/02/2021173
25264314795/02/2021166
26264399896/02/2021240
272863996911/02/2021199
286295357914/02/2021221
29629589993/02/2021273
306414552910/02/2021212
31695913994/02/2021248
32151631691/03/2021488
33151314292/03/2021310
34629589993/03/2021289
35695913994/03/2021288
36264314795/03/2021141
37264399896/03/2021217
38162984997/03/2021371
39132411398/03/2021270
40151295699/03/2021442
416414552910/03/2021235
422863996911/03/2021204
431692124912/03/2021263
441692232913/03/2021245
456295357914/03/2021232
Sheet3


And desire result in the form

1655296214402.png
 

Excel Facts

Show numbers in thousands?
Use a custom number format of #,##0,K. Each comma after the final 0 will divide the displayed number by another thousand

Forum statistics

Threads
1,223,893
Messages
6,175,240
Members
452,621
Latest member
Laura_PinksBTHFT

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top