DATEDIFF

The logistics team at Adventure Works would like to understand the timeline from customers making an order to the delivery being due. We'll be utilizing the DATEDIFF() function to calculate the difference.

Note: Date/Time data in Power BI can change based on your geographical location. All dates in the exercises are based on US geographical location, so have been created and formatted as month/day/year.

If you lost progress, close any open reports and load 3_2_date_diff.pbix from the Exercises folder.

This exercise is part of the course

Introduction to DAX in Power BI

View Course

Hands-on interactive exercise

Turn theory into action with one of our interactive exercises

Start Exercise