Forum Discussion

jaysoulz's avatar
jaysoulz
Helper 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
Super 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
    Helper I
    2 years ago

    It does not seem to work:




    Thanks for helping!