Compare selected mont_ year with previous month_year

[nattargekar]

Hi, I have a requirement here:

I have data like below:

I need the output in Power BI as:

There will be a slicer to select year. When I select Year as 18 in the slicer, it should list data only for Year 2018 where the Profit for year 2018 is compared with Profit of 2017 and added into a column. It should be seen like below:

Any Ideas?

[Zubair_Muhammad]

@nattargekar

Try this measurE

Measure  =
VAR Previous_Year =
    CALCULATE (
        SUM ( Table1[Profit] ),
        ALLEXCEPT ( Table1, Table1[Product] ),
        SAMEPERIODLASTYEAR ( Table1[Date] )
    )
RETURN
    SUM ( Table1[Profit] ) - Previous_Year

[nattargekar]

Hi Zubair,

Your code works great for a Measure. Thanks for it. I actually need to create a new Column with these values, so that I can use the column for further calculations. Can you think of DAX to create new column for same requirement ???

[Zubair_Muhammad · Accepted solution]

@nattargekar

May be this Column

Column =
VAR Previous_Year =
    CALCULATE (
        SUM ( Table1[Profit] ),
        ALLEXCEPT ( Table1, Table1[Product] ),
        SAMEPERIODLASTYEAR ( Table1[Date] )
    )
RETURN
    IF ( NOT ( ISBLANK ( Previous_Year ) ), Table1[Profit] - Previous_Year )

[nattargekar]

It's working, Thank you so much @Zubair_Muhammad !!!