Get startedGet started for free

Use of TOTALYTD()

One of the main uses of time intelligence functions is that they allow you to calculate measures that compare values over periods of time. One such calculation is the year-to-date (YTD) calculation, which returns the result of an expression (for example the running sum), from the beginning of the year until today. In this scenario, you will go back in time and use a time intelligence function to calculate and visualize the year to date sales of the World Wide Importers data.

If you have lost any progress, close any open reports and load 4_1_totalytd.pbix from the Exercises folder on the desktop.

This exercise is part of the course

Intermediate DAX in Power BI

View Course

Hands-on interactive exercise

Turn theory into action with one of our interactive exercises

Start Exercise