Forum Discussion
Date Difference in Direct query
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
Are there any other ways of addressing this Date Difference issue in Direct Query?
Hey,
You can try using ([Date A]-[Date B])*24.
