{"id":45089,"date":"2024-12-19T19:48:51","date_gmt":"2024-12-19T14:48:51","guid":{"rendered":"https:\/\/chartexpo.com\/blog\/?p=45089"},"modified":"2025-12-17T14:26:29","modified_gmt":"2025-12-17T09:26:29","slug":"power-bi-cumulative-sum","status":"publish","type":"post","link":"https:\/\/chartexpo.com\/blog\/power-bi-cumulative-sum","title":{"rendered":"Power BI Cumulative Sum Steps to Build Insights"},"content":{"rendered":"<p>If you\u2019re a business (or data) analyst, you\u2019ve probably come across the cumulative sum. The cumulative sum is the cumulative total of a series of values like revenue (or sales) over a period of time.<\/p>\n<div style=\"text-align: center;\"><a href=\"https:\/\/chartexpo.com\/blog\/wp-content\/uploads\/2024\/12\/power-bi-cumulative-sum.jpg\"><img decoding=\"async\" class=\"alignnone size-full wp-image-4345\" style=\"max-width: 100%;\" src=\"https:\/\/chartexpo.com\/blog\/wp-content\/uploads\/2024\/12\/power-bi-cumulative-sum.jpg\" alt=\"Power BI Cumulative Sum\" \/><\/a><\/div>\n<div style=\"text-align: center;\"><a href=\"https:\/\/chartexpo.com\/utmAction\/MTYrYmxvZytwYitjZXhwbytQQkk3MDYrU2Fua2V5Kw==\" target=\"_blank\" rel=\"noopener noreferrer nofollow\"><img decoding=\"async\" class=\"alignnone size-full wp-image-4345\" src=\"https:\/\/chartexpo.com\/blog\/wp-content\/uploads\/2023\/04\/CTA-in-power-bi.jpg\" alt=\"\" width=\"205\" height=\"113\" \/><\/a> <a href=\"https:\/\/chartexpo.com\/utmAction\/MTYrYmxvZytncytjZXhwbytDRTcwNis=\" target=\"_blank\" rel=\"noopener noreferrer nofollow\"><img decoding=\"async\" class=\"alignnone size-full wp-image-4345\" src=\"https:\/\/chartexpo.com\/blog\/wp-content\/uploads\/2023\/04\/CTA-in-google-sheets.jpg\" alt=\"\" width=\"205\" height=\"113\" \/><\/a> <a href=\"https:\/\/chartexpo.com\/utmAction\/MTYrYmxvZyt4bCtjZXhwbytDRTcwNis=\" target=\"_blank\" rel=\"noopener noreferrer nofollow\"><img decoding=\"async\" class=\"alignnone size-full wp-image-4345\" src=\"https:\/\/chartexpo.com\/blog\/wp-content\/uploads\/2023\/04\/CTA-in-microsoft-excel.jpg\" alt=\"\" width=\"205\" height=\"113\" \/><\/a><\/div>\n<p>Cumulative sums play a vital role in a variety of contexts like financial reporting and trend analysis. Using cumulative sum, you can easily track progress and identify patterns in your data.<\/p>\n<p>This guide will help fully understand what the Power BI cumulative sum is, why you should use the cumulative sum in Power BI, and the importance of using Power BI running total.<\/p>\n<h3>Table of Contents:<\/h3>\n<ol>\n<li><a href=\"#what-is-a-power-bi-cumulative-sum\">What is a Power BI Cumulative Sum?<\/a><\/li>\n<li><a href=\"#why-use-cumulative-sum-in-power-bi\">Why Use Cumulative Sum in Power BI?<\/a><\/li>\n<li><a href=\"#how-do-you-calculate-the-running-total-in-power-bi\">How Do You Calculate the Running Total in Power BI?<\/a><\/li>\n<li><a href=\"#how-to-evaluate-and-visualize-cumulative-sum-in-power-bi\">How to Evaluate and Visualize Cumulative Sum in Power BI?<\/a><\/li>\n<li><a href=\"#what-are-the-tips-and-tricks-for-using-power-bi-cumulative-sum\">What are the Tips and Tricks for Using Power BI Cumulative Sum?<\/a><\/li>\n<li><a href=\"#wrap-up\">Wrap Up<\/a><\/li>\n<\/ol>\n<p>First&#8230;<\/p>\n<h2 id=\"what-is-a-power-bi-cumulative-sum\">What is a Power BI Cumulative Sum?<\/h2>\n<p>Power BI cumulative sum is the running total of a measure across a specified order, and it\u2019s based on the date or a specific column. It reflects the sum of values accumulated over time (or within a defined grouping).<\/p>\n<p>DAX is used to create a cumulative sum in Power BI. You&#8217;ll have to take advantage of functions like <a href=\"https:\/\/chartexpo.com\/blog\/calculate-function-in-power-bi\" target=\"_blank\" rel=\"noopener\">CALCULATE<\/a>, SUM, and FILTER. For instance:<\/p>\n<p>CumulativeSales = CALCULATE(SUM(\u2019Sales\u2019[Amount]),FILTER(ALL(\u2019Calendar\u2019),\u2019Calendar\u2019[Date] \u2190 MAX(\u2019Calendar\u2019[Date]))).<\/p>\n<p>Here:<\/p>\n<ul>\n<li>SUM(&#8216;Sales'[Amount]) calculates the sum of the sales amount.<\/li>\n<li>FILTER(ALL(\u2019Calendar\u2019), \u2018Calendar\u2019[Date] \u2190 MAX(\u2019Calendar\u2019[Date])) filters the dates up to the current date.<\/li>\n<li>CALCULATE applies the filter context, and the result is the cumulative sum.<\/li>\n<\/ul>\n<h2 id=\"why-use-cumulative-sum-in-power-bi\">Why Use Cumulative Sum in Power BI?<\/h2>\n<p>Using a cumulative sum (also known as a running total) in Power BI provides a powerful way to analyze and visualize data over time or across categories. Here are some key reasons to use it:<\/p>\n<ul>\n<li><strong>Trend Analysis:<\/strong> Cumulative sums help visualize the overall trend of a measure over time. It plays a vital role in identifying patterns, growth, or decline in the data.<\/li>\n<li><strong>Progress Tracking:<\/strong> Cumulative sums are often used to track progress towards a target or goal. It\u2019s common in scenarios where you want to monitor how a particular measure accumulates over time.<\/li>\n<li><strong>Comparative Analysis: <\/strong>The Power BI cumulative sum by date helps users to compare the total accumulated values across multiple periods. This will, in turn, help the user identify trends (or anomalies) in a report such as the <a href=\"https:\/\/chartexpo.com\/blog\/cost-of-living-comparison-by-city\" target=\"_blank\" rel=\"noopener\">cost of living comparison by city<\/a>.<\/li>\n<li><strong>Seasonal Patterns:<\/strong> When working with data with seasonal variations, the cumulative sum highlights how values accumulate during specific seasons and also reveals annual trends or cycles.<\/li>\n<li><strong>Customer Lifetime Value (CLV):<\/strong> In cases related to <a href=\"https:\/\/chartexpo.com\/blog\/customer-lifetime-value\" target=\"_blank\" rel=\"noopener\">customer lifetime value<\/a> (CLV) analysis, cumulative sums are used to calculate and analyze the cumulative spending (or engagement) of customers over their lifetime, providing insights into <a href=\"https:\/\/chartexpo.com\/blog\/customer-behavior-analytics\" target=\"_blank\" rel=\"noopener\">customer behavior<\/a> and long-term value.<\/li>\n<\/ul>\n<h2 id=\"how-do-you-calculate-the-running-total-in-power-bi\">How Do You Calculate the Running Total in Power BI?<\/h2>\n<p>To calculate the running total (or cumulative sum) in Power BI, you typically use DAX (Data Analysis Expressions) in either a calculated column or a measure. Here\u2019s a step-by-step guide:<\/p>\n<ol>\n<li>Launch the Power BI Desktop, and open the Power BI file (or connect to the data source).<\/li>\n<li>Load your data into Power BI.<\/li>\n<li>Navigate to the Fields pane on the right. Right-click on the table you want to create the running total.<\/li>\n<li>Choose \u201cNew Measure\u201d from the context menu.<\/li>\n<li>In the formula bar, use the SUM function (and appropriate filtering conditions) to enter the DAX formula. Here\u2019s the basic example for a running total of the \u201cAmount\u201d column in the \u201cSales\u201d table:<\/li>\n<\/ol>\n<p>CumulativeSales= CALCULATE(SUM(\u2019Sales\u2019[Amount]),FILTER(ALL(\u2019Calendar\u2019),\u2019Calendar\u2019[Date] \u2190 MAX(\u2019Calendar\u2019[Date])))<\/p>\n<p>The formula calculates the running total of the \u201cAmount\u201d column. It sums the values where the date is less than (or equal) to the maximum date in the current context.<\/p>\n<ol>\n<li>After entering the formula, press \u201cEnter\u201d to apply the formula to the new measure.<\/li>\n<li>The new measure (like \u201cCumulativeSales\u201d) will appear in the Fields pane. Drag and drop it into the report (or visualization) to see the running total in action.<\/li>\n<\/ol>\n<h2 id=\"how-to-evaluate-and-visualize-cumulative-sum-in-power-bi\">How to Evaluate and Visualize Cumulative Sum in Power BI?<\/h2>\n<p data-pm-slice=\"0 0 []\">Evaluating a cumulative sum in Power BI involves creating a DAX measure using the CALCULATE and FILTER functions. You can then visualize the results with a <a href=\"https:\/\/chartexpo.com\/charts\/sankey-diagram\" target=\"_blank\" rel=\"noopener\">Sankey Diagram make<\/a>r to show how values flow and accumulate over time, enhancing data analysis and decision-making.<\/p>\n<p><strong>Example:<\/strong><\/p>\n<p>If you want the CUM Sales for the data below:<\/p>\n<div style=\"text-align: center;\"><a href=\"https:\/\/chartexpo.com\/blog\/wp-content\/uploads\/2024\/12\/cum-sales-for-data-for-learning-power-bi-cumulative-sum.jpg\"><img decoding=\"async\" class=\"alignnone size-full wp-image-4345\" src=\"https:\/\/chartexpo.com\/blog\/wp-content\/uploads\/2024\/12\/cum-sales-for-data-for-learning-power-bi-cumulative-sum.jpg\" alt=\"CUM Sales for Data for Learning Power BI Cumulative Sum\" width=\"405\" \/><\/a><\/div>\n<p>You&#8217;ll have to select New Quick Measure. After that, navigate to Totals \u2014&gt; Running total to create this:<\/p>\n<div style=\"text-align: center;\"><a href=\"https:\/\/chartexpo.com\/blog\/wp-content\/uploads\/2024\/12\/runninf-total-to-create-this-for-learning-power-bi-cumulative-sum.jpg\"><img decoding=\"async\" class=\"alignnone size-full wp-image-4345\" src=\"https:\/\/chartexpo.com\/blog\/wp-content\/uploads\/2024\/12\/runninf-total-to-create-this-for-learning-power-bi-cumulative-sum.jpg\" alt=\"Runninf Total to Create This for Learning Power BI Cumulative Sum\" width=\"602\" \/><\/a><\/div>\n<p>Returns:<\/p>\n<div style=\"text-align: center;\"><a href=\"https:\/\/chartexpo.com\/blog\/wp-content\/uploads\/2024\/12\/return-for-learning-power-bi-cumulative-sum.jpg\"><img decoding=\"async\" class=\"alignnone size-full wp-image-4345\" src=\"https:\/\/chartexpo.com\/blog\/wp-content\/uploads\/2024\/12\/return-for-learning-power-bi-cumulative-sum.jpg\" alt=\"Return for Learning Power BI Cumulative Sum\" width=\"239\" \/><\/a><\/div>\n<h3>Stage 1: Log into Power BI, enter your email, and click \u201cSubmit.\u201d<\/h3>\n<ul>\n<li>Log in to Power BI.<\/li>\n<li>Enter your email address and click the \u201c<strong>Submit<\/strong>\u201d button.<\/li>\n<\/ul>\n<div style=\"text-align: center;\"><a href=\"https:\/\/chartexpo.com\/blog\/wp-content\/uploads\/2023\/05\/enter-email-to-login-to-power-bi.jpg\"><img decoding=\"async\" class=\"alignnone size full wp image 4345\" src=\"https:\/\/chartexpo.com\/blog\/wp-content\/uploads\/2023\/05\/enter-email-to-login-to-power-bi.jpg\" alt=\"Enter email to login to Power BI\" width=\"650\" \/><\/a><\/div>\n<ul>\n<li>You are redirected to your Microsoft account.<\/li>\n<li>Enter your password and click \u201c<strong>Sign in<\/strong>\u201c.<\/li>\n<\/ul>\n<div style=\"text-align: center;\"><a href=\"https:\/\/chartexpo.com\/blog\/wp-content\/uploads\/2023\/05\/enter-password-to-login-to-power-bi.jpg\"><img decoding=\"async\" class=\"alignnone size full wp image 4345\" src=\"https:\/\/chartexpo.com\/blog\/wp-content\/uploads\/2023\/05\/enter-password-to-login-to-power-bi.jpg\" alt=\"Enter Password to login to Power BI\" width=\"363\" \/><\/a><\/div>\n<ul>\n<li>You can choose whether to stay signed in.<\/li>\n<\/ul>\n<div style=\"text-align: center;\"><a href=\"https:\/\/chartexpo.com\/blog\/wp-content\/uploads\/2023\/05\/click-on-stay-signed-in.jpg\"><img decoding=\"async\" class=\"alignnone size full wp image 4345\" src=\"https:\/\/chartexpo.com\/blog\/wp-content\/uploads\/2023\/05\/click-on-stay-signed-in.jpg\" alt=\"Click on stay signed in\" width=\"392\" \/><\/a><\/div>\n<ul>\n<li>Once done, the Power BI home screen will open.<\/li>\n<\/ul>\n<h3>Stage 2: Create a Data Set and Select the Data Set to Use in the Sankey Chart<\/h3>\n<ul>\n<li>Go to the left-side menu and click the \u201c<strong>Create<\/strong>\u201d button.<\/li>\n<li>Select \u201c<strong>Paste or manually enter data<\/strong>\u201c.<\/li>\n<\/ul>\n<div style=\"text-align: center;\"><a href=\"https:\/\/chartexpo.com\/blog\/wp-content\/uploads\/2024\/02\/select-paste-or-manually-enter-data-in-power-bi-ce487.jpg\"><img decoding=\"async\" class=\"alignnone size full wp image 4345\" src=\"https:\/\/chartexpo.com\/blog\/wp-content\/uploads\/2024\/02\/select-paste-or-manually-enter-data-in-power-bi-ce487.jpg\" alt=\"select Paste or manually enter data in Power BI ce487\" width=\"650\" \/><\/a><\/div>\n<div style=\"text-align: center;\"><a href=\"https:\/\/chartexpo.com\/utmAction\/MTYrYmxvZytwYitjZXhwbytQQkk3MDYrU2Fua2V5Kw==\" target=\"_blank\" rel=\"noopener noreferrer nofollow\"><img decoding=\"async\" class=\"alignnone size-full wp-image-4345\" src=\"https:\/\/chartexpo.com\/blog\/wp-content\/uploads\/2023\/04\/CTA-in-power-bi.jpg\" alt=\"\" width=\"205\" height=\"113\" \/><\/a> <a href=\"https:\/\/chartexpo.com\/utmAction\/MTYrYmxvZytncytjZXhwbytDRTcwNis=\" target=\"_blank\" rel=\"noopener noreferrer nofollow\"><img decoding=\"async\" class=\"alignnone size-full wp-image-4345\" src=\"https:\/\/chartexpo.com\/blog\/wp-content\/uploads\/2023\/04\/CTA-in-google-sheets.jpg\" alt=\"\" width=\"205\" height=\"113\" \/><\/a> <a href=\"https:\/\/chartexpo.com\/utmAction\/MTYrYmxvZyt4bCtjZXhwbytDRTcwNis=\" target=\"_blank\" rel=\"noopener noreferrer nofollow\"><img decoding=\"async\" class=\"alignnone size-full wp-image-4345\" src=\"https:\/\/chartexpo.com\/blog\/wp-content\/uploads\/2023\/04\/CTA-in-microsoft-excel.jpg\" alt=\"\" width=\"205\" height=\"113\" \/><\/a><\/div>\n<ul>\n<li>We&#8217;ll use the <a href=\"https:\/\/chartexpo.com\/blog\/sample-data-for-power-bi\" target=\"_blank\" rel=\"noopener noreferrer\">sample data<\/a> below for this example.<\/li>\n<\/ul>\n<table class=\"static\" style=\"table-layout: fixed; overflow-x: auto; border: 1px; font-size: 17px;\">\n<tbody>\n<tr>\n<td><strong>Total Cost<\/strong><\/td>\n<td><strong>Company Type<\/strong><\/td>\n<td><strong>Company Name<\/strong><\/td>\n<td><strong>Expertise Categories<\/strong><\/td>\n<td><strong>Expertise<\/strong><\/td>\n<td><strong>Cost<\/strong><\/td>\n<\/tr>\n<tr>\n<td>Total Cost<\/td>\n<td>Subcontractor<\/td>\n<td>Skyline Contractors<\/td>\n<td>Mechanical Installation<\/td>\n<td>Plumbing &amp; Heating<\/td>\n<td>15456<\/td>\n<\/tr>\n<tr>\n<td>Total Cost<\/td>\n<td>Subcontractor<\/td>\n<td>Skyline Contractors<\/td>\n<td>Mechanical Installation<\/td>\n<td>Mechanical Work<\/td>\n<td>10159<\/td>\n<\/tr>\n<tr>\n<td>Total Cost<\/td>\n<td>Subcontractor<\/td>\n<td>Onyx General Contractors<\/td>\n<td>Mechanical Installation<\/td>\n<td>Plumbing &amp; Heating<\/td>\n<td>18045<\/td>\n<\/tr>\n<tr>\n<td>Total Cost<\/td>\n<td>Subcontractor<\/td>\n<td>Onyx General Contractors<\/td>\n<td>Mechanical Installation<\/td>\n<td>Mechanical Work<\/td>\n<td>12695<\/td>\n<\/tr>\n<tr>\n<td>Total Cost<\/td>\n<td>Subcontractor<\/td>\n<td>Living Well Remodeling<\/td>\n<td>Mechanical Installation<\/td>\n<td>Plumbing &amp; Heating<\/td>\n<td>14589<\/td>\n<\/tr>\n<tr>\n<td>Total Cost<\/td>\n<td>Subcontractor<\/td>\n<td>Living Well Remodeling<\/td>\n<td>Mechanical Installation<\/td>\n<td>Welding<\/td>\n<td>11456<\/td>\n<\/tr>\n<tr>\n<td>Total Cost<\/td>\n<td>Supplier<\/td>\n<td>Power-up Builders<\/td>\n<td>Raw Material<\/td>\n<td>Cement<\/td>\n<td>20561<\/td>\n<\/tr>\n<tr>\n<td>Total Cost<\/td>\n<td>Supplier<\/td>\n<td>Power-up Builders<\/td>\n<td>Raw Material<\/td>\n<td>Steel<\/td>\n<td>32456<\/td>\n<\/tr>\n<tr>\n<td>Total Cost<\/td>\n<td>Supplier<\/td>\n<td>Five-star Construction<\/td>\n<td>Raw Material<\/td>\n<td>Bricks<\/td>\n<td>10253<\/td>\n<\/tr>\n<tr>\n<td>Total Cost<\/td>\n<td>Supplier<\/td>\n<td>Five-star Construction<\/td>\n<td>Raw Material<\/td>\n<td>Timber<\/td>\n<td>9000<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<ul>\n<li>Paste the data table above into the \u201cPower Query\u201d window. After that, select the \u201cCreate a dataset only\u201d option.<\/li>\n<\/ul>\n<div style=\"text-align: center;\"><a href=\"https:\/\/chartexpo.com\/blog\/wp-content\/uploads\/2024\/12\/select-create-a-dataset-only-after-learning-power-bi-cumulative-sum.jpg\"><img decoding=\"async\" class=\"alignnone size-full wp-image-4345\" src=\"https:\/\/chartexpo.com\/blog\/wp-content\/uploads\/2024\/12\/select-create-a-dataset-only-after-learning-power-bi-cumulative-sum.jpg\" alt=\"Select Create a Dataset Only After Learning Power BI Cumulative Sum\" width=\"650\" \/><\/a><\/div>\n<ul>\n<li>Navigate to the left-side menu, and click on the &#8220;Data Hub&#8221; option. Power BI will populate the data set list. If no data set has been created, you&#8217;ll get an error message.<\/li>\n<\/ul>\n<div style=\"text-align: center;\"><a href=\"https:\/\/chartexpo.com\/blog\/wp-content\/uploads\/2024\/12\/click-on-data-hub-after-learning-power-bi-cumulative-sum.jpg\"><img decoding=\"async\" class=\"alignnone size-full wp-image-4345\" src=\"https:\/\/chartexpo.com\/blog\/wp-content\/uploads\/2024\/12\/click-on-data-hub-after-learning-power-bi-cumulative-sum.jpg\" alt=\"Click on Data Hub After Learning Power BI Cumulative Sum\" width=\"650\" \/><\/a><\/div>\n<ul>\n<li>Choose the data set you want to use in the Sankey diagram. After that, you\u2019ll see Power BI populate the screen as shown below.<\/li>\n<\/ul>\n<div style=\"text-align: center;\"><a href=\"https:\/\/chartexpo.com\/blog\/wp-content\/uploads\/2024\/12\/choose-data-set-you-want-to-use-after-learning-power-bi-cumulative-sum.jpg\"><img decoding=\"async\" class=\"alignnone size-full wp-image-4345\" src=\"https:\/\/chartexpo.com\/blog\/wp-content\/uploads\/2024\/12\/choose-data-set-you-want-to-use-after-learning-power-bi-cumulative-sum.jpg\" alt=\"Choose Data Set You Want to Use After Learning Power BI Cumulative Sum\" width=\"650\" \/><\/a><\/div>\n<ul>\n<li>Click on the \u201cCreate a report\u201d dropdown. Next, select \u201cStart from scratch.\u201d<\/li>\n<\/ul>\n<div style=\"text-align: center;\"><a href=\"https:\/\/chartexpo.com\/blog\/wp-content\/uploads\/2024\/12\/click-on-create-a-report-after-learning-power-bi-cumulative-sum.jpg\"><img decoding=\"async\" class=\"alignnone size-full wp-image-4345\" src=\"https:\/\/chartexpo.com\/blog\/wp-content\/uploads\/2024\/12\/click-on-create-a-report-after-learning-power-bi-cumulative-sum.jpg\" alt=\"Click on Create a Report After Learning Power BI Cumulative Sum\" width=\"650\" \/><\/a><\/div>\n<ul>\n<li>A Report Canvas, similar to the one below will appear on your screen.<\/li>\n<\/ul>\n<div style=\"text-align: center;\"><a href=\"https:\/\/chartexpo.com\/blog\/wp-content\/uploads\/2024\/12\/report-canvas-will-appear-after-learning-power-bi-cumulative-sum.jpg\"><img decoding=\"async\" class=\"alignnone size-full wp-image-4345\" src=\"https:\/\/chartexpo.com\/blog\/wp-content\/uploads\/2024\/12\/report-canvas-will-appear-after-learning-power-bi-cumulative-sum.jpg\" alt=\"Report Canvas will Appear After Learning Power BI Cumulative Sum\" width=\"650\" \/><\/a><\/div>\n<h3>Stage 3: Add the Power BI Sankey Diagram Extension by ChartExpo<\/h3>\n<ul>\n<li>To create the Sankey Diagram, you\u2019ll have to use an add-in or the Power BI visual from AppSource. Navigate to the right side of the Power BI dashboard, and open the Power BI Visualizations panel. Next, click the ellipsis symbol (\u2026) to import the Power BI Sankey Diagram extension by ChartExpo.<\/li>\n<\/ul>\n<div style=\"text-align: center;\"><a href=\"https:\/\/chartexpo.com\/blog\/wp-content\/uploads\/2024\/12\/click-ellipsis-symbol-after-learning-power-bi-cumulative-sum.jpg\"><img decoding=\"async\" class=\"alignnone size-full wp-image-4345\" src=\"https:\/\/chartexpo.com\/blog\/wp-content\/uploads\/2024\/12\/click-ellipsis-symbol-after-learning-power-bi-cumulative-sum.jpg\" alt=\"Click Ellipsis Symbol After Learning Power BI Cumulative Sum\" width=\"650\" \/><\/a><\/div>\n<ul>\n<li>When the menu opens, select the \u201cGet more visuals\u201d option.<\/li>\n<\/ul>\n<div style=\"text-align: center;\"><a href=\"https:\/\/chartexpo.com\/blog\/wp-content\/uploads\/2024\/12\/select-get-more-visuals-after-learning-power-bi-cumulative-sum.jpg\"><img decoding=\"async\" class=\"alignnone size-full wp-image-4345\" src=\"https:\/\/chartexpo.com\/blog\/wp-content\/uploads\/2024\/12\/select-get-more-visuals-after-learning-power-bi-cumulative-sum.jpg\" alt=\"Select Get more VIsuals After Learning Power BI Cumulative Sum\" width=\"650\" \/><\/a><\/div>\n<ul>\n<li>In the following window that opens, enter \u201cSankey Diagram for Power BI by ChartExpo\u201d in the highlighted search box. You\u2019ll see the \u201cSankey Diagram for Power BI by ChartExpo.\u201d<\/li>\n<\/ul>\n<div style=\"text-align: center;\"><a href=\"https:\/\/chartexpo.com\/blog\/wp-content\/uploads\/2024\/12\/see-sankey-diagram-after-learning-power-bi-cumulative-sum.jpg\"><img decoding=\"async\" class=\"alignnone size-full wp-image-4345\" src=\"https:\/\/chartexpo.com\/blog\/wp-content\/uploads\/2024\/12\/see-sankey-diagram-after-learning-power-bi-cumulative-sum.jpg\" alt=\"See Sankey Diagram After Learning Power BI Cumulative Sum\" width=\"650\" \/><\/a><\/div>\n<ul>\n<li>Click the highlighted \u201cAdd\u201d button.<\/li>\n<\/ul>\n<div style=\"text-align: center;\"><a href=\"https:\/\/chartexpo.com\/blog\/wp-content\/uploads\/2024\/12\/click-add-button-after-learning-power-bi-cumulative-sum.jpg\"><img decoding=\"async\" class=\"alignnone size-full wp-image-4345\" src=\"https:\/\/chartexpo.com\/blog\/wp-content\/uploads\/2024\/12\/click-add-button-after-learning-power-bi-cumulative-sum.jpg\" alt=\"Click Add Button After Learning Power BI Cumulative Sum\" width=\"650\" \/><\/a><\/div>\n<ul>\n<li>Power BI will add the \u201cSankey Diagram for Power BI by ChartExpo\u201d icon in the visualization panel.<\/li>\n<\/ul>\n<div style=\"text-align: center;\"><a href=\"https:\/\/chartexpo.com\/blog\/wp-content\/uploads\/2024\/12\/sankey-diagram-icon-in-visualization-panel-after-learning-power-bi-cumulative-sum.jpg\"><img decoding=\"async\" class=\"alignnone size-full wp-image-4345\" src=\"https:\/\/chartexpo.com\/blog\/wp-content\/uploads\/2024\/12\/sankey-diagram-icon-in-visualization-panel-after-learning-power-bi-cumulative-sum.jpg\" alt=\"Sankey Diagram Icon in Visualization Panel After Learning Power BI Cumulative Sum\" width=\"239\" \/><\/a><\/div>\n<h3>Stage 4: Draw a Sankey Diagram with ChartExpo\u2019s Power BI extension<\/h3>\n<ul>\n<li>To do that, select the \u201cSankey Diagram for Power BI by ChartExpo\u201d icon in the visualization panel. After that, a window similar to the one below will open in the report section of your dashboard.<\/li>\n<\/ul>\n<div style=\"text-align: center;\"><a href=\"https:\/\/chartexpo.com\/blog\/wp-content\/uploads\/2024\/12\/select-sankey-diagram-icon-in-visualization-panel-after-learning-power-bi-cumulative-sum.jpg\"><img decoding=\"async\" class=\"alignnone size-full wp-image-4345\" src=\"https:\/\/chartexpo.com\/blog\/wp-content\/uploads\/2024\/12\/select-sankey-diagram-icon-in-visualization-panel-after-learning-power-bi-cumulative-sum.jpg\" alt=\"Select Sankey Diagram Icon in Visualization Panel After Learning Power BI Cumulative Sum\" width=\"375\" \/><\/a><\/div>\n<ul>\n<li>You have the option to resize the visual. Moving on, navigate to the right side of the Power BI dashboard, and look out for \u201cFields\u201d next to \u201cVisualizations.\u201d<\/li>\n<\/ul>\n<div style=\"text-align: center;\"><a href=\"https:\/\/chartexpo.com\/blog\/wp-content\/uploads\/2024\/12\/look-out-for-fields-next-to-visualizations-after-learning-power-bi-cumulative-sum.jpg\"><img decoding=\"async\" class=\"alignnone size-full wp-image-4345\" src=\"https:\/\/chartexpo.com\/blog\/wp-content\/uploads\/2024\/12\/look-out-for-fields-next-to-visualizations-after-learning-power-bi-cumulative-sum.jpg\" alt=\"Look Out for Fields Next to Visualizations After Learning Power BI Cumulative Sum\" width=\"459\" \/><\/a><\/div>\n<ul>\n<li>Follow the sequence below when selecting the fields to use in the Sankey chart.\n<ul>\n<li>Total Cost<\/li>\n<li>Company Type<\/li>\n<li>Company Name<\/li>\n<li>Expertise Categories<\/li>\n<li>Expertise<\/li>\n<li>Cost<\/li>\n<\/ul>\n<\/li>\n<\/ul>\n<div style=\"text-align: center;\"><a href=\"https:\/\/chartexpo.com\/blog\/wp-content\/uploads\/2024\/12\/select-fields-to-use-in-sankey-chart-after-learning-power-bi-cumulative-sum.jpg\"><img decoding=\"async\" class=\"alignnone size-full wp-image-4345\" src=\"https:\/\/chartexpo.com\/blog\/wp-content\/uploads\/2024\/12\/select-fields-to-use-in-sankey-chart-after-learning-power-bi-cumulative-sum.jpg\" alt=\"Select Fields to Use in Sankey Chart After Learning Power BI Cumulative Sum\" width=\"222\" \/><\/a><\/div>\n<ul>\n<li>You\u2019ll have to provide your email address or ChartExpo license key.<\/li>\n<\/ul>\n<div style=\"text-align: center;\"><a href=\"https:\/\/chartexpo.com\/blog\/wp-content\/uploads\/2024\/12\/provide-email-address-after-learning-power-bi-cumulative-sum.jpg\"><img decoding=\"async\" class=\"alignnone size-full wp-image-4345\" src=\"https:\/\/chartexpo.com\/blog\/wp-content\/uploads\/2024\/12\/provide-email-address-after-learning-power-bi-cumulative-sum.jpg\" alt=\"Provide Email Address After Learning Power BI Cumulative Sum\" width=\"650\" \/><\/a><\/div>\n<h3>Stage 5: Activate the ChartExpo Trial or Apply a Subscription Key<\/h3>\n<ul>\n<li>Select the ChartExpo visual. You\u2019ll see three icons below \u201cBuild Visual\u201d in the Visualizations panel.<\/li>\n<\/ul>\n<div style=\"text-align: center;\"><a href=\"https:\/\/chartexpo.com\/blog\/wp-content\/uploads\/2024\/12\/see-three-icons-below-build-visual-after-learning-power-bi-cumulative-sum.jpg\"><img decoding=\"async\" class=\"alignnone size-full wp-image-4345\" src=\"https:\/\/chartexpo.com\/blog\/wp-content\/uploads\/2024\/12\/see-three-icons-below-build-visual-after-learning-power-bi-cumulative-sum.jpg\" alt=\"See Three Icons Below Build Visual After Learning Power BI Cumulative Sum\" width=\"265\" \/><\/a><\/div>\n<ul>\n<li>Select the middle icon, &#8220;Format visual.&#8221; After that, the visual properties will be populated.<\/li>\n<\/ul>\n<div style=\"text-align: center;\"><a href=\"https:\/\/chartexpo.com\/blog\/wp-content\/uploads\/2024\/12\/select-middle-icon-format-visual-after-learning-power-bi-cumulative-sum.jpg\"><img decoding=\"async\" class=\"alignnone size-full wp-image-4345\" src=\"https:\/\/chartexpo.com\/blog\/wp-content\/uploads\/2024\/12\/select-middle-icon-format-visual-after-learning-power-bi-cumulative-sum.jpg\" alt=\"Select Middle Icon Format Visual After Learning Power BI Cumulative Sum\" width=\"246\" \/><\/a><\/div>\n<ul>\n<li>As a new user, you\u2019ll have to enter your email address in the textbox under the \u201cTrial Mode\u201d section. The license key will be sent to the email upon subscription. Toggle \u201cEnable Trial\u2019 to activate the 7-day trial.<\/li>\n<\/ul>\n<div style=\"text-align: center;\"><a href=\"https:\/\/chartexpo.com\/blog\/wp-content\/uploads\/2024\/12\/enable-trial-to-activate-7-day-trial-after-learning-power-bi-cumulative-sum.jpg\"><img decoding=\"async\" class=\"alignnone size-full wp-image-4345\" src=\"https:\/\/chartexpo.com\/blog\/wp-content\/uploads\/2024\/12\/enable-trial-to-activate-7-day-trial-after-learning-power-bi-cumulative-sum.jpg\" alt=\"Enable Trial to Activate 7-Day Trial After Learning Power BI Cumulative Sum\" width=\"233\" \/><\/a><\/div>\n<ul>\n<li>The Sankey Diagram you create under the 7-day trial comes with the ChartExpo watermark.<\/li>\n<\/ul>\n<div style=\"text-align: center;\"><a href=\"https:\/\/chartexpo.com\/blog\/wp-content\/uploads\/2024\/12\/see-sankey-diagram-with-chartexpo-watermark-after-learning-power-bi-cumulative-sum.jpg\"><img decoding=\"async\" class=\"alignnone size-full wp-image-4345\" src=\"https:\/\/chartexpo.com\/blog\/wp-content\/uploads\/2024\/12\/see-sankey-diagram-with-chartexpo-watermark-after-learning-power-bi-cumulative-sum.jpg\" alt=\"See Sankey Diagram with ChartExpo Watermark After Learning Power BI Cumulative Sum\" width=\"650\" \/><\/a><\/div>\n<ul>\n<li>Enter the license key in the \u201cChartExpo License Key\u201d textbox in the \u201cLicense Settings\u201d section. After that, slide the toggle switch next to \u201cEnable License\u201d to \u201cOn.\u201d<\/li>\n<\/ul>\n<div style=\"text-align: center;\"><a href=\"https:\/\/chartexpo.com\/blog\/wp-content\/uploads\/2024\/12\/enter-license-key-after-learning-power-bi-cumulative-sum.jpg\"><img decoding=\"async\" class=\"alignnone size-full wp-image-4345\" src=\"https:\/\/chartexpo.com\/blog\/wp-content\/uploads\/2024\/12\/enter-license-key-after-learning-power-bi-cumulative-sum.jpg\" alt=\"Enter License Key After Learning Power BI Cumulative Sum\" width=\"235\" \/><\/a><\/div>\n<ul>\n<li>The Sankey diagram should be ready. It does not come with a watermark.<\/li>\n<\/ul>\n<div style=\"text-align: center;\"><a href=\"https:\/\/chartexpo.com\/blog\/wp-content\/uploads\/2024\/12\/see-sankey-diagram-without-watermark-after-learning-power-bi-cumulative-sum.jpg\"><img decoding=\"async\" class=\"alignnone size-full wp-image-4345\" src=\"https:\/\/chartexpo.com\/blog\/wp-content\/uploads\/2024\/12\/see-sankey-diagram-without-watermark-after-learning-power-bi-cumulative-sum.jpg\" alt=\"See Sankey Diagram without Watermark After Learning Power BI Cumulative Sum\" width=\"650\" \/><\/a><\/div>\n<ul>\n<li>To add a Prefix (like the $ sign) with the numeric values in the chart, you\u2019ll have to expand the \u201cStats\u201d properties. After that, include the Prefix value.<\/li>\n<\/ul>\n<div style=\"text-align: center;\"><a href=\"https:\/\/chartexpo.com\/blog\/wp-content\/uploads\/2024\/12\/add-prefix-with-numeric-values-after-learning-power-bi-cumulative-sum.jpg\"><img decoding=\"async\" class=\"alignnone size-full wp-image-4345\" src=\"https:\/\/chartexpo.com\/blog\/wp-content\/uploads\/2024\/12\/add-prefix-with-numeric-values-after-learning-power-bi-cumulative-sum.jpg\" alt=\"Add Prefix with Numeric Values After Learning Power BI Cumulative Sum\" width=\"650\" \/><\/a><\/div>\n<ul>\n<li>To add colors to each node, expand the \u201cLevel Colors\u201d properties and select the colors.<\/li>\n<\/ul>\n<div style=\"text-align: center;\"><a href=\"https:\/\/chartexpo.com\/blog\/wp-content\/uploads\/2024\/12\/add-colors-to-each-node-after-learning-power-bi-cumulative-sum.jpg\"><img decoding=\"async\" class=\"alignnone size-full wp-image-4345\" src=\"https:\/\/chartexpo.com\/blog\/wp-content\/uploads\/2024\/12\/add-colors-to-each-node-after-learning-power-bi-cumulative-sum.jpg\" alt=\"Add Colors to Each Node After Learning Power BI Cumulative Sum\" width=\"232\" \/><\/a><\/div>\n<ul>\n<li>The changes will be saved automatically.<\/li>\n<\/ul>\n<div style=\"text-align: center;\"><a href=\"https:\/\/chartexpo.com\/blog\/wp-content\/uploads\/2024\/12\/final-power-bi-cumulative-sum.jpg\"><img decoding=\"async\" class=\"alignnone size-full wp-image-4345\" src=\"https:\/\/chartexpo.com\/blog\/wp-content\/uploads\/2024\/12\/final-power-bi-cumulative-sum.jpg\" alt=\"Final Power BI Cumulative Sum\" width=\"650\" \/><\/a><\/div>\n<div style=\"text-align: center;\"><a href=\"https:\/\/chartexpo.com\/utmAction\/MTYrYmxvZytwYitjZXhwbytQQkk3MDYrU2Fua2V5Kw==\" target=\"_blank\" rel=\"noopener noreferrer nofollow\"><img decoding=\"async\" class=\"alignnone size-full wp-image-4345\" src=\"https:\/\/chartexpo.com\/blog\/wp-content\/uploads\/2023\/04\/CTA-in-power-bi.jpg\" alt=\"\" width=\"205\" height=\"113\" \/><\/a> <a href=\"https:\/\/chartexpo.com\/utmAction\/MTYrYmxvZytncytjZXhwbytDRTcwNis=\" target=\"_blank\" rel=\"noopener noreferrer nofollow\"><img decoding=\"async\" class=\"alignnone size-full wp-image-4345\" src=\"https:\/\/chartexpo.com\/blog\/wp-content\/uploads\/2023\/04\/CTA-in-google-sheets.jpg\" alt=\"\" width=\"205\" height=\"113\" \/><\/a> <a href=\"https:\/\/chartexpo.com\/utmAction\/MTYrYmxvZyt4bCtjZXhwbytDRTcwNis=\" target=\"_blank\" rel=\"noopener noreferrer nofollow\"><img decoding=\"async\" class=\"alignnone size-full wp-image-4345\" src=\"https:\/\/chartexpo.com\/blog\/wp-content\/uploads\/2023\/04\/CTA-in-microsoft-excel.jpg\" alt=\"\" width=\"205\" height=\"113\" \/><\/a><\/div>\n<h4>Insights<\/h4>\n<ul>\n<li>At Level 1 (Total Cost), the procurement cost is $155K.<\/li>\n<li>At Level 2 (Company Type), out of the $155K cost, $82.4K (53.3%) was spent on subcontractors, while $72.3K (46.7%) was allocated to the supplier.<\/li>\n<li>At Level 3 (Company Name), the supplier cost of $72.3K was divided between two companies: Five-star Construction and Power-up Builder, with charges of $19.3K and $53.0K, respectively.<\/li>\n<li>The subcontractor cost of $82.4K was distributed among three companies: Onyx General Contractors, Skyline Contractors, and Living Well Remodeling. They charged $30.7K, $25.6K, and $26.0K, respectively, for their services.<\/li>\n<\/ul>\n<h3>Revolutionize Data Flow in Power BI Cumulative Sum Using Graphs:<\/h3>\n<ol>\n<li>Open your Power BI Desktop or Web.<\/li>\n<li>From the Power BI Visualizations pane, expand three dots at the bottom and select \u201cGet more visuals\u201d.<\/li>\n<li>Search for \u201c<a href=\"https:\/\/chartexpo.com\/utmAction\/MTYrYmxvZytwYitjZXhwbytQQkk3MDYrU2Fua2V5Kw==\" target=\"_blank\" rel=\"noopener noreferrer nofollow\">Sankey Chart by ChartExpo<\/a>\u201d on the AppSource.<\/li>\n<li>Add the custom visual.<\/li>\n<li>Select your data and configure the chart settings to create the chart.<\/li>\n<li>Customize your chart properties to add header, axis, legends, and other required information.<\/li>\n<li>Share the chart with your audience.<\/li>\n<\/ol>\n<p>The following video will help you create a Sankey Chart in Microsoft Power BI.<\/p>\n<p><iframe title=\"YouTube video player\" src=\"https:\/\/www.youtube.com\/embed\/_UyS9hzktr8?si=zkl8vEiizt8_NipC\" width=\"560\" height=\"315\" frameborder=\"0\" allowfullscreen=\"allowfullscreen\" data-mce-fragment=\"1\"><\/iframe><\/p>\n<div style=\"text-align: center;\"><a href=\"https:\/\/chartexpo.com\/utmAction\/MTYrYmxvZytwYitjZXhwbytQQkk3MDYrU2Fua2V5Kw==\" target=\"_blank\" rel=\"noopener noreferrer nofollow\"><img decoding=\"async\" class=\"alignnone size-full wp-image-4345\" src=\"https:\/\/chartexpo.com\/blog\/wp-content\/uploads\/2023\/04\/CTA-in-power-bi.jpg\" alt=\"\" width=\"205\" height=\"113\" \/><\/a> <a href=\"https:\/\/chartexpo.com\/utmAction\/MTYrYmxvZytncytjZXhwbytDRTcwNis=\" target=\"_blank\" rel=\"noopener noreferrer nofollow\"><img decoding=\"async\" class=\"alignnone size-full wp-image-4345\" src=\"https:\/\/chartexpo.com\/blog\/wp-content\/uploads\/2023\/04\/CTA-in-google-sheets.jpg\" alt=\"\" width=\"205\" height=\"113\" \/><\/a> <a href=\"https:\/\/chartexpo.com\/utmAction\/MTYrYmxvZyt4bCtjZXhwbytDRTcwNis=\" target=\"_blank\" rel=\"noopener noreferrer nofollow\"><img decoding=\"async\" class=\"alignnone size-full wp-image-4345\" src=\"https:\/\/chartexpo.com\/blog\/wp-content\/uploads\/2023\/04\/CTA-in-microsoft-excel.jpg\" alt=\"\" width=\"205\" height=\"113\" \/><\/a><\/div>\n<h2 id=\"what-are-the-tips-and-tricks-for-using-power-bi-cumulative-sum\">What are the Tips and Tricks for Using Power BI Cumulative Sum?<\/h2>\n<p>Using Power BI cumulative sums effectively requires leveraging DAX, proper visualization practices, and smart data modeling. Here are some tips and tricks to help you make the most out of cumulative sums in Power BI:<\/p>\n<ul>\n<li><strong>Understand the Data Model:<\/strong> Familiarize yourself with the <a href=\"https:\/\/chartexpo.com\/blog\/power-bi-data-model\" target=\"_blank\" rel=\"noopener\">Power BI data model<\/a>. A good grasp of the data model will help you create meaningful and accurate cumulative sums, ensuring that your calculations reflect the true relationships and structure of your data.<\/li>\n<li><strong>Use Time Intelligence Functions:<\/strong> Take advantage of the built-in time <a href=\"https:\/\/chartexpo.com\/blog\/what-is-business-intelligence\" target=\"_blank\" rel=\"noopener\">business intelligence<\/a> functions like TOTALMTD, TOTALYTD, or TOTALQTD for cumulative sums over different periods. These functions simplify calculations for year-to-date, quarter-to-date, or month-to-date totals.<\/li>\n<li><strong>Consider Sorting and Filtering:<\/strong> Your data should be properly sorted and filtered using <a href=\"https:\/\/chartexpo.com\/blog\/filters-in-power-bi\" target=\"_blank\" rel=\"noopener\">filters in Power BI<\/a> for the cumulative sum calculation. This becomes particularly important when you&#8217;re dealing with time-based data, as it ensures accurate and meaningful results.<\/li>\n<li><strong>Optimize Performance:<\/strong> You need to optimize the performance of the cumulative sum calculations by using <a href=\"https:\/\/chartexpo.com\/blog\/dax-variables\" target=\"_blank\" rel=\"noopener\">DAX variables<\/a>. Avoid unnecessary iterations and ensure that the DAX formulas are efficient, improving the overall calculation speed and accuracy.<\/li>\n<\/ul>\n<h2>FAQs<\/h2>\n<h3>How do you find the cumulative sum in Power BI?<\/h3>\n<p>To find the cumulative sum in Power BI, you\u2019ll have to create a new measure using DAX. For instance, CumulativeSales = CALCULATE(SUM(\u2019Sales\u2019[Amount]), FILTER(ALL(\u2019Sales\u2019), \u2018Sales\u2019[Date] \u2190 MAX(\u2019Sales\u2019[Date]))).<\/p>\n<h3>How do you add a cumulative line in Power BI?<\/h3>\n<p>To add a cumulative line in Power BI, create a line chart with a date field on the axis. Use a cumulative sum measure, like CumulativeSales = TOTALYTD(SUM(\u2019Sales\u2019[Amount]), \u2018Sales\u2019[Date]).<\/p>\n<h4 id=\"wrap-up\">Wrap Up<\/h4>\n<p>Power BI cumulative sums are used to track running totals over time. That helps to reveal trends, progress towards goals, and overall patterns.<\/p>\n<p>To get the most out of Power BI cumulative sums, you&#8217;ll have to follow DAX patterns and best practices. This will enable you to write efficient and maintainable cumulative sum formulas. You should also consider using variables, and avoid unnecessary recalculations. Always organize your code for clarity.<\/p>\n<p>Furthermore, you have to verify the accuracy of your cumulative sum calculations. That can be done by performing manual checks or comparing results with known values. This way, your calculations will align with your expectations.<\/p>\n<p>Data (and business) analysts who combine cumulative sums with other relevant metrics will most likely have a comprehensive view of their data. This will, in turn, enhance the insights gained from the analysis.<\/p>\n<p>Now you know how to create a cumulative sum using DAX in Power BI, what kind of visualization will you be using to represent your data?<\/p>\n","protected":false},"excerpt":{"rendered":"<p><p>Master Power BI cumulative sum with DAX formulas and visualizations. This guide helps analysts explore running totals, financial trends, &#038; actionable insights.<\/p>\n&nbsp;&nbsp;<a href=\"https:\/\/chartexpo.com\/blog\/power-bi-cumulative-sum\"><\/a><\/p>","protected":false},"author":1,"featured_media":45117,"comment_status":"closed","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[1017],"tags":[],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v21.5 - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\r\n<title>Power BI Cumulative Sum Steps to Build Insights -<\/title>\r\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\r\n<link rel=\"canonical\" href=\"https:\/\/chartexpo.com\/blog\/power-bi-cumulative-sum\" \/>\r\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\r\n<meta name=\"twitter:title\" content=\"Power BI Cumulative Sum Steps to Build Insights -\" \/>\r\n<meta name=\"twitter:description\" content=\"Master Power BI cumulative sum with DAX formulas and visualizations. This guide helps analysts explore running totals, financial trends, &amp; actionable insights.\" \/>\r\n<meta name=\"twitter:image\" content=\"https:\/\/chartexpo.com\/blog\/wp-content\/uploads\/2024\/12\/feature-ce706-200x200-1.jpg\" \/>\r\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"admin\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"18 minutes\" \/>\r\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Power BI Cumulative Sum Steps to Build Insights -","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/chartexpo.com\/blog\/power-bi-cumulative-sum","twitter_card":"summary_large_image","twitter_title":"Power BI Cumulative Sum Steps to Build Insights -","twitter_description":"Master Power BI cumulative sum with DAX formulas and visualizations. This guide helps analysts explore running totals, financial trends, & actionable insights.","twitter_image":"https:\/\/chartexpo.com\/blog\/wp-content\/uploads\/2024\/12\/feature-ce706-200x200-1.jpg","twitter_misc":{"Written by":"admin","Est. reading time":"18 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/chartexpo.com\/blog\/power-bi-cumulative-sum","url":"https:\/\/chartexpo.com\/blog\/power-bi-cumulative-sum","name":"Power BI Cumulative Sum Steps to Build Insights -","isPartOf":{"@id":"http:\/\/localhost\/blog\/#website"},"datePublished":"2024-12-19T14:48:51+00:00","dateModified":"2025-12-17T09:26:29+00:00","author":{"@id":"http:\/\/localhost\/blog\/#\/schema\/person\/6aceeb7c948a3f66ff6439ce5c24a280"},"breadcrumb":{"@id":"https:\/\/chartexpo.com\/blog\/power-bi-cumulative-sum#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/chartexpo.com\/blog\/power-bi-cumulative-sum"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/chartexpo.com\/blog\/power-bi-cumulative-sum#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"http:\/\/localhost\/blog"},{"@type":"ListItem","position":2,"name":"Power BI Cumulative Sum Steps to Build Insights"}]},{"@type":"WebSite","@id":"http:\/\/localhost\/blog\/#website","url":"http:\/\/localhost\/blog\/","name":"","description":"","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"http:\/\/localhost\/blog\/?s={search_term_string}"},"query-input":"required name=search_term_string"}],"inLanguage":"en-US"},{"@type":"Person","@id":"http:\/\/localhost\/blog\/#\/schema\/person\/6aceeb7c948a3f66ff6439ce5c24a280","name":"admin","url":"https:\/\/chartexpo.com\/blog\/author\/admin"}]}},"_links":{"self":[{"href":"https:\/\/chartexpo.com\/blog\/wp-json\/wp\/v2\/posts\/45089"}],"collection":[{"href":"https:\/\/chartexpo.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/chartexpo.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/chartexpo.com\/blog\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/chartexpo.com\/blog\/wp-json\/wp\/v2\/comments?post=45089"}],"version-history":[{"count":9,"href":"https:\/\/chartexpo.com\/blog\/wp-json\/wp\/v2\/posts\/45089\/revisions"}],"predecessor-version":[{"id":56947,"href":"https:\/\/chartexpo.com\/blog\/wp-json\/wp\/v2\/posts\/45089\/revisions\/56947"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/chartexpo.com\/blog\/wp-json\/wp\/v2\/media\/45117"}],"wp:attachment":[{"href":"https:\/\/chartexpo.com\/blog\/wp-json\/wp\/v2\/media?parent=45089"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/chartexpo.com\/blog\/wp-json\/wp\/v2\/categories?post=45089"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/chartexpo.com\/blog\/wp-json\/wp\/v2\/tags?post=45089"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}