Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

Date.adddays function not supported in Direct Query Mode ?

Hello    Trying to add a custom column in Query editor with date function in direct query mode is giving a message "Step is not supported in DIrect Query Mode".    Function used is -  Date.AddDay...
Need Help
  • v-frfei-msft's avatar
    v-frfei-msft
    6 years ago

    Hi Anonymous ,

     

    Based on my test, we cannot use the function for direct query.

     

    We can use calculated column to work around.

     

    Column = 'Product'[SalesDate] +3

     

     

     

v-frfei-msft's avatar
v-frfei-msft
Community Support
6 years ago

Hi Anonymous ,

 

Based on my test, we cannot use the function for direct query.

 

We can use calculated column to work around.

 

Column = 'Product'[SalesDate] +3

 

 

 

  • Anonymous's avatar
    Anonymous
    Not applicable
    6 years ago

    Thank you. That was much simpler option