{"id":4481,"date":"2023-03-10T19:01:51","date_gmt":"2023-03-10T19:01:51","guid":{"rendered":"https:\/\/monocroft.com\/?p=4481"},"modified":"2023-03-10T19:36:11","modified_gmt":"2023-03-10T19:36:11","slug":"how-to-calculate-the-cumulative-value-from-a-start-date-in-power-bi","status":"publish","type":"post","link":"https:\/\/monocroft.com\/how-to-calculate-the-cumulative-value-from-a-start-date-in-power-bi\/","title":{"rendered":"How to Calculate the Cumulative Value From a Start Date in Power BI"},"content":{"rendered":"\n

Power BI is a powerful data analysis and visualization tool, and one of its key features is its ability to calculate cumulative values over time, such as calculating the cumulative value from a start date, which is useful when analyzing trends and patterns in data.<\/p>\n\n\n\n

This cumulative value can help you track sales, revenue, or expenses over time, identify trends in customer behavior, or analyze changes in stock prices, and can be used in various visualizations such as charts and tables.<\/p>\n\n\n\n

In this article, I will walk you through the steps to calculate the cumulative value from a start date in Power BI.<\/p>\n\n\n\n

Introduction: How to Calculate the Cumulative Value From a Start Date in Power BI<\/h2>\n\n\n\n

To calculate the cumulative value from a start date in Power BI, you can follow these steps<\/p>\n\n\n\n

Import Data into Power BI<\/h2>\n\n\n\n

To calculate the cumulative value, the first thing to do is to import the data<\/a> into Power BI. To do this, click the Get Data<\/strong> option from the Home <\/strong>ribbon. Then select the data source you want to work with.<\/p>\n\n\n

\n
\"\"<\/figure><\/div>\n\n\n

Create a Date Table<\/h2>\n\n\n\n

The next thing to do is to create a date table that will be used for calculations. This table should include a list of dates for the time period you want to analyze.<\/p>\n\n\n\n

You can create this table by going to the Modeling tab and selecting New Table<\/strong>, which will open a new dialog box where you can enter a formula to create the Date <\/strong>table.<\/p>\n\n\n

\n
\"\"<\/figure><\/div>\n\n\n

In the formula bar of the new dialog box, enter the following formula to create a date table for the year 2022:<\/p>\n\n\n\n

Date = CALENDAR(DATE(2022,1,1), DATE(2022,12,31))<\/strong><\/code><\/pre>\n\n\n\n

This formula uses the CALENDAR <\/strong><\/code>function to create a table that includes all the dates from January 1st, 2022 to December 31st, 2022.<\/em><\/p>\n\n\n\n

Merge the Date Table with the Data Table<\/h2>\n\n\n\n

Once you have created the Date<\/strong> table, you need to merge it with the data table (the table that contains the columns you want to calculate cumulative values for)<\/em>.<\/p>\n\n\n\n

To do this, select the Manage Relationships<\/strong> option from the Modeling ribbon, and then create a relationship between the date column in the data table and the date column in the date table.<\/p>\n\n\n

\n
\"\"<\/figure><\/div>\n\n\n

Calculate the Cumulative Value<\/h2>\n\n\n\n

To calculate the cumulative value, you need to create a new measure. To do this, select New Measure<\/strong> from the Modeling ribbon<\/strong> and then enter the following formula:<\/p>\n\n\n\n

Cumulative_Value = CALCULATE(SUM(Table[Value]),FILTER(ALL(DateTable), DateTable[Date] <= MAX(DateTable[Date])))<\/strong><\/code><\/pre>\n\n\n\n

This formula uses the CALCULATE <\/strong><\/code>function to sum the values in the data table and then applies a filter to include only dates that are less than or equal to the maximum date in the Date<\/strong> table.<\/p>\n\n\n\n

Visualize the Data<\/h2>\n\n\n\n

Once you have calculated the cumulative value, you can visualize it using a chart or graph. Select the chart or graph you want to use from the Visualizations pane and then drag the cumulative value measure to the Values field. <\/p>\n\n\n\n

You can also drag the date column from the date table to the Axis field to create a time series chart.<\/p>\n\n\n\n

Conclusion: How to Calculate the Cumulative Value From a Start Date<\/h2>\n\n\n\n

Calculating cumulative values in Power BI is a useful way to analyze trends and patterns in data over time.<\/p>\n\n\n\n

By following the steps in this article, you can easily create a cumulative value measure and visualize it using a chart or graph. With these skills, you will be well-equipped to perform advanced data analysis in Power BI.<\/p>\n\n\n\n

I hope you understood these steps.<\/p>\n\n\n\n

Thanks for reading!<\/p>\n","protected":false},"excerpt":{"rendered":"

Power BI is a powerful data analysis and visualization tool, and one of its key features is its ability to … <\/p>\n

Read more<\/a><\/p>\n","protected":false},"author":2,"featured_media":4486,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[1,8],"tags":[],"yoast_head":"\nHow to Calculate the Cumulative Value From a Start Date in Power BI - Monocroft<\/title>\n<meta name=\"description\" content=\"In this article, you will learn how to calculate the cumulative value from a start date in Power BI. Read to learn more.\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/monocroft.com\/how-to-calculate-the-cumulative-value-from-a-start-date-in-power-bi\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"How to Calculate the Cumulative Value From a Start Date in Power BI - Monocroft\" \/>\n<meta property=\"og:description\" content=\"In this article, you will learn how to calculate the cumulative value from a start date in Power BI. Read to learn more.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/monocroft.com\/how-to-calculate-the-cumulative-value-from-a-start-date-in-power-bi\/\" \/>\n<meta property=\"og:site_name\" content=\"Monocroft\" \/>\n<meta property=\"article:published_time\" content=\"2023-03-10T19:01:51+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2023-03-10T19:36:11+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/monocroft.com\/wp-content\/uploads\/2023\/03\/how-to-calculate-the-cumulative-value-from-a-start-date-monocroft.jpg\" \/>\n\t<meta property=\"og:image:width\" content=\"720\" \/>\n\t<meta property=\"og:image:height\" content=\"405\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/jpeg\" \/>\n<meta name=\"author\" content=\"Matt\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Matt\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"3 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\/\/monocroft.com\/how-to-calculate-the-cumulative-value-from-a-start-date-in-power-bi\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/monocroft.com\/how-to-calculate-the-cumulative-value-from-a-start-date-in-power-bi\/\"},\"author\":{\"name\":\"Matt\",\"@id\":\"https:\/\/monocroft.com\/#\/schema\/person\/3aeab97c9b5661d211c0742c48f024b3\"},\"headline\":\"How to Calculate the Cumulative Value From a Start Date in Power BI\",\"datePublished\":\"2023-03-10T19:01:51+00:00\",\"dateModified\":\"2023-03-10T19:36:11+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/monocroft.com\/how-to-calculate-the-cumulative-value-from-a-start-date-in-power-bi\/\"},\"wordCount\":582,\"publisher\":{\"@id\":\"https:\/\/monocroft.com\/#organization\"},\"image\":{\"@id\":\"https:\/\/monocroft.com\/how-to-calculate-the-cumulative-value-from-a-start-date-in-power-bi\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/monocroft.com\/wp-content\/uploads\/2023\/03\/how-to-calculate-the-cumulative-value-from-a-start-date-monocroft.jpg\",\"articleSection\":[\"Guides\",\"PowerBI\"],\"inLanguage\":\"en-US\"},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/monocroft.com\/how-to-calculate-the-cumulative-value-from-a-start-date-in-power-bi\/\",\"url\":\"https:\/\/monocroft.com\/how-to-calculate-the-cumulative-value-from-a-start-date-in-power-bi\/\",\"name\":\"How to Calculate the Cumulative Value From a Start Date in Power BI - Monocroft\",\"isPartOf\":{\"@id\":\"https:\/\/monocroft.com\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/monocroft.com\/how-to-calculate-the-cumulative-value-from-a-start-date-in-power-bi\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/monocroft.com\/how-to-calculate-the-cumulative-value-from-a-start-date-in-power-bi\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/monocroft.com\/wp-content\/uploads\/2023\/03\/how-to-calculate-the-cumulative-value-from-a-start-date-monocroft.jpg\",\"datePublished\":\"2023-03-10T19:01:51+00:00\",\"dateModified\":\"2023-03-10T19:36:11+00:00\",\"description\":\"In this article, you will learn how to calculate the cumulative value from a start date in Power BI. Read to learn more.\",\"breadcrumb\":{\"@id\":\"https:\/\/monocroft.com\/how-to-calculate-the-cumulative-value-from-a-start-date-in-power-bi\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/monocroft.com\/how-to-calculate-the-cumulative-value-from-a-start-date-in-power-bi\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/monocroft.com\/how-to-calculate-the-cumulative-value-from-a-start-date-in-power-bi\/#primaryimage\",\"url\":\"https:\/\/monocroft.com\/wp-content\/uploads\/2023\/03\/how-to-calculate-the-cumulative-value-from-a-start-date-monocroft.jpg\",\"contentUrl\":\"https:\/\/monocroft.com\/wp-content\/uploads\/2023\/03\/how-to-calculate-the-cumulative-value-from-a-start-date-monocroft.jpg\",\"width\":720,\"height\":405,\"caption\":\"how to calculate the cumulative value from a start date - monocroft\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/monocroft.com\/how-to-calculate-the-cumulative-value-from-a-start-date-in-power-bi\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/monocroft.com\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"How to Calculate the Cumulative Value From a Start Date in Power BI\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/monocroft.com\/#website\",\"url\":\"https:\/\/monocroft.com\/\",\"name\":\"Monocroft\",\"description\":\"Monocroft Tech\",\"publisher\":{\"@id\":\"https:\/\/monocroft.com\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/monocroft.com\/?s={search_term_string}\"},\"query-input\":\"required name=search_term_string\"}],\"inLanguage\":\"en-US\"},{\"@type\":\"Organization\",\"@id\":\"https:\/\/monocroft.com\/#organization\",\"name\":\"Triburge\",\"url\":\"https:\/\/monocroft.com\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/monocroft.com\/#\/schema\/logo\/image\/\",\"url\":\"https:\/\/monocroft.com\/wp-content\/uploads\/2023\/07\/monocroft-logo.png\",\"contentUrl\":\"https:\/\/monocroft.com\/wp-content\/uploads\/2023\/07\/monocroft-logo.png\",\"width\":512,\"height\":512,\"caption\":\"Triburge\"},\"image\":{\"@id\":\"https:\/\/monocroft.com\/#\/schema\/logo\/image\/\"}},{\"@type\":\"Person\",\"@id\":\"https:\/\/monocroft.com\/#\/schema\/person\/3aeab97c9b5661d211c0742c48f024b3\",\"name\":\"Matt\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/monocroft.com\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/c06bcee4d38a649222493c5e9f11f7a5?s=96&d=mm&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/c06bcee4d38a649222493c5e9f11f7a5?s=96&d=mm&r=g\",\"caption\":\"Matt\"},\"url\":\"https:\/\/monocroft.com\/author\/matthew\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"How to Calculate the Cumulative Value From a Start Date in Power BI - Monocroft","description":"In this article, you will learn how to calculate the cumulative value from a start date in Power BI. Read to learn more.","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:\/\/monocroft.com\/how-to-calculate-the-cumulative-value-from-a-start-date-in-power-bi\/","og_locale":"en_US","og_type":"article","og_title":"How to Calculate the Cumulative Value From a Start Date in Power BI - Monocroft","og_description":"In this article, you will learn how to calculate the cumulative value from a start date in Power BI. Read to learn more.","og_url":"https:\/\/monocroft.com\/how-to-calculate-the-cumulative-value-from-a-start-date-in-power-bi\/","og_site_name":"Monocroft","article_published_time":"2023-03-10T19:01:51+00:00","article_modified_time":"2023-03-10T19:36:11+00:00","og_image":[{"width":720,"height":405,"url":"https:\/\/monocroft.com\/wp-content\/uploads\/2023\/03\/how-to-calculate-the-cumulative-value-from-a-start-date-monocroft.jpg","type":"image\/jpeg"}],"author":"Matt","twitter_card":"summary_large_image","twitter_misc":{"Written by":"Matt","Est. reading time":"3 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/monocroft.com\/how-to-calculate-the-cumulative-value-from-a-start-date-in-power-bi\/#article","isPartOf":{"@id":"https:\/\/monocroft.com\/how-to-calculate-the-cumulative-value-from-a-start-date-in-power-bi\/"},"author":{"name":"Matt","@id":"https:\/\/monocroft.com\/#\/schema\/person\/3aeab97c9b5661d211c0742c48f024b3"},"headline":"How to Calculate the Cumulative Value From a Start Date in Power BI","datePublished":"2023-03-10T19:01:51+00:00","dateModified":"2023-03-10T19:36:11+00:00","mainEntityOfPage":{"@id":"https:\/\/monocroft.com\/how-to-calculate-the-cumulative-value-from-a-start-date-in-power-bi\/"},"wordCount":582,"publisher":{"@id":"https:\/\/monocroft.com\/#organization"},"image":{"@id":"https:\/\/monocroft.com\/how-to-calculate-the-cumulative-value-from-a-start-date-in-power-bi\/#primaryimage"},"thumbnailUrl":"https:\/\/monocroft.com\/wp-content\/uploads\/2023\/03\/how-to-calculate-the-cumulative-value-from-a-start-date-monocroft.jpg","articleSection":["Guides","PowerBI"],"inLanguage":"en-US"},{"@type":"WebPage","@id":"https:\/\/monocroft.com\/how-to-calculate-the-cumulative-value-from-a-start-date-in-power-bi\/","url":"https:\/\/monocroft.com\/how-to-calculate-the-cumulative-value-from-a-start-date-in-power-bi\/","name":"How to Calculate the Cumulative Value From a Start Date in Power BI - Monocroft","isPartOf":{"@id":"https:\/\/monocroft.com\/#website"},"primaryImageOfPage":{"@id":"https:\/\/monocroft.com\/how-to-calculate-the-cumulative-value-from-a-start-date-in-power-bi\/#primaryimage"},"image":{"@id":"https:\/\/monocroft.com\/how-to-calculate-the-cumulative-value-from-a-start-date-in-power-bi\/#primaryimage"},"thumbnailUrl":"https:\/\/monocroft.com\/wp-content\/uploads\/2023\/03\/how-to-calculate-the-cumulative-value-from-a-start-date-monocroft.jpg","datePublished":"2023-03-10T19:01:51+00:00","dateModified":"2023-03-10T19:36:11+00:00","description":"In this article, you will learn how to calculate the cumulative value from a start date in Power BI. Read to learn more.","breadcrumb":{"@id":"https:\/\/monocroft.com\/how-to-calculate-the-cumulative-value-from-a-start-date-in-power-bi\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/monocroft.com\/how-to-calculate-the-cumulative-value-from-a-start-date-in-power-bi\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/monocroft.com\/how-to-calculate-the-cumulative-value-from-a-start-date-in-power-bi\/#primaryimage","url":"https:\/\/monocroft.com\/wp-content\/uploads\/2023\/03\/how-to-calculate-the-cumulative-value-from-a-start-date-monocroft.jpg","contentUrl":"https:\/\/monocroft.com\/wp-content\/uploads\/2023\/03\/how-to-calculate-the-cumulative-value-from-a-start-date-monocroft.jpg","width":720,"height":405,"caption":"how to calculate the cumulative value from a start date - monocroft"},{"@type":"BreadcrumbList","@id":"https:\/\/monocroft.com\/how-to-calculate-the-cumulative-value-from-a-start-date-in-power-bi\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/monocroft.com\/"},{"@type":"ListItem","position":2,"name":"How to Calculate the Cumulative Value From a Start Date in Power BI"}]},{"@type":"WebSite","@id":"https:\/\/monocroft.com\/#website","url":"https:\/\/monocroft.com\/","name":"Monocroft","description":"Monocroft Tech","publisher":{"@id":"https:\/\/monocroft.com\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/monocroft.com\/?s={search_term_string}"},"query-input":"required name=search_term_string"}],"inLanguage":"en-US"},{"@type":"Organization","@id":"https:\/\/monocroft.com\/#organization","name":"Triburge","url":"https:\/\/monocroft.com\/","logo":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/monocroft.com\/#\/schema\/logo\/image\/","url":"https:\/\/monocroft.com\/wp-content\/uploads\/2023\/07\/monocroft-logo.png","contentUrl":"https:\/\/monocroft.com\/wp-content\/uploads\/2023\/07\/monocroft-logo.png","width":512,"height":512,"caption":"Triburge"},"image":{"@id":"https:\/\/monocroft.com\/#\/schema\/logo\/image\/"}},{"@type":"Person","@id":"https:\/\/monocroft.com\/#\/schema\/person\/3aeab97c9b5661d211c0742c48f024b3","name":"Matt","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/monocroft.com\/#\/schema\/person\/image\/","url":"https:\/\/secure.gravatar.com\/avatar\/c06bcee4d38a649222493c5e9f11f7a5?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/c06bcee4d38a649222493c5e9f11f7a5?s=96&d=mm&r=g","caption":"Matt"},"url":"https:\/\/monocroft.com\/author\/matthew\/"}]}},"_links":{"self":[{"href":"https:\/\/monocroft.com\/wp-json\/wp\/v2\/posts\/4481"}],"collection":[{"href":"https:\/\/monocroft.com\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/monocroft.com\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/monocroft.com\/wp-json\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/monocroft.com\/wp-json\/wp\/v2\/comments?post=4481"}],"version-history":[{"count":65,"href":"https:\/\/monocroft.com\/wp-json\/wp\/v2\/posts\/4481\/revisions"}],"predecessor-version":[{"id":5040,"href":"https:\/\/monocroft.com\/wp-json\/wp\/v2\/posts\/4481\/revisions\/5040"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/monocroft.com\/wp-json\/wp\/v2\/media\/4486"}],"wp:attachment":[{"href":"https:\/\/monocroft.com\/wp-json\/wp\/v2\/media?parent=4481"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/monocroft.com\/wp-json\/wp\/v2\/categories?post=4481"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/monocroft.com\/wp-json\/wp\/v2\/tags?post=4481"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}