Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

Use of DATEDIFF function in calculated column using Direct query mode

Is there any way too use DATEDIFF function while creating calculated column using Direct query mode? Or any other way to calculate difference between two dates in calculated column using Direct quer...
  • v-diye-msft's avatar
    v-diye-msft
    6 years ago

    Hi Anonymous 

     

    Based on my test,it is supported to add datediff calculated column in Direct query mode, plz see below capture:

v-diye-msft's avatar
v-diye-msft
Icon for Community Support rankCommunity Support
6 years ago

Hi Anonymous 

 

Based on my test,it is supported to add datediff calculated column in Direct query mode, plz see below capture: