topic DAX formula for Cumulative Supply in DAX Commands and Tips

DAX formula for Cumulative Supply

rkkumar79 — Fri, 05 Aug 2022 08:26:27 GMT

Hi,

I am new to powerbi.need help on below.
Need a DAX formula for Cumulative supply as mentioned below.

Cumulative supply formula to be
1st Jan = Supply
2nd Jan = Cumm Sales till previous day+2nd Supply
3rd Jan = Cumm Sales till previous day+3rd Supply
4th Jan = Cumm Sales till previous day+4th Supply
and so on.

Date	Supply	Sales	C.Sales	C.Supply
01-Jan	25	20	20	25
02-Jan	10	4	24	30
03-Jan	9	5	29	33
04-Jan	10	8	37	39
05-Jan	22	7	44	59
06-Jan	0	0	44	44
07-Jan	15	9	53	59
08-Jan	9	9	62	62
09-Jan	0	0	62	62
10-Jan	12	8	70	74

Re: DAX formula for Cumulative Supply

daXtreme — Sat, 06 Aug 2022 08:51:59 GMT

Solved: Cumulative total - Microsoft Power BI Community

Re: DAX formula for Cumulative Supply

memepu — Tue, 09 Aug 2022 06:58:16 GMT

Hi rkkumar79 ,

Please have a try.

Create a measure.

Measure = CALCULATE ( SUM ( 'Table'[Sales] ), FILTER ( ALL ( 'Table' ), 'Table'[Date] <= SELECTEDVALUE ( 'Table'[Date] ) ) )

Or a column.

column = CALCULATE ( SUM ( 'Table'[Sales] ), FILTER ( ( 'Table' ), 'Table'[Date] <= EARLIER( ( 'Table'[Date] ) ) ) )

If I have misunderstood your meaning, please provide more details with your desired output.

Best regards.