Showing results for 
Search instead for 
Did you mean: 
New Member

Average per month

I have simple table with 3 columns

Index - every month from now back is +1


OEE - calculated measure

Calendar_StartDT - basically shift (6:00,14:00,22:00)


I want to show average of OEE in chart of last 4 months back but I cant find how. 

OEE is measure calculated per shift and if I put it on chart its ok if I have date on X but when I put there MonthIndex it probably SUM those values 


Any idea how to get this average per index (month) ? Thank you! 


Frequent Visitor

Topic closed


problem was in my variable VAR _plannedProd where I didnt add days so when I filteres data I still had data only for one day 

New Member

to make it bit more clear, here is how I calculate OEE


OEE Average =
VAR _plannedProd = AVERAGE(View_Calendar_ProductionPlan_All[ShiftDuration]) * DISTINCTCOUNT(View_Calendar_ProductionPlan_All[SmenaStart.2]) * 52.5
VAR _DtUnplan = CALCULATE(SUM(View_Calendar_ProductionPlan_All[Eval_Duration]),
                                View_Calendar_ProductionPlan_All[ActivityCategory_ID] = 2    //Organizacni prostoj
VAR _ProdTime = _plannedProd - _DtUnplan
VAR _PlannedPcs = SUM(Vyrobni_target[HourTarget]) * (DIVIDE([ProductionTime],60))
VAR _Availability = DIVIDE(_ProdTime, _plannedProd)
VAR _Performance = DIVIDE(SUM(View_Calendar_ProductionPlan_All[Eval_Produced]),_PlannedPcs)
VAR _Oee = _Availability * _Performance


Helpful resources

PBI Sept Update Carousel

Power BI September 2023 Update

Take a look at the September 2023 Power BI update to learn more.

Learn Live

Learn Live: Event Series

Join Microsoft Reactor and learn from developers.

Dashboard in a day with date

Exclusive opportunity for Women!

Join us for a free, hands-on Microsoft workshop led by women trainers for women where you will learn how to build a Dashboard in a Day!

MPPC 2023 PBI Carousel

Power Platform Conference-Power BI and Fabric Sessions

Join us Oct 1 - 6 in Las Vegas for the Microsoft Power Platform Conference.

Top Solution Authors