Forum Discussion

AmalrajRRD1's avatar
AmalrajRRD1
Icon for Helper II rankHelper II
9 years ago
Solved

Previousyear

Hi all,                I have two year data for the year of 2016 and 2017.In the 2017  have five months dataset.  Now my question is i am comparing for current year vs previous year using PREVIOUSY...
Show and Tell
Tutorial Requests
  • Eric_Zhang's avatar
    Eric_Zhang
    9 years ago

    AmalrajRRD1

    You can try

    previousYTD =
CALCULATE (
    SUM ( 'Table'[value] ),
    FILTER (
        'Table',
        MONTH ( 'Table'[date] )
            <= MONTH ( MAXX ( ALLSELECTED ( 'Table' ), 'Table'[date] ) )
            && YEAR ( 'Table'[date] ) + 1
                = YEAR ( MAXX ( ALLSELECTED ( 'Table' ), 'Table'[date] ) )
    )
)
mattbrice's avatar
mattbrice
Icon for Solution Sage rankSolution Sage
9 years ago

Look into SAMEPERIODLASTYEAR function.