Dax: Calculate YOY growth but ignore the result of very first year DAX

[KKVerma]

Hi Team,

I have a simple table like below: I want to calculate YOY growth which i have calculalated. However, the very first year in the context is 2021 and YOY is (current year minus last year). I want to return YOY sales to be blank. but currently it will return the same amount as sum for the year because there is no data in last year(e.g. 2020). I have tried multple ways to manipulate dax formula but it did not work. Could you please assist?

Formulas:

Current Year = SUM(FctTable[Amount])

Last Year = CALCULATE([Current Year],SAMEPERIODLASTYEAR(DimDate[Date]))

YOY Growth = [Current Year]-[Last Year]

[Anonymous · Accepted solution]

Hi @KKVerma ,

Thanks for the reply from @Greg_Deckler , please allow me to provide another insight: 

You can modify your measure.

YOY Growth = 
VAR _min_date =
    CALCULATE ( MIN ( 'Table 2'[Date] ), ALLSELECTED ( 'Table' ) )
RETURN
    IF (
        MAX ( 'Table 2'[Date] ) = _min_date,
        BLANK (),
        [_Current_Year] - [_Last_Year]
    )

If your Current Period does not refer to this, please clarify in a follow-up reply.

Best Regards,

Clara Gong

If there is any post helps, then please consider Accept it as the solution  to help the other members find it more quickly.

[KKVerma]

This would not return the correct results.  for instance if I have dataset for 10 years. 2021 to 2030. If 2024 does not have any sales. The it will return blank in your calculation whereas, i just want to return blank only for the beginning of the year from the years in current filter context 

[Greg_Deckler]

@KKVerma So like this?

YOY Growth = IF( [Last Year] = BLANK(), BLANK(), [Current Year] - [Last Year] )