Best way to create a field with the total hours since a date/time

[JuliaYebra]

I'm trying to create a field which shows how many hours have passed since a specific date/time.

Something very simple in theory.

In the Edit query option the function now() is not recognized, so I had to create a measure Now=now() and then a column DIF=Now-DateTimeField with the difference, but the result is a decimal number that I couldn't change into a duration field.

And even if I could do that, there is no way to add a column with the Total Hours as you can do in the EditQuery Options.

How do you do this kind of things? I'm sure it must be very simple!

[Greg_Deckler · Accepted solution]

Try:

Column = DATEDIFF([Date],NOW(),HOUR)

This is DAX, not query editor by which I assume that you were referring to "M" but your formulas looked like DAX. A bit confused. 

[JuliaYebra]

That was perfect!

Thank you vey much!!!