Calculation error in messure

Teju 1 Reputation point
2021-07-08T07:11:08.123+00:00

Error Message:
MdxScript(Model) (6, 77) Calculation error in measure 'Sales OrderLines'[Quantity sold LY]: A column specified in the call to function 'SAMEPERIODLASTYEAR' is not of type DATE. This is not supported.
112879-error-1.jpg

Not Monitored
Not Monitored
Tag not monitored by Microsoft.
35,748 questions
0 comments No comments
{count} votes

1 answer

Sort by: Most helpful
  1. Lz._ 8,986 Reputation points
    2021-07-08T07:24:04.38+00:00

    @Teju

    The error message says it all:

    A column specified in the call to function 'SAMEPERIODLASTYEAR' is not of type DATE

    You provide nothing else than the error message and a picture => Nobody will be able to help further than:
    Go to your Data Model > For each table involved in your 'Sales OrderLines'[Quantity sold LY] measure check the Type of the various Date columns, they must be of type Date and not i.e. Text (highly probably the case for at least one of them)