Use SWITCH with TIME() / time frames.

Hi RemiAnthonise ,

The question is about the data although you see the hours only the data behind is date so you need to get onlythe time part of Patient[Gepland ontslagtijd aangepast] column, redo your calculation to:

Tijdsblok ontslag =
VAR Hour_Part =
    TIME ( HOUR ( Patient[Gepland ontslagtijd aangepast] ); MINUTE ( Patient[Gepland ontslagtijd aangepast] ); SECOND ( Patient[Gepland ontslagtijd aangepast] ) )
RETURN
    SWITCH (
        TRUE ();
        Hour_Part > TIME ( 07; 00; 00 )
            && Hour_Part < TIME ( 15; 00; 00 ); TIME ( 15; 00; 00 );
        Hour_Part > TIME ( 15; 00; 00 )
            && Hour_Part < TIME ( 23; 00; 00 ); TIME ( 23; 00; 00 );
        TIME ( 07; 00; 00 )
    )

Gives the result below:

I'm not addin the PBIX since it tell me it was done on a previous version so if I send it out to you it will not open.

Regards,

MFelix