Forum Discussion
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...
Yes, for specific product. In my excel file I have it as:
VLOOKUP=([@Product Code],Table5[#ALL],3,FALSE)
I want to do the same thing across 2 tables in Power BI.
Sorry if I am making this more difficult than it needs to be. I am new to Power BI.
Sorry. The previously mentioned VLOOKUP is to get the best time from 2015. I than use this value to calculate current efficiency.