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...
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

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

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

    Thank you! This did the trick.