Calculated Column - Current Value minus Previous Value (DirectQuery)

[stalerik]

Hello all,

I am looking for a method to calculate the difference between the current value and a value in the same row from one hour ago.  I have tried several examples but I get stuck because I am using a DirectQuery connection.  I am also not sure if I should use calculated column or measure but I have been trying for a calculate column.  My table has a DateTime column and a Values column.  Thank you!

[SanketBhagwat]

Hi @stalerik .

I am not sure whether all calculations related to Date/Time are supported in DirectQuery.

In DirectQuery, limited number of DAX functions can be used.

Still you can try creating a measure by allowing unrestricted measures.

Go to File->Options and Settings->Options->Globa->DirectQuery->"Allow unrestricted measures in DirectQuery mode".

However this is not recommended as it may send heavy T-SQL scripts.

If this post helps, then please mark it as 'Accept as Solution' so that others could find it easily.

Regards,

Sanket Bhagwat.