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
Daniel29195's avatar
Daniel29195
Community Champion
2 years ago

jaysoulz 

 

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

 

 

let me know if this works for you . 

jaysoulz's avatar
jaysoulz
Helper I
2 years ago

Nope. All results are 2023-12-31 11:56:51AM. The result date doesnt match the Punch Out date...