Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago

Average Calculation

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
DAX
VAR
Variable calculation

1 Reply

  • amitchandak's avatar
    amitchandak
    Super User
    5 years ago

    Anonymous , 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])