Forum Discussion

habaholic's avatar
habaholic
Frequent Visitor
8 years ago

Comparing values from different tables

This question is in regards to a manufacturing environment.   I have cycle time production data from this year (2017) and I want to compare my current cycle times per product to the best cycle time...
Need Help
Tutorial Requests
habaholic's avatar
habaholic
Frequent Visitor
8 years ago

OK. One issue, I don't want to compare Best Time 2017 vs Best Time 2015. What I want to do is compare my current production cycle time vs the Best Time 2015 for the same product. If the product was not produced in 2015 then return no value. 

 

I think your suggestion for the BestCycleTime2015 is OK. But then I need to compare individual production runs from 2017 against this time, and then calculate a total for the month across all products produced.

Zubair_Muhammad's avatar
Zubair_Muhammad
Community Champion
8 years ago

habaholic

 

Try this measure in Table 2017

 

=
IF (
    HASONEVALUE ( Table2017[Product] ),
    DIVIDE (
        SUM ( Table2017[Cycle Time] ),
        CALCULATE (
            MAX ( Table2015[Cycle Time] ),
            FILTER ( Table2015, Table2015[Product] = VALUES ( Table2017[Product] ) )
        )
    )
)