Forum Discussion

AmalrajRRD1's avatar
AmalrajRRD1
Helper 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] ) )
    )
)
Eric_Zhang's avatar
Eric_Zhang
Microsoft Employee
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] ) )
    )
)