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
Anonymous's avatar
Anonymous
Not applicable
2 years ago

Hi jaysoulz ,

The DAX formula you provided seems almost correct, but I would suggest a slight modification:

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

 

 

How to Get Your Question Answered Quickly 

 

If it does not help, please provide more details with your desired output and pbix file without privacy information (or some sample data) .

 

Best Regards
Community Support Team _ Rongtie

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

 

 

 

 

jaysoulz's avatar
jaysoulz
Helper I
2 years ago

I change your DAX into

 

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

 

However, it does not provide all the correct time:


Thanks for the help!