last 12 hours flag

[paw2]

Hi,

I have a Time Range field like below. Please can you help me to derive Expected Flag like below. From current time to last 12 hours need to flag it as Last 12 hours else  >Last 12 hours.

Time Range                                 Expected Flag

Wed, 15 Feb 2023 07:51:22        Last 12 hours

Wed, 15 Feb 2023 06:20:26        Last 12 hours

Tue, 14 Feb 2023 15:23:35          >Last 12 hours

I have tried below logic

Flag = if(MAX('Table1'[Time Range])<=NOW() && MAX('Table1'[Time Range])>=NOW()-12/24,"Last 12 hrs"," > Last 12 hrs") but agetting all records as >Last 12 hours only.

[AllisonKennedy · Accepted solution]

@paw2  You could try using DATEDIFF:

Flag = 
VAR _HoursDiff =  
DATEDIFF( MAX( 'Table1'[Time Range] ) , NOW(), HOUR) 
RETURN
SWITCH( TRUE(),

  _HoursDiff >= 12, "> Last 12 hrs",
 _HoursDiff >= 0, "Last 12 Hours",
"Future Time"
)