Forum Discussion
Calculated Column - Current Value minus Previous Value (DirectQuery)
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 ...
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.