Forum Discussion

Angela000's avatar
Angela000
New Member
2 years ago
Solved

SQL Analysis service query

  I would like to calculate patients retention rate, for any pathent who has visisted a practice in the first 6 months(for example:Jan, Feb, Mar, Apr, May, Jun) and returned in the next 6 months(for...
Tutorial Requests
  • Anonymous's avatar
    Anonymous
    2 years ago

    Hi Angela000 ,

    SQL Analysis server 2012 is already a very old version, and INTERSECT, EXCEPT and other functions belong to the advanced functions in DAX, may be the version really can not support all or part of the functions in the function.
    Also, the error reported here already provides error localization, could you please check what function is used at that location? Or what syntax error exists in that location?



    If you can, please change to a more advanced version of SSAS for testing, and have checked if the error is caused by the outdated version.

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

Anonymous's avatar
Anonymous
Not applicable
2 years ago

Hi Angela000 ,

SQL Analysis server 2012 is already a very old version, and INTERSECT, EXCEPT and other functions belong to the advanced functions in DAX, may be the version really can not support all or part of the functions in the function.
Also, the error reported here already provides error localization, could you please check what function is used at that location? Or what syntax error exists in that location?



If you can, please change to a more advanced version of SSAS for testing, and have checked if the error is caused by the outdated version.

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