Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Reply
kolousekjan
New Member

Average per month

I have simple table with 3 columns

Index - every month from now back is +1

Datum

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! 

Výstřižek.PNG

2 REPLIES 2
unihoxis
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 

kolousekjan
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
                                    )/60
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

RETURN
_Oee

Helpful resources

Announcements
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

Find out what's new and trending in the Fabric Community.