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
Hands-on interactive exercise
Turn theory into action with one of our interactive exercises
