Calculate cummilative from current category to previous category

[Sriku]

Hi Team,

Can anyone please suggest how to achieve column B in PBI DAX.

Category	Number	%
A	1843	16.2%
B	299	59.3%
C	177	100.0%
D	177	62.1%
E	110	89.5%
F	98	96.2%
	94	0.0%

I want to mutiply for Category B (Number B2*C2) (1843*16.2% = 299, Category C = (Number B3*C3 (299*59.3% = 177)

Please suggest, this data is in agreegated level. I need any DAX caculation is possible in this

Regards,

Sriku

[amitchandak]

@Sriku , Refer if window function can help

Pareto Analysis Again, 80% of sales, Order by Measure when REL position is used: https://youtu.be/GpoITi_tRIw

Power BI Window function Rolling, Cumulative/Running Total, WTD, MTD, QTD, YTD, FYTD: https://youtu.be/nxc_IWl-tTc