Est. 2002
Power BI cumulative totals is the way to go for creating figures to be used on a line chart that accumulate over time. Especially when it comes to dates that are outside of the ordinary Gregorian calendar. For example it may be that your companies financial year starts on the first Sunday in June and runs for 12 - 13 periods. Each period being four seven day weeks.
This Power BI cumulative totals tutorial will show you how to write a DAX formula in Power BI for cumulative totals so that you can write cumulative totals for each of those periods. A subsequent tutorial will show you how to create cumulative totals for the year on a chart.
If you want to follow along? Download the Power BI cumulative totals 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.