Forum Discussion

shainis's avatar
shainis
Helper I
7 years ago
Solved

DATEDIFF help

Hi,

 

I'm trying to calculate DATEDIFF but getting weird results... I would like to see in "Column" 1.5, 1.5, 2, 1.5 etc.

I'll appreciate your help with that.

Thanks!

 

Need Help
  • AlB's avatar
    AlB
    7 years ago

    Hi shainis

     

    A few questions:

    Can you share the pbix? Are [EndDate] and [EventDate] measures? Can you show their code?

    Is what you want to calculate a column or a measure?

     

    In the meantime, try this instead:

         ([EndDate] - [EventDate]) * 24

     

    which should yield the difference in hours

2 Replies

  • AlB's avatar
    AlB
    Community Champion
    7 years ago

    Hi shainis

     

    A few questions:

    Can you share the pbix? Are [EndDate] and [EventDate] measures? Can you show their code?

    Is what you want to calculate a column or a measure?

     

    In the meantime, try this instead:

         ([EndDate] - [EventDate]) * 24

     

    which should yield the difference in hours

    • shainis's avatar
      shainis
      Helper I
      7 years ago

      Thanks, AlB, that worked!

       

      An alternative solution would be to use the Time Subtruct. Both are doing the job.

      Thank you!