Previousyear

[AmalrajRRD1]

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 PREVIOUSYEAR function.

but i want to compare only 2016 (jan to mar) bez then only i can interperate easily alos have 2017 five months dataset.

Is there possible in power bi ?

Thanks

[Eric_Zhang · Accepted solution]

@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]

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

[mattbrice]

Look into SAMEPERIODLASTYEAR function.