DAX Function

SAMEPERIODLASTYEAR Power BI DAX exercises.

These concepts all use SAMEPERIODLASTYEAR. Work through related PBIX exercises, compare the patterns, and submit numeric answers to save your progress.

View all DAX functions

2Related concepts

Concepts Using SAMEPERIODLASTYEAR

AdvancedCALCULATE DATEADD DATESYTD SAMEPERIODLASTYEAR DATESINPERIOD DIVIDE SUM AVERAGEX SUMMARIZE ADDCOLUMNS

Mastering Advanced Time Intelligence Measures in DAX

Create three complex DAX time intelligence measures: a quarter-over-quarter percentage, a year-to-date percentage against the previous full year, and a three-month moving average of monthly totals.

Open

IntermediateTOTALMTD IF CALCULATE SAMEPERIODLASTYEAR DATEADD ISINSCOPE

Mastering Power BI Time Intelligence: Automatic Date Tables and DAX Functions

Learn to leverage Power BI's automatic date tables to create robust time intelligence measures using DAX functions like TOTALMTD, SAMEPERIODLASTYEAR, DATEADD, and ISINSCOPE for calculating running totals and period-over-period comparisons.

Open