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:-

YearMonth CY2018
2019     Jan,19        784003.6     
2020Jan,20796923 
2021Jan,21912686.3 
2018Jan,18754578.3 

I want to return year 2018 CY Value i.e. 754578 in 2018 Column in all rows.
The calculation should be based on latest month for e.g.
MAX(Month),dateadd(month,-3,year)
So, here I want to find from Jan, 2021, to 3 years prior data.

Thanks in advance !

4 Replies

  • 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.

      • 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.