Forum Discussion

mccollough's avatar
mccollough
Icon for Helper I rankHelper I
4 years ago

Need Help Joining Between Two DateTimes & a Foriegn Key

Hi Everyone! I have one table that looks like this Shift _Table StartDateTime           EndDateTime           Shift                      EmployeeID 1/1/2022 8:00 1/1/2022 18:00 Day ...
Need Help
HoangHugo's avatar
HoangHugo
Icon for Solution Specialist rankSolution Specialist
4 years ago

Hi

try this calculate column

Shift = MAXX (CALCULATETABLE(Transaction_table,EARLIER(TransactionDate)>StartDatetime,EARLIER(TransactionDate)<EndDatetime),Shift)

mccollough's avatar
mccollough
Icon for Helper I rankHelper I
4 years ago

Hi HoangHugo ,

Thank you so much for taking the time to respond! I'm trying to implement the solution you described, but PowerBI says it can't find the TransactionDate column even when I use SELECTEDVALUE(). Do you have any other relationships between the columns besides one between EmployeeIDs? 

Thanks again for your help!