i have table column based on value its split weekly date .
WEEK = var a = DATE(2020,08,03)
var b = IF(DatePA[Week Date] = a,"Outbound GLOBAL",IF(DatePA[Week Date]<>BLANK(),"Outbound" & DatePA[Week Date]))
return b
Uptime :
Date = EOMONTH(MAX('DatePA'[Week Date]),-1)
Measure = EOMONTH([Date],-3)
Up time =
CALCULATE (
DIVIDE ( [calc op per day], [calc op per day manne] ),
FILTER (
'PA - E2PR',
AND (
'PA - E2PR'[Effective Date] < [Date],
'PA - E2PR'[Effective Date] >= Measuress[Measure]
)
)
)
Uptime Next:
Datenxt = EOMONTH(MAX(DatePA[Week Date]),0)
Measurenxt = EOMONTH([Datenxt],12)
Up time next =
CALCULATE (
DIVIDE ( [calc op per day], [calc op per day manne] ),
FILTER (
'PA - E2PR',
AND (
'PA - E2PR'[Effective Date] > [Datenxt],
'PA - E2PR'[Effective Date] <= Measuress[Measurenxt]
)
)
)
i have two value splitted uptime and uptime next .
Uptime have previous three month value .
its multiple by constant three value
Ex:
if i select april the value like
Jan * 0.5
Feb *0.3
March *0.2
this avg value should be show may june july same after that Aug,sep,oct it will increase by 1 .
please refere excel sheet screen shot reference

i have tired create mesure but not working. thanks in advance