Calculated Column - Current Value minus Previous Value (DirectQuery)

stalerik — Fri, 02 Jul 2021 01:01:34 GMT

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!

Re: Calculated Column - Current Value minus Previous Value (DirectQuery)

Anonymous — Fri, 02 Jul 2021 07:31:26 GMT

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.

topic Re: Calculated Column - Current Value minus Previous Value (DirectQuery) in DAX Commands and Tips

Calculated Column - Current Value minus Previous Value (DirectQuery)

Re: Calculated Column - Current Value minus Previous Value (DirectQuery)