Need a cumulative total per month based on calculated column

[JeroenHD]

Hello Team, 

I can't seem to make this one work. I have a calculated column. In the Opportunities Table is where this column lives. It's multiplying a currency amount based on a lookup (to determine the factor to do multiplication). 

This returns the new amount we call Factored Revenue.

Calculated column:

Factored revenue £ = lookupvalue(Z_Factored_stepname[Factor_stepname],Z_Factored_stepname[pi_reportingstage],opportunities[pi_reportingstage])*[Open Revenue £]

Now i want to use this calculated column to use in a measure which does a cumulative per month of this factored revenue.
The below is what i got so far. I am using a date table. What the below does is summing all and put the same amount in all months.
What do i do wrong? 

Cumulative Factored Revenue £ 2 =

IF(MIN(DATE_TABLE[Date])

<= CALCULATE(MAX(Opportunities[actualclosedate]), ALL(Opportunities)),

CALCULATE(

sum(Opportunities[Factored revenue £]),

FILTER(

ALL(DATE_TABLE[Date]),

DATE_TABLE[Date]<=MAX(DATE_TABLE[Date]))

))

The result in a table visual: 

Thanks for your time to take a look. 

Kind regards,
Jeroen

[JeroenHD]

Thanks a heap @amitchandak this did the trick!!

[amitchandak · Accepted solution]

@JeroenHD , Try like

CALCULATE(
sum(Opportunities[Factored revenue £]),
FILTER(
ALL(DATE_TABLE),
DATE_TABLE[Date]<=MAX(DATE_TABLE[Date]))
)

I think issue with max logic