Share via

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.
39,708 questions
0 comments

1 answer

Sort by: Most helpful
Most helpful Newest Oldest
  1. Lz._ 9,006 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)

Your answer

Answers can be marked as Accepted Answers by the question author, which helps users to know the answer solved the author's problem.