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] ) )
    )
)
P3Tom's avatar
P3Tom
Icon for Helper I rankHelper I
9 years ago

Yes, that is possible in Power BI. Usually when you have a partial current year of data and an entire previous year of data, you also want to have a "check" condition that will not compare last year's data with a month in the current year that has no data.

 

Tom

www.powerpivotpro.com