Set Analysis with Period as date dimension

[BootCam]

Hi All,

Could you please tell me whats wrong with the calculation below? I am not getting values out of this calculation.

IF([Activation Period]=Max([Status Update Period]),

  sum({<[Type Code]={'A','B','C'}, [Status Code History]={'X','Y'}>}[Volume]),

  IF([Activation Period]<Max([Status Update Period]),

  sum({<[Type Code]={'A','B','C'}, [Status Code History]={'X','Y','Z'}>}[Volume])))

Note: Periods are in this format: "Jan-16" for example

Thanks,

Sk

[neelamsaroha157]

You are welcome