Forum Discussion

Syndicate_Admin's avatar
Syndicate_Admin
Administrator
5 years ago
Solved

Problem with function "DATEADD"

Good fellows, I hope you can help me. I'm trying to calculate the variation month by month with the following measure: However, I get the following error: and as you can see, the data i...
  • v-henryk-mstf's avatar
    v-henryk-mstf
    5 years ago

    Hi Syndicate_Admin ,

     

    Which connection mode does the data source you connect to adopt? For the DATEADD function, if it is in the Direct query mode, there may be performance problems, leading to errors.

     

    Here is the reference document link:DATEADD function (DAX) - DAX | Microsoft Docs

     

    Please make sure to use this function correctly and change the connection mode before trying again. If the problem is still not resolved, please let me know immediately, looking forward to your reply.

    Best Regards,
    Henry

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

v-henryk-mstf's avatar
v-henryk-mstf
Community Support
5 years ago

Hi Syndicate_Admin ,

 

Which connection mode does the data source you connect to adopt? For the DATEADD function, if it is in the Direct query mode, there may be performance problems, leading to errors.

 

Here is the reference document link:DATEADD function (DAX) - DAX | Microsoft Docs

 

Please make sure to use this function correctly and change the connection mode before trying again. If the problem is still not resolved, please let me know immediately, looking forward to your reply.

Best Regards,
Henry

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.