Forum Discussion

souvik900766's avatar
souvik900766
Icon for Helper IV rankHelper IV
5 years ago

Return data from specified time interval in all rows in a calculated column

Hi ! My Data:- Year Month  CY 2018 2019      Jan,19         784003.6       2020 Jan,20 796923   2021 Jan,21 912686.3   2018 Jan,18 754578.3   I want to return year...
Tanushree_Kapse's avatar
Tanushree_Kapse
Icon for Impactful Individual rankImpactful Individual
5 years ago

Hi souvik900766 ,

Try using this:
2018data(measure)= CALCULATE(SUM(CY), PARALLELPERIOD(Month, -3, Year))


I believe this is what you want.

souvik900766's avatar
souvik900766
Icon for Helper IV rankHelper IV
5 years ago

Hi Tanushree_Kapse 
Its not working !

A circular dependency was arising so i used the formula this way.

  • Tanushree_Kapse's avatar
    Tanushree_Kapse
    Icon for Impactful Individual rankImpactful Individual
    5 years ago

    Hi souvik900766 ,
    You want to show 2018 data in 2018 column at all times ... irrespective of the months in the Month column?
    If this is what you need, the try using ALL instead of ALLEXCEPT.

    • souvik900766's avatar
      souvik900766
      Icon for Helper IV rankHelper IV
      5 years ago

      Hi Tanushree_Kapse 
      Yes you are right, thats what I want,
      Its not working
      I tried with this options

      Thanks