Forum Discussion
Solved
Match Sample Datetime to production run?
Hey Everyone, I have 2 tables of Data, the first which contains the start and end times for a production run as well as the target value for a particular measured variable of the product. Sec...
Hi tomr
If I understand correctly, you want your sample table to carry the production run and target value.
If so, please add these two calculated columns. I have attached a PBIX file.
Product Run = MAXX( FILTER( 'Table1', 'Table1'[Start Time] < EARLIER('Table2'[Datetime Sample]) && EARLIER('Table2'[Datetime Sample]) < 'Table1'[End Time]) ,[Production Run])and
Target Value = MAXX( FILTER( 'Table1', 'Table1'[Start Time] < EARLIER('Table2'[Datetime Sample]) && EARLIER('Table2'[Datetime Sample]) < 'Table1'[End Time]) ,[Target Value])
Hi tomr
If I understand correctly, you want your sample table to carry the production run and target value.
If so, please add these two calculated columns. I have attached a PBIX file.
Product Run =
MAXX(
FILTER(
'Table1',
'Table1'[Start Time] < EARLIER('Table2'[Datetime Sample]) &&
EARLIER('Table2'[Datetime Sample]) < 'Table1'[End Time])
,[Production Run])
and
Target Value =
MAXX(
FILTER(
'Table1',
'Table1'[Start Time] < EARLIER('Table2'[Datetime Sample]) &&
EARLIER('Table2'[Datetime Sample]) < 'Table1'[End Time])
,[Target Value])Perfect, thanks for that Phil_Seamark
