{"id":8649,"date":"2024-03-06T07:26:48","date_gmt":"2024-03-06T06:26:48","guid":{"rendered":"https:\/\/expert-only.com\/?p=8649"},"modified":"2024-03-06T21:26:57","modified_gmt":"2024-03-06T20:26:57","slug":"how-to-calculate-previous-month-value-in-power-bi","status":"publish","type":"post","link":"https:\/\/expert-only.com\/en\/power-bi\/how-to-calculate-previous-month-value-in-power-bi\/","title":{"rendered":"How to Calculate the Previous Month Value in Power BI ?"},"content":{"rendered":"\n<h4 class=\"wp-block-heading has-text-align-left\"><em>How to create a calculation of the previous month value using DAX formulas in Power BI?<\/em><\/h4>\n\n\n\n<p>Discover how to calculate the Power BI previous month value in this tutorial using 2 different approach&#8217;s. Managers, Accountants, Financial advisors and Business Intelligence consultants use Power BI. And month comparisons extensively, like the previous month values and the last year values. To create these comparison measures, use the DAX time intelligence functions available in the DAX editor. Let&#8217;s use the PREVIOUS MONTH DAX function to address this.<\/p>\n\n\n\n<div id=\"ez-toc-container\" class=\"ez-toc-v2_0_82_2 ez-toc-wrap-center counter-hierarchy ez-toc-counter ez-toc-grey ez-toc-container-direction\">\n<div class=\"ez-toc-title-container\">\n<p class=\"ez-toc-title\" style=\"cursor:inherit\">Table of Contents<\/p>\n<span class=\"ez-toc-title-toggle\"><\/span><\/div>\n<nav><ul class='ez-toc-list ez-toc-list-level-1 ' ><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-1\" href=\"https:\/\/expert-only.com\/en\/power-bi\/how-to-calculate-previous-month-value-in-power-bi\/#1-use-previousmonth-function-in-dax-to-get-the-previous-month\" >1. Use PREVIOUSMONTH function in DAX to get the previous month<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-2\" href=\"https:\/\/expert-only.com\/en\/power-bi\/how-to-calculate-previous-month-value-in-power-bi\/#2-calculate-previous-month-directly-from-power-bi-data-source\" >2. Calculate previous month directly from Power BI data source<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-3\" href=\"https:\/\/expert-only.com\/en\/power-bi\/how-to-calculate-previous-month-value-in-power-bi\/#3-use-two-levels-of-formulas-to-get-the-previous-month\" >3. Use two levels of formulas to get the previous month<\/a><\/li><\/ul><\/nav><\/div>\n<h2 class=\"wp-block-heading\" id=\"h-1-use-previousmonth-function-in-dax-to-get-the-previous-month\"><span class=\"ez-toc-section\" id=\"1-use-previousmonth-function-in-dax-to-get-the-previous-month\"><\/span>1. Use PREVIOUSMONTH function in DAX to get the previous month<span class=\"ez-toc-section-end\"><\/span><\/h2>\n\n\n\n<p>The DAX PREVIOUSMONTH function goal is <strong>to retrieve data from the immediate prior month based on a specified date column<\/strong>. For instance, if you have sales data and want to compare this month&#8217;s sales to last month&#8217;s, you could use <strong><em>PREVIOUSMONTH(&#8216;Table'[Date])<\/em><\/strong> within a measure.<\/p>\n\n\n\n<p>When applied, the function filters the data to only include values from the month immediately preceding the latest date in the column. It&#8217;s vital to note that <strong>the function operates within the context of your Power BI data model<\/strong>. In other words, it works best when you have a proper date table related to your transactional data. I would add that I highly recommended to double check the configuration of your table marked as date.<\/p>\n\n\n\n<h3 class=\"wp-block-heading\" id=\"h-two-options-available-using-dax-formulas-for-this-calculation\">Two options available using DAX formulas for this calculation<\/h3>\n\n\n\n<p>Let&#8217;s consider the sales table with sales stored by month, by year and the customer number. Also,  for any time intelligence function in DAX, i.e. in Power BI or a in Tabular model, a date column must be the reference. Let&#8217;s consider you have these two columns available in your data model:<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li>The Sales Amount column stores the number of sales registered on that day. <\/li>\n\n\n\n<li>The DateKey time column is a date used a the key for Power BI joins.<\/li>\n<\/ul>\n\n\n\n<p>Check also the possibility to store the total sales of one month on one unique day. Like the 31st of January 2020 for the January month for instance. Indeed, the goal is to introduce a unique date key for the time DAX functions, to enable the previous month sales calculation. To create the measure, use the <a href=\"https:\/\/docs.microsoft.com\/en-us\/dax\/previousmonth-function-dax\" target=\"_blank\" rel=\"noreferrer noopener\">previous month DAX function<\/a>, it&#8217;s official documentation and syntax are available on Microsoft website.<\/p>\n\n\n\n<h3 class=\"wp-block-heading\" id=\"h-one-prerequisite-set-up-a-date-table-to-use-time-intelligence-functions-in-power-bi\">One prerequisite: set up a Date Table to use time intelligence functions in Power BI<\/h3>\n\n\n\n<p>To effectively use time intelligence functions in Power BI, one prerequisite is setting up a Date Table. This table, featuring a <strong>continuous range of dates<\/strong>, is crucial for conducting accurate time-based analyses, as it enables Power BI to apply dynamic calculations over various periods, ensuring precision and consistency in temporal data evaluation.<\/p>\n\n\n\n<p>Sometime, when building a model, the following error can be encountered: <em>&#8220;Failed to resolve name &#8216;REVIOUSMONTH&#8217;. It is not a valid table, variable, or function name.<\/em>&#8221; To fix it, double check the formula bar and the highlighted errors, it usually syntax errors, or missing parenthesis, i.e. classical development errors. And the messages displayed by Power BI are explicit.<\/p>\n\n\n\n<h2 class=\"wp-block-heading\" id=\"h-2-calculate-previous-month-directly-from-power-bi-data-source\"><span class=\"ez-toc-section\" id=\"2-calculate-previous-month-directly-from-power-bi-data-source\"><\/span>2. Calculate previous month directly from Power BI data source<span class=\"ez-toc-section-end\"><\/span><\/h2>\n\n\n\n<p>In this first example, use <strong>Power BI Desktop<\/strong> and a Power BI file (pbix extension) to map directly the column from the data source. And in the <strong>Visual Studio<\/strong> development software for a Tabular Model using SSAS.<\/p>\n\n\n\n<pre class=\"EnlighterJSRAW\" data-enlighter-language=\"mssql\" data-enlighter-theme=\"\" data-enlighter-highlight=\"\" data-enlighter-linenumbers=\"\" data-enlighter-lineoffset=\"\" data-enlighter-title=\"\" data-enlighter-group=\"\">Sales Last Month = \nCALCULATE (\n    SUM ( sales[sales] ),\n    PREVIOUSMONTH ( 'time'[date_key]),\n    REMOVEFILTERS ( sales )\n)<\/pre>\n\n\n<div class=\"wp-block-image\">\n<figure class=\"aligncenter size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"740\" height=\"540\" src=\"https:\/\/expert-only.com\/wp-content\/uploads\/2022\/07\/power-bi-last-month-value-dax-formula.jpg\" alt=\"Power BI formula to calculate the previous month value using DAX\" class=\"wp-image-26588\" srcset=\"https:\/\/expert-only.com\/wp-content\/uploads\/2022\/07\/power-bi-last-month-value-dax-formula.jpg 740w, https:\/\/expert-only.com\/wp-content\/uploads\/2022\/07\/power-bi-last-month-value-dax-formula-300x219.jpg 300w\" sizes=\"auto, (max-width: 740px) 100vw, 740px\" \/><figcaption class=\"wp-element-caption\"><em>Power BI formula to calculate the previous month value using DAX<\/em><\/figcaption><\/figure><\/div>\n\n\n<p>And the result in the Power BI report gives something like this:<\/p>\n\n\n<div class=\"wp-block-image\">\n<figure class=\"aligncenter size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"740\" height=\"640\" src=\"https:\/\/expert-only.com\/wp-content\/uploads\/2022\/07\/power-bi-last-month-value-report-result.jpg\" alt=\"Power BI report showing last month sales calculated using PREVIOUSMONTH time function\" class=\"wp-image-26592\" srcset=\"https:\/\/expert-only.com\/wp-content\/uploads\/2022\/07\/power-bi-last-month-value-report-result.jpg 740w, https:\/\/expert-only.com\/wp-content\/uploads\/2022\/07\/power-bi-last-month-value-report-result-300x259.jpg 300w\" sizes=\"auto, (max-width: 740px) 100vw, 740px\" \/><figcaption class=\"wp-element-caption\"><em>Power BI report showing last month sales calculated using PREVIOUSMONTH time function<\/em><\/figcaption><\/figure><\/div>\n\n\n<h2 class=\"wp-block-heading\" id=\"h-3-use-two-levels-of-formulas-to-get-the-previous-month\"><span class=\"ez-toc-section\" id=\"3-use-two-levels-of-formulas-to-get-the-previous-month\"><\/span>3. Use two levels of formulas to get the previous month<span class=\"ez-toc-section-end\"><\/span><\/h2>\n\n\n\n<p>This second approach is very similar to the first one, but it simply uses a measure already created. It&#8217;s done in two steps and uses two DAX calculations instead of one. For example, create the measures of the current month sales with this DAX formula.<\/p>\n\n\n\n<pre class=\"EnlighterJSRAW\" data-enlighter-language=\"mssql\" data-enlighter-theme=\"\" data-enlighter-highlight=\"\" data-enlighter-linenumbers=\"\" data-enlighter-lineoffset=\"\" data-enlighter-title=\"\" data-enlighter-group=\"\">Sales := SUM('sales'[SalesAmount])<\/pre>\n\n\n\n<p>Then create the last month sales measure using this second DAX formula below:<\/p>\n\n\n\n<pre class=\"EnlighterJSRAW\" data-enlighter-language=\"mssql\" data-enlighter-theme=\"\" data-enlighter-highlight=\"\" data-enlighter-linenumbers=\"\" data-enlighter-lineoffset=\"\" data-enlighter-title=\"\" data-enlighter-group=\"\">Sales Last Month = \nCALCULATE (\n    sales[sales],\n    PREVIOUSMONTH ( 'time'[date_key]),\n    REMOVEFILTERS ( sales )\n)<\/pre>\n\n\n\n<h3 class=\"wp-block-heading\" id=\"h-about-previous-month-calculation-in-power-bi\">About previous month calculation in Power BI<\/h3>\n\n\n\n<p>In this Power BI tutorial, the two examples shows how easy it is to calculate a Power BI previous month value using the DAX PREVIOUSMONTH time function. In this previous tutorial on DAX functions, check out <a href=\"https:\/\/expert-only.com\/en\/power-bi\/calculate-ytd-value-in-power-bi\/\">how to create a YTD calculation using DAX and Power BI<\/a>.<\/p>\n\n\n\n<figure class=\"wp-block-embed aligncenter is-type-wp-embed is-provider-sql-and-it-tutorials wp-block-embed-sql-and-it-tutorials\"><div class=\"wp-block-embed__wrapper\">\n<blockquote class=\"wp-embedded-content\" data-secret=\"cQ4KCXeCBP\"><a href=\"https:\/\/expert-only.com\/en\/power-bi\/calculate-ytd-value-in-power-bi\/\">How to calculate a YTD value with Power BI?<\/a><\/blockquote><iframe loading=\"lazy\" class=\"wp-embedded-content\" sandbox=\"allow-scripts\" security=\"restricted\" style=\"position: absolute; clip: rect(1px, 1px, 1px, 1px);\" title=\"&#8220;How to calculate a YTD value with Power BI?&#8221; &#8212; SQL and IT Tutorials\" src=\"https:\/\/expert-only.com\/en\/power-bi\/calculate-ytd-value-in-power-bi\/embed\/#?secret=s6TD7LC3Jf#?secret=cQ4KCXeCBP\" data-secret=\"cQ4KCXeCBP\" width=\"500\" height=\"282\" frameborder=\"0\" marginwidth=\"0\" marginheight=\"0\" scrolling=\"no\"><\/iframe>\n<\/div><\/figure>\n","protected":false},"excerpt":{"rendered":"<div class=\"mh-excerpt\"><p>How to create a calculation of the previous month value using DAX formulas in Power BI? Discover how to calculate the Power BI previous month value in this tutorial using 2 different approach&#8217;s. Managers, Accountants, Financial advisors and Business <a class=\"mh-excerpt-more\" href=\"https:\/\/expert-only.com\/en\/power-bi\/how-to-calculate-previous-month-value-in-power-bi\/\" title=\"How to Calculate the Previous Month Value in Power BI ?\">&#8230;<\/a><\/p>\n<\/div>","protected":false},"author":1,"featured_media":5503,"comment_status":"closed","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[446],"tags":[],"class_list":{"0":"post-8649","1":"post","2":"type-post","3":"status-publish","4":"format-standard","5":"has-post-thumbnail","7":"category-power-bi"},"yoast_head":"<!-- This site is optimized with the Yoast SEO Premium plugin v21.7 (Yoast SEO v26.2) - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>How to Calculate the Previous Month Value in Power BI ? DAX<\/title>\n<meta name=\"description\" content=\"To calculate the previous month value in Power BI, use the PREVIOUSMONTH time function in a DAX formula and create the measure.\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/expert-only.com\/en\/power-bi\/how-to-calculate-previous-month-value-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 Previous Month Value in Power BI ?\" \/>\n<meta property=\"og:description\" content=\"To calculate the previous month value in Power BI, use the PREVIOUSMONTH time function in a DAX formula and create the measure.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/expert-only.com\/en\/power-bi\/how-to-calculate-previous-month-value-in-power-bi\/\" \/>\n<meta property=\"og:site_name\" content=\"SQL and IT Tutorials\" \/>\n<meta property=\"article:publisher\" content=\"https:\/\/www.facebook.com\/ExpertOnlyCom\/\" \/>\n<meta property=\"article:published_time\" content=\"2024-03-06T06:26:48+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2024-03-06T20:26:57+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/expert-only.com\/wp-content\/uploads\/2022\/03\/new-york-g80e1b732a_1920_1080.jpg\" \/>\n\t<meta property=\"og:image:width\" content=\"1920\" \/>\n\t<meta property=\"og:image:height\" content=\"1080\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/jpeg\" \/>\n<meta name=\"author\" content=\"Expert-Only\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:creator\" content=\"@expert_only\" \/>\n<meta name=\"twitter:site\" content=\"@expert_only\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Expert-Only\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"4 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\/\/expert-only.com\/en\/power-bi\/how-to-calculate-previous-month-value-in-power-bi\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/expert-only.com\/en\/power-bi\/how-to-calculate-previous-month-value-in-power-bi\/\"},\"author\":{\"name\":\"Expert-Only\",\"@id\":\"https:\/\/expert-only.com\/en\/#\/schema\/person\/406a9576b52944f018739a42046873ef\"},\"headline\":\"How to Calculate the Previous Month Value in Power BI ?\",\"datePublished\":\"2024-03-06T06:26:48+00:00\",\"dateModified\":\"2024-03-06T20:26:57+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/expert-only.com\/en\/power-bi\/how-to-calculate-previous-month-value-in-power-bi\/\"},\"wordCount\":727,\"publisher\":{\"@id\":\"https:\/\/expert-only.com\/en\/#organization\"},\"image\":{\"@id\":\"https:\/\/expert-only.com\/en\/power-bi\/how-to-calculate-previous-month-value-in-power-bi\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/expert-only.com\/wp-content\/uploads\/2022\/03\/new-york-g80e1b732a_1920_1080.jpg\",\"articleSection\":[\"Power BI\"],\"inLanguage\":\"en-US\"},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/expert-only.com\/en\/power-bi\/how-to-calculate-previous-month-value-in-power-bi\/\",\"url\":\"https:\/\/expert-only.com\/en\/power-bi\/how-to-calculate-previous-month-value-in-power-bi\/\",\"name\":\"How to Calculate the Previous Month Value in Power BI ? DAX\",\"isPartOf\":{\"@id\":\"https:\/\/expert-only.com\/en\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/expert-only.com\/en\/power-bi\/how-to-calculate-previous-month-value-in-power-bi\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/expert-only.com\/en\/power-bi\/how-to-calculate-previous-month-value-in-power-bi\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/expert-only.com\/wp-content\/uploads\/2022\/03\/new-york-g80e1b732a_1920_1080.jpg\",\"datePublished\":\"2024-03-06T06:26:48+00:00\",\"dateModified\":\"2024-03-06T20:26:57+00:00\",\"description\":\"To calculate the previous month value in Power BI, use the PREVIOUSMONTH time function in a DAX formula and create the measure.\",\"breadcrumb\":{\"@id\":\"https:\/\/expert-only.com\/en\/power-bi\/how-to-calculate-previous-month-value-in-power-bi\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/expert-only.com\/en\/power-bi\/how-to-calculate-previous-month-value-in-power-bi\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/expert-only.com\/en\/power-bi\/how-to-calculate-previous-month-value-in-power-bi\/#primaryimage\",\"url\":\"https:\/\/expert-only.com\/wp-content\/uploads\/2022\/03\/new-york-g80e1b732a_1920_1080.jpg\",\"contentUrl\":\"https:\/\/expert-only.com\/wp-content\/uploads\/2022\/03\/new-york-g80e1b732a_1920_1080.jpg\",\"width\":1920,\"height\":1080},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/expert-only.com\/en\/power-bi\/how-to-calculate-previous-month-value-in-power-bi\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"en\",\"item\":\"https:\/\/expert-only.com\/en\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"How to Calculate the Previous Month Value in Power BI ?\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/expert-only.com\/en\/#website\",\"url\":\"https:\/\/expert-only.com\/en\/\",\"name\":\"SQL and IT Tutorials\",\"description\":\"\",\"publisher\":{\"@id\":\"https:\/\/expert-only.com\/en\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/expert-only.com\/en\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":\"Organization\",\"@id\":\"https:\/\/expert-only.com\/en\/#organization\",\"name\":\"Expert-Only\",\"url\":\"https:\/\/expert-only.com\/en\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/expert-only.com\/en\/#\/schema\/logo\/image\/\",\"url\":\"https:\/\/expert-only.com\/wp-content\/uploads\/2017\/09\/cropped-logo_Expert-Only.jpg\",\"contentUrl\":\"https:\/\/expert-only.com\/wp-content\/uploads\/2017\/09\/cropped-logo_Expert-Only.jpg\",\"width\":381,\"height\":174,\"caption\":\"Expert-Only\"},\"image\":{\"@id\":\"https:\/\/expert-only.com\/en\/#\/schema\/logo\/image\/\"},\"sameAs\":[\"https:\/\/www.facebook.com\/ExpertOnlyCom\/\",\"https:\/\/x.com\/expert_only\",\"https:\/\/www.youtube.com\/channel\/UCMS5sR_FwAetB0FmciNvUaA\"]},{\"@type\":\"Person\",\"@id\":\"https:\/\/expert-only.com\/en\/#\/schema\/person\/406a9576b52944f018739a42046873ef\",\"name\":\"Expert-Only\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/expert-only.com\/en\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/084b15660763ff5b13bb60b2f52f97bb?s=96&d=identicon&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/084b15660763ff5b13bb60b2f52f97bb?s=96&d=identicon&r=g\",\"caption\":\"Expert-Only\"}}]}<\/script>\n<!-- \/ Yoast SEO Premium plugin. -->","yoast_head_json":{"title":"How to Calculate the Previous Month Value in Power BI ? DAX","description":"To calculate the previous month value in Power BI, use the PREVIOUSMONTH time function in a DAX formula and create the measure.","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:\/\/expert-only.com\/en\/power-bi\/how-to-calculate-previous-month-value-in-power-bi\/","og_locale":"en_US","og_type":"article","og_title":"How to Calculate the Previous Month Value in Power BI ?","og_description":"To calculate the previous month value in Power BI, use the PREVIOUSMONTH time function in a DAX formula and create the measure.","og_url":"https:\/\/expert-only.com\/en\/power-bi\/how-to-calculate-previous-month-value-in-power-bi\/","og_site_name":"SQL and IT Tutorials","article_publisher":"https:\/\/www.facebook.com\/ExpertOnlyCom\/","article_published_time":"2024-03-06T06:26:48+00:00","article_modified_time":"2024-03-06T20:26:57+00:00","og_image":[{"width":1920,"height":1080,"url":"https:\/\/expert-only.com\/wp-content\/uploads\/2022\/03\/new-york-g80e1b732a_1920_1080.jpg","type":"image\/jpeg"}],"author":"Expert-Only","twitter_card":"summary_large_image","twitter_creator":"@expert_only","twitter_site":"@expert_only","twitter_misc":{"Written by":"Expert-Only","Est. reading time":"4 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/expert-only.com\/en\/power-bi\/how-to-calculate-previous-month-value-in-power-bi\/#article","isPartOf":{"@id":"https:\/\/expert-only.com\/en\/power-bi\/how-to-calculate-previous-month-value-in-power-bi\/"},"author":{"name":"Expert-Only","@id":"https:\/\/expert-only.com\/en\/#\/schema\/person\/406a9576b52944f018739a42046873ef"},"headline":"How to Calculate the Previous Month Value in Power BI ?","datePublished":"2024-03-06T06:26:48+00:00","dateModified":"2024-03-06T20:26:57+00:00","mainEntityOfPage":{"@id":"https:\/\/expert-only.com\/en\/power-bi\/how-to-calculate-previous-month-value-in-power-bi\/"},"wordCount":727,"publisher":{"@id":"https:\/\/expert-only.com\/en\/#organization"},"image":{"@id":"https:\/\/expert-only.com\/en\/power-bi\/how-to-calculate-previous-month-value-in-power-bi\/#primaryimage"},"thumbnailUrl":"https:\/\/expert-only.com\/wp-content\/uploads\/2022\/03\/new-york-g80e1b732a_1920_1080.jpg","articleSection":["Power BI"],"inLanguage":"en-US"},{"@type":"WebPage","@id":"https:\/\/expert-only.com\/en\/power-bi\/how-to-calculate-previous-month-value-in-power-bi\/","url":"https:\/\/expert-only.com\/en\/power-bi\/how-to-calculate-previous-month-value-in-power-bi\/","name":"How to Calculate the Previous Month Value in Power BI ? DAX","isPartOf":{"@id":"https:\/\/expert-only.com\/en\/#website"},"primaryImageOfPage":{"@id":"https:\/\/expert-only.com\/en\/power-bi\/how-to-calculate-previous-month-value-in-power-bi\/#primaryimage"},"image":{"@id":"https:\/\/expert-only.com\/en\/power-bi\/how-to-calculate-previous-month-value-in-power-bi\/#primaryimage"},"thumbnailUrl":"https:\/\/expert-only.com\/wp-content\/uploads\/2022\/03\/new-york-g80e1b732a_1920_1080.jpg","datePublished":"2024-03-06T06:26:48+00:00","dateModified":"2024-03-06T20:26:57+00:00","description":"To calculate the previous month value in Power BI, use the PREVIOUSMONTH time function in a DAX formula and create the measure.","breadcrumb":{"@id":"https:\/\/expert-only.com\/en\/power-bi\/how-to-calculate-previous-month-value-in-power-bi\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/expert-only.com\/en\/power-bi\/how-to-calculate-previous-month-value-in-power-bi\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/expert-only.com\/en\/power-bi\/how-to-calculate-previous-month-value-in-power-bi\/#primaryimage","url":"https:\/\/expert-only.com\/wp-content\/uploads\/2022\/03\/new-york-g80e1b732a_1920_1080.jpg","contentUrl":"https:\/\/expert-only.com\/wp-content\/uploads\/2022\/03\/new-york-g80e1b732a_1920_1080.jpg","width":1920,"height":1080},{"@type":"BreadcrumbList","@id":"https:\/\/expert-only.com\/en\/power-bi\/how-to-calculate-previous-month-value-in-power-bi\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"en","item":"https:\/\/expert-only.com\/en\/"},{"@type":"ListItem","position":2,"name":"How to Calculate the Previous Month Value in Power BI ?"}]},{"@type":"WebSite","@id":"https:\/\/expert-only.com\/en\/#website","url":"https:\/\/expert-only.com\/en\/","name":"SQL and IT Tutorials","description":"","publisher":{"@id":"https:\/\/expert-only.com\/en\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/expert-only.com\/en\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Organization","@id":"https:\/\/expert-only.com\/en\/#organization","name":"Expert-Only","url":"https:\/\/expert-only.com\/en\/","logo":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/expert-only.com\/en\/#\/schema\/logo\/image\/","url":"https:\/\/expert-only.com\/wp-content\/uploads\/2017\/09\/cropped-logo_Expert-Only.jpg","contentUrl":"https:\/\/expert-only.com\/wp-content\/uploads\/2017\/09\/cropped-logo_Expert-Only.jpg","width":381,"height":174,"caption":"Expert-Only"},"image":{"@id":"https:\/\/expert-only.com\/en\/#\/schema\/logo\/image\/"},"sameAs":["https:\/\/www.facebook.com\/ExpertOnlyCom\/","https:\/\/x.com\/expert_only","https:\/\/www.youtube.com\/channel\/UCMS5sR_FwAetB0FmciNvUaA"]},{"@type":"Person","@id":"https:\/\/expert-only.com\/en\/#\/schema\/person\/406a9576b52944f018739a42046873ef","name":"Expert-Only","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/expert-only.com\/en\/#\/schema\/person\/image\/","url":"https:\/\/secure.gravatar.com\/avatar\/084b15660763ff5b13bb60b2f52f97bb?s=96&d=identicon&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/084b15660763ff5b13bb60b2f52f97bb?s=96&d=identicon&r=g","caption":"Expert-Only"}}]}},"_links":{"self":[{"href":"https:\/\/expert-only.com\/en\/wp-json\/wp\/v2\/posts\/8649","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/expert-only.com\/en\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/expert-only.com\/en\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/expert-only.com\/en\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/expert-only.com\/en\/wp-json\/wp\/v2\/comments?post=8649"}],"version-history":[{"count":13,"href":"https:\/\/expert-only.com\/en\/wp-json\/wp\/v2\/posts\/8649\/revisions"}],"predecessor-version":[{"id":30537,"href":"https:\/\/expert-only.com\/en\/wp-json\/wp\/v2\/posts\/8649\/revisions\/30537"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/expert-only.com\/en\/wp-json\/wp\/v2\/media\/5503"}],"wp:attachment":[{"href":"https:\/\/expert-only.com\/en\/wp-json\/wp\/v2\/media?parent=8649"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/expert-only.com\/en\/wp-json\/wp\/v2\/categories?post=8649"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/expert-only.com\/en\/wp-json\/wp\/v2\/tags?post=8649"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}