Forum Discussion

slounsbury's avatar
slounsbury
Icon for Helper II rankHelper II
8 years ago
Solved

Display Absolute Value Of DATEDIFF Column

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)

Need Help
  • MFelix's avatar
    MFelix
    8 years ago

    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

2 Replies

  • MFelix's avatar
    MFelix
    Icon for Super User rankSuper User
    8 years ago

    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