Forum Discussion

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

Tutorial Requests

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

3 Replies

mattbrice
Solution Sage
9 years ago
Look into SAMEPERIODLASTYEAR function.
P3Tom
Helper 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

Microsoft Employee

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