Date Difference in Direct query

[Karthikreddy523]

How to calculate the date difference between 2 date columns in Direct query? I tried DateDiff function, but this is not supporting in Direct Query mode

[CathyT]

None of the above options work.  I always get the "not supported in directquery mode" message.

[Anonymous]

Are there any other ways of addressing this Date Difference issue in Direct Query?

[grazitti_sapna]

Hey, 

You can try using  ([Date A]-[Date B])*24.

[Greg_Deckler]

@Karthikreddy523 Try:

( [Date 1] - [Date 2] ) * 1.

[Anonymous]

I tried it,but the results are not accurate and i need the difference in years.Please find the screenshot here