Forum Discussion
calculation modification
i have table uptime and mint averger uptime : Up time = CALCULATE(DIVIDE([calc op per day],[calc op per day manne]),FILTER('PA - E2PR',AND('PA - E2PR'[Year] = MAX(calender[Year]),'PA - E2P...
Anonymous , Not very clear. Can you share sample data and sample output in table format? Or a sample pbix after removing sensitive data.
You can use measure like these with help from date table
last 3 month allocated value
CALCULATE([Uptime]*.5,DATESMTD(dateadd('Date'[Date],-1,MONTH)))+
CALCULATE([Uptime]*.3,DATESMTD(dateadd('Date'[Date],-2,MONTH)))+
CALCULATE([Uptime]*.2,DATESMTD(dateadd('Date'[Date],-3,MONTH)))
Rolling 3 Avg = CALCULATE(averageX('Date'[Month Year],[Uptime]),DATESINPERIOD('Date'[Date ],MAX('Date'[Date ]),-12,MONTH))