BenchMark Quizzes by MDFT Pro

Calculate Previous Year Sales With DAX In Power BI

You have a Sales table at MDFT Pro. The academy’s finance team wants to compare current sales to the previous year’s performance for trend analysis.

You need to create a measure that calculates sales from the previous year based on a dynamic period. Which two DAX expressions can you use to achieve this?

Choose all correct answers from the options below.

Explanations for each answer:

CALCULATE(SUM(Sales[Sales]), SAMEPERIODLASTYEAR(Calendar[Date])) is correct. SAMEPERIODLASTYEAR returns last year's date for the current filter context, ideal for previous year sales.
CALCULATE(SUM(Sales[Sales]), DATEADD(Calendar[Date], -1, YEAR)) is correct. DATEADD with -1 YEAR returns last year's date for the current filter context, also suitable for previous year sales.
CALCULATE(SUM(Sales[Sales]), PARALLELPERIOD(Calendar[Date], -1, MONTH)) is incorrect. PARALLELPERIOD with -1 MONTH returns previous month, not previous year.
CALCULATE(SUM(Sales[Sales]), DATEADD(Calendar[Date], -1, MONTH)) is incorrect. DATEADD with -1 MONTH returns previous month, not previous year.

Learn more about SAMEPERIODLASTYEAR and DATEADD in Power BI:

Power BI Time Intelligence

Exam Preparation Quiz

Calculate Previous Year Sales With DAX In Power BI