DAX Function

DATEADD Power BI DAX exercises.

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

View all DAX functions

4Related concepts

Concepts Using DATEADD

BeginnerCALCULATE TOTALQTD DATESQTD DATEADD SUM

Calculating Quarter-to-Date (QTD) and Previous Quarter Sales

Learn to calculate Quarter-to-Date (QTD) sales and sales for the immediately preceding quarter using Power BI's time intelligence functions.

Open

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

BeginnerPREVIOUSMONTH DATEADD

Time Intelligence: Comparing Porpoise Sightings with Previous Periods

Learn to use fundamental DAX time intelligence functions like PREVIOUSMONTH and DATEADD to compare current period data with previous periods, enhancing temporal analysis in Power BI.

Open