Measure for YoY YTD

Hi egrospe17 

Based on your needs, I have created the following table.

First you can use the following Measure to get the total revenue every year.

Total Revenue = 
VAR _year = [Year]
RETURN
SUMX(FILTER(ALL('Table'),'Table'[Year]=_year),'Table'[Revenue])

Then you can use the following Measure to get the result you want:

YoY % Revenue growth = 
VAR _year = [Year]
VAR _sameperiodtotal = CALCULATE ( [Total Revenue], DATESYTD ( SAMEPERIODLASTYEAR ( 'Table'[Date] ) ) )
VAR _maxmonth = MAXX (
            FILTER ( ALL ( 'Table' ), 'Table'[Year] = _year ),
            MONTH ( 'Table'[Date] )
        )
RETURN
    IF (
         _maxmonth< 12,
        DIVIDE (
            SUMX ( FILTER ( ALL ( 'Table' ), 'Table'[Year] = _year ), 'Table'[Revenue] ),
            SUMX (
                FILTER (
                    ALL ( 'Table' ),
                    'Table'[Year] = _year - 1
                        && MONTH ( 'Table'[Date] )
                            <= _maxmonth
                ),
                'Table'[Revenue]
            )
        )-1,
        DIVIDE (
            [Total Revenue]-_sameperiodtotal,
            _sameperiodtotal
        )
    )

Best Regards,

Jayleny

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