Display Absolute Value Of DATEDIFF Column

[slounsbury]

I have a column that has the difference in time but some of the values are reading as the correct number just negative. Is there away to modify my query to make all numbers absolute? 

Query Being Used:

ART = DATEDIFF(v_rpt_Service_SLA[ART_ST], v_rpt_Service_SLA[Date_Responded_UTC],HOUR)

[MFelix · Accepted solution]

Hi @slounsbury,

Just wrap your measure with ABS formula:

ART =
ABS (
    DATEDIFF (
        v_rpt_Service_SLA[ART_ST],
        v_rpt_Service_SLA[Date_Responded_UTC],
        HOUR
    )
)

Regards,

MFelix

[slounsbury]

Thank you! This did the trick.