DATEDIFF help

[shainis]

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!

[AlB · Accepted solution]

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]

Thanks, @AlB, that worked!

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

Thank you!