Average Calculation

[jwhitf4770]

How would you write this query?   It is to add up different columns * 200000 / sum of another column.   I'm trying to break it down as simple as possible.   StartDate is a date 12 months ago.  It doesn't allow me to do calculations on var.  Thanks in Advance.

DART rolling average 2 =

var _LT = Calculate(sum(HSE[Lost Time]), ,FILTER(HSE,HSE[Date] > Value([StartDate])),

var _RR = Calculate(sum(HSE[Restricted Recordable]),FILTER(HSE,HSE[Date] > Value([StartDate])),

var _OR = Calculate(sum(HSE[Other Recordable]),FILTER(HSE,HSE[Date] > Value([StartDate])),

var _sums = calculate((_LT + [_OR] + [_RR] * 200000),

var _hours = Calculate(sum(HSE[Hours]),FILTER(HSE,HSE[Date] > Value([StartDate]),

return _sums/_hours

[amitchandak]

@jwhitf4770 , Can you share sample data and sample output in table format? Or a sample pbix after removing sensitive data.

Inplace of Value([StartDate]) you need to have min([StartDate])