Forum Discussion

ZataConsulting's avatar
ZataConsulting
Regular Visitor
8 years ago
Solved

MdxScript(Model)(187,74).....Calulcation error in measure

I have use the followin formu;ar Total Revenue LY = Calculate([Total Revenue],SAMEPERIODLASTYEAR(DimDate[Date].[Year])) and get the following error message       Here is part of the error message...
  • v-jiascu-msft's avatar
    v-jiascu-msft
    8 years ago

    Hi ZataConsulting,

     

    Please try again without the ".[Year]" part. 

     

    Total Revenue LY =
CALCULATE ( [Total Revenue], SAMEPERIODLASTYEAR ( DimDate[Date].[Year] ) )

    Mdx_Script_Model

     

     

    Best Regards,

    Dale

Interkoubess's avatar
Interkoubess
Icon for Solution Sage rankSolution Sage
8 years ago

Hi ZataConsulting,

 

Please create a date table ( with continuous date) and link it to your "fact" table.

Then you can use these formula to calculate previous period revenue.

 

We can assist if you have any issues.

 

 

Ninter

ZataConsulting's avatar
ZataConsulting
Regular Visitor
8 years ago
Total Revenue LY =
CALCULATE ( [Total Revenue], SAMEPERIODLASTYEAR ( DimDate[Date].[Year] ) )

  Thankyou. The solution works.