Forum Discussion

Proday83's avatar
Proday83
Frequent Visitor
2 years ago
Solved

Calculate Total Availability per Line Weekly

Hello everyone,   I have a new challenge ahead of me...right now in excel we have daily imput of issues on Line1 and Line2 (line column below). I need to present Total Availability on a Weekly base...
Need Help
  • Daniel29195's avatar
    Daniel29195
    2 years ago

    if you need the sum of minimum, 

    then change planned production time measure to  :  

    sumx (

    values ( date ) ,

    calculate (

    min ( failure_rates_data[planned production time]),

    failure_rates_data[line] = "Line1"
    )
    )

Ashish_Mathur's avatar
Ashish_Mathur
Super User
2 years ago

Hi,

Try this measure

Measure = averagex(values(Calendar[Date]),[Total availability Daily Line1])

Hope this helps.