Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
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!
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.
User | Count |
---|---|
42 | |
28 | |
23 | |
18 | |
16 |
User | Count |
---|---|
54 | |
35 | |
18 | |
18 | |
15 |