rolling Percentage

[NewbieJono]

Hello, How could i do a rolloing percentage based on the days before in the table

as table below  in the last coloumn (Bold) 

e.g in excel for 4th Jan the formula would be =SUM(C4:C7)/SUM(D4:D7)

Col B	Col C	Col D	Col E	Col F
Date	Total Faillure	Total Transactions	Daily Percentage Failure Rate	2021 Percentage Failure Rate
1-Jan	33,356	133,439	25.0%	25.0%
2-Jan	29,723	105,391	28.2%	26.4%
3-Jan	20,482	69,621	29.4%	27.1%
4-Jan	36,483	114,126	32.0%	28.4%
5-Jan	27,479	87,791	31.3%	28.9%
6-Jan	47,261	175,268	27.0%	28.4%
7-Jan	59,169	228,002	26.0%	27.8%
8-Jan	45,075	167,957	26.8%	27.6%
9-Jan	30,831	111,596	27.6%	27.6%
10-Jan	22,129	76,945	28.8%	27.7%
11-Jan	36,722	127,618	28.8%	27.8%
12-Jan	30,913	105,177	29.4%	27.9%
13-Jan	30,414	103,153	29.5%	28.0%
14-Jan	27,548	93,663	29.4%	28.1%

[amitchandak · Accepted solution]

@NewbieJono , With help from date table

Divide(

CALCULATE(SUM(Table[Col C]),filter(allselected('Date'),'Date'[date] <=max('Date'[date]))) ,

CALCULATE(SUM(Table[Col D]),filter(allselected('Date'),'Date'[date] <=max('Date'[date])))

)

or

Divide(

CALCULATE(SUM(Table[Col C]),filter(allselected('Table'),'Table'[date] <=max('Table'[date]))) ,

CALCULATE(SUM(Table[Col D]),filter(allselected('Table'),'Table'[date] <=max('Table'[date])))

)