Forum Discussion

WaelTalaat79's avatar
WaelTalaat79
Icon for Helper I rankHelper I
4 years ago

Hi dear

I am trying to calculate a if condition for previousmonth and I got this message  MdxScript(Model) (13, 76) Calculation error as attached photo 
Need Help
Fowmy's avatar
Fowmy
Icon for Super User rankSuper User
4 years ago

WaelTalaat79 

Modify your meusre as follows: 

= IF( MONTH( PREVIOUSMONTH( 'Dates'[Date].[Date] ) ) = 12 , 0 , 1 )



  • WaelTalaat79's avatar
    WaelTalaat79
    Icon for Helper I rankHelper I
    4 years ago

    error message MdxScript(Model) (13, 72)

     

    = 12 mean December so should I select MonthNo instead of date

    • Fowmy's avatar
      Fowmy
      Icon for Super User rankSuper User
      4 years ago

      WaelTalaat79 

      Where/what are you using this measure? Please share screenshot of the calcualtion 

      • WaelTalaat79's avatar
        WaelTalaat79
        Icon for Helper I rankHelper I
        4 years ago

        •  this the calculated formula 
        • so I need the manthly impact by subtracting  the calculated month - previous month
        • but the problem in month of Jan. that considering the previous month as December that should be always Zero and the previous month fromula bring December value as normal fromula
        • so I need that if the previous month is December put zero if not apply the fromula

          And this is the previous month fromula