Forum Discussion
Solved
Calculated Column based on another table
Hello All, I've two tables in my project - no relationship exists Table 1 dt.start dt.end jobtyp 13/06/2022 00:15 13/06/2022 01:30 Travel 17/06/2022 17:45 18/06/2022 10:00 Trave...
neees78 Try:
Column = MAXX(FILTER('Table2', Table1[dt.start] >= Table2[dt.start] && Table1[dt.end] <= Table2[dt.end]), [jobtyp])
Greg_Deckler if I have an ID column in both tables, can we add a condition or second filter to make sure it returns correct [jobtyp] or that row, what I found is that some jobs do cross over in times, thus it returns the first [jobtyp] within that time interval.
regards