Forum Discussion

Trying2Excel's avatar
Trying2Excel
Helper I
1 year ago

YoY Growth % Formula

I need help with creating a YoY growth rate for the table below. Below I have also provide my YTD reduction formula.

 

YTD Total Complete Reductions =
VAR _currentYear =
    YEAR ( MAX ( 'Historical Reductions Table'[End of Month] ) )
VAR _currentMonth =
    MONTH ( MAX ( 'Historical Reductions Table'[End of Month] ) )
RETURN
    IF (
        ISINSCOPE ( 'Historical Reductions Table'[End of Month].[Year]),
        CALCULATE (
            SUM ( 'Historical Reductions Table'[Reduction2] ),
            FILTER (
                ALLSELECTED ('Historical Reductions Table'),
                YEAR ( 'Historical Reductions Table'[End of Month]) = _currentYear
                    && MONTH ( 'Historical Reductions Table'[End of Month] ) <= _currentMonth
            )
        ),
        CALCULATE (
            SUM ( 'Historical Reductions Table'[Reduction2] ),
            FILTER (
                ALLSELECTED ('Historical Reductions Table' ),
                MONTH ( 'Historical Reductions Table'[Date] ) <= _currentMonth
            )
        )
    )
 

Anonymous, are you able to help this one as well?