Change in efficiency of the last 5 days vs efficiency of last year

[JoeKat07]

Hello all,

I am trying to find the change in efficiency for a manufacturing company of the over the last 5 days vs the last year.

i have Efficiency = [Good Qty] / [Hours Worked]

i need to then find the difference between the median over the last 5 days and subtract the median over the last year to find the change in efficiency.

[Greg_Deckler · Accepted solution]

Switch your Efficiency calculation to a measure:

Efficiency = SUM([Good Qty]) / SUM([Hours Worked])

Then wrap it in a CALCULATE and use a PREVIOUSYEAR filter to generate another measure. Use a CALCULATE and another filter for the median of the last 5 days to create another measure. Finally, create one more measure that subtracts the previous two measures.