Forum Discussion
First value of another table base on date
Hi, I have 2 tables. Table 1 contains IDBoard and the date/time for each: Table 2 contains production run with a start date and end date: In table 2 I want to add a new column with ...
Hi Anonymous ,
You use this measure:
First IDBoard = VAR start1 = SELECTEDVALUE ( table2[start] ) VAR end1 = SELECTEDVALUE ( table2[end] ) RETURN CALCULATE ( MIN ( table1[idBoard] ), table1[timeStamp] >= start1 && table1[timeStamp] <= end1 )Best Regards,
Eads
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
vanessafvg
Community Champion
Community ChampionAnonymous can you provide the data in text format? (ie no pics)