Forum Discussion

jaysoulz's avatar
jaysoulz
Icon for Helper I rankHelper I
2 years ago

USERELATIONSHIP with FILTER

Hi, I am trying to display the correct timing from my worker and I am having the issue where I need two dates (one for Start Time ; Stop Time). Calendar [Date] is linked to DATA [StartDate] (ac...
Need Help
amitchandak's avatar
amitchandak
Icon for Super User rankSuper User
2 years ago

jaysoulz , Try like

 

StopDateTime =
CALCULATE(CALCULATE(
MAX(DATA[StopDateTime]),USERELATIONSHIP(DATA[StopDate], 'Calendar'[Date]))
FILTER(
DATA,
HOUR(DATA[StopDateTime]) < 12
)

)

jaysoulz's avatar
jaysoulz
Icon for Helper I rankHelper I
2 years ago

It does not seem to work:




Thanks for helping!