Forum Discussion
Comparing values from different tables
Hi habaholic,
I assume both tables have time or dates for their cycle, if you for example want a line chart with both lines so you can compare.
You can make a "date table" and make a relationship between both "Date"columns of your two tables and the newly created date table.
After you did this you can make the column "Date"(from the newly created table) the X-axis and then the visualisation should work with data from both tables.
Link on how to make a date table:
https://www.youtube.com/watch?v=F2V0IKp6hKM
Please le me know if this worked for you.
Regards,
L.Meijdam
Both tables have dates. However what I am interested in is comparing this weeks production cycle time vs the best time for that product in 2015.
Example (this data is in 2 different tables. One for 2015 data, one for 2017 data)
Date Product Code Cycle Time
01/01/2015 P123456 14
25/08/2015 P123456 10
16/11/2015 P123456 12
04/02/2017 P123456 8
Now I want to compare my 04/02/2017 time to my best time in 2015 (10). So the efficiency would be (8/10)*100=80%.
I want to do this for all machines/products for the month and then give me a total d3epartment efficiency based on all machine/product results. I have 45 machines working 24 day, producing many different products per month.
Hi habaholic,
So you want:
*Selected value* / MIN(2015[Cycle Time])
(the * 100 is not needed if you set the format to %)
of a certain product ?
Regards,
L.Meijdam
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.