DATEDIFF in calculated column

[ellac]

Hi,

I'm trying to create a calculated column in our tabular model (creating the DAX code for that in Tabular Editor) subtracting two DateTime columns.

Column 1 (DateTime)

Column 2 (DateTime)

Calculated Column = DATEDIFF[Column 1], [Column 2], HOUR)

The two columns are of type DateTime, and the resulting calculating column will be an integer (when using the DATEDIFF function). When trying this I get the an evaluation error saying something like "...can't convert value from type Text to type Integer". 

I've also tried this calculation: Calculated Column = [Column 2] - [Column 1], but I still get the error message.

Any input is appreciated, thanks!

/Ella

[amitchandak]

@ellac , This seem correct

Try like

Calculated Column = DATEDIFF[Column 1], [Column 2], HOUR)*1

In this case you can have like

Calculated Column = int([Column 2] - [Column 1]) //But I doubt that will hours