Forum Discussion

stalerik's avatar
stalerik
Helper II
5 years ago

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 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!

1 Reply

  • Anonymous's avatar
    Anonymous
    Not applicable
    5 years ago

    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.