Today’s post is about how you compare Current year and Previous year sales using DAX- SAMEPERIODLASTYEAR function in Power BI.

SAMEPERIODLASTYEAR Returns a table that contains a column of dates shifted one year back in time from the dates in the specified dates column, in the current context.

1. We will start by creating a Date table using the “New Table” option under Modeling.

CALENDAR(<start_date>, <end_date>)

• Set the start date to go back one year before the current date
• Set the end date to TODAY() to display only values up to the current date.

MyDate=CALENDAR(TODAY()-365, TODAY())

2. Ensure that relationships are set in the model and now create a table visual with Sales for 2018 and 2019.

3. To compare the sales for 2018 to 2019 Month by month or day by day, we create a DAX measure using SAMEPERIODLASTYEAR to display last year sales.

SALES LY =

CALCULATE(SUM(Sales[SalesAmount]), SAMEPERIODLASTYEAR(Sales[Date]))

4. Create a table visual that compare sales for 2018 and 2019.

5. Filter by Current year (2019) to see the current and previous year sales side by side.

Happy reporting 🙂