Computer Tutoring Logo
Est. 2002
Menu Button

Power BI - Year to date


How to use DATESYTD to calculate Year to Date?

Year to date in Power BI is one of the most common and useful formulas. This way you can plot cumulative data across a year. In using the DATESYTD function you can also change the year end date so you can tally that up with your financial year. Should you want to get straight to the calculation then fast forward to timestamp 5:37.

This tutorial will also show you how to create a measures table and how to place the measures you create into that table. As it's all too easy to create a measure in the wrong table.

If you are just coming to this Power BI tutorial then I would strongly recommend that you check out the following beforehand:

How to create a date table in Power BI?

How to sort by month in Power BI?

Finally, should you want to follow along with this tutorial then you can download the Power BI Year to Date exercise file.