Forum Discussion

slounsbury's avatar
slounsbury
Helper 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
Super 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
Helper II
8 years ago

Thank you! This did the trick.