Est. 2002
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.
Computer Tutoring takes your privacy seriously and collects essential information such as your name, email, and course preferences to facilitate our services. Additionally, we use cookies to personalise your experience and for Google Ads personalisation, which helps us deliver more relevant advertising to you.
We do not share your personal data, except for specific use-cases like payment processing via PayPal and sending you updates via Mailchimp, if you've opted in for those services. Our site may also use Google Analytics to improve user experience and features links to other websites. Please be aware that Google's Privacy Policy may differ from ours.
We do not store your credit/debit card details. You have the right to access, amend, or request deletion of your personal data by contacting us at info@computertutoring.co.uk.
By using our website, you consent to our use of cookies for the purposes outlined above.
For more details, please read our full Privacy Policy.