{"id":30545,"date":"2024-03-06T07:26:48","date_gmt":"2024-03-06T06:26:48","guid":{"rendered":"https:\/\/expert-only.com\/?p=30545"},"modified":"2024-03-06T21:47:19","modified_gmt":"2024-03-06T20:47:19","slug":"como-calcular-o-valor-do-mes-anterior-no-power-bi","status":"publish","type":"post","link":"https:\/\/expert-only.com\/pt-pt\/power-bi\/como-calcular-o-valor-do-mes-anterior-no-power-bi\/","title":{"rendered":"Como Calcular o Valor do M\u00eas Anterior no Power BI ?"},"content":{"rendered":"\n<h4 class=\"wp-block-heading has-text-align-left\"><em>Como criar um c\u00e1lculo do valor do m\u00eas anterior usando f\u00f3rmulas DAX no Power BI?<\/em><\/h4>\n\n\n\n<p>Descubra como calcular o valor do m\u00eas anterior no Power BI neste tutorial usando 2 abordagens diferentes. Gestores, contabilistas, assessores financeiros e consultores de Business Intelligence utilizam o Power BI e compara\u00e7\u00f5es mensais extensivamente, como os valores do m\u00eas anterior e do \u00faltimo ano. Para criar estas medidas de compara\u00e7\u00e3o, utilize as fun\u00e7\u00f5es de intelig\u00eancia de tempo DAX dispon\u00edveis no editor DAX. Vamos abordar isto usando a fun\u00e7\u00e3o DAX PREVIOUS MONTH.<\/p>\n\n\n\n<h2 class=\"wp-block-heading\" id=\"h-1-use-a-funcao-previousmonth-no-dax-para-obter-o-mes-anterior\">1. Use a fun\u00e7\u00e3o PREVIOUSMONTH no DAX para obter o m\u00eas anterior<\/h2>\n\n\n\n<p>O objetivo da fun\u00e7\u00e3o DAX PREVIOUSMONTH \u00e9 <strong>recuperar dados do m\u00eas imediatamente anterior com base numa coluna de data especificada<\/strong>. Por exemplo, se tiver dados de vendas e quiser comparar as vendas deste m\u00eas com as do m\u00eas passado, poderia usar <strong><em>PREVIOUSMONTH(&#8216;Tabela'[Data])<\/em><\/strong> numa medida.<\/p>\n\n\n\n<p>Quando aplicada, a fun\u00e7\u00e3o filtra os dados para incluir apenas valores do m\u00eas imediatamente anterior \u00e0 data mais recente na coluna. \u00c9 vital notar que <strong>a fun\u00e7\u00e3o opera dentro do contexto do seu modelo de dados do Power BI<\/strong>. Ou seja, funciona melhor quando tem uma tabela de datas adequada relacionada aos seus dados transacionais. \u00c9 altamente recomendado verificar a configura\u00e7\u00e3o da sua tabela marcada como data.<\/p>\n\n\n\n<h3 class=\"wp-block-heading\" id=\"h-duas-opcoes-disponiveis-usando-formulas-dax-para-este-calculo\">Duas op\u00e7\u00f5es dispon\u00edveis usando f\u00f3rmulas DAX para este c\u00e1lculo<\/h3>\n\n\n\n<p>Vamos considerar a tabela de vendas com vendas armazenadas por m\u00eas, por ano e o n\u00famero do cliente. Al\u00e9m disso, para qualquer fun\u00e7\u00e3o de intelig\u00eancia de tempo no DAX, ou seja, no Power BI ou num modelo Tabular, uma coluna de data deve ser a refer\u00eancia. Considere que tem estas duas colunas dispon\u00edveis no seu modelo de dados:<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li>A coluna Amount de Vendas armazena o n\u00famero de vendas registadas nesse dia.<\/li>\n\n\n\n<li>A coluna de tempo DateKey \u00e9 uma data usada como chave para jun\u00e7\u00f5es no Power BI.<\/li>\n<\/ul>\n\n\n\n<p>Verifique tamb\u00e9m a possibilidade de armazenar o total de vendas de um m\u00eas num \u00fanico dia. Como o 31 de janeiro de 2020 para o m\u00eas de janeiro, por exemplo. De facto, o objetivo \u00e9 introduzir uma chave de data \u00fanica para as fun\u00e7\u00f5es de tempo DAX, para permitir o c\u00e1lculo de vendas do m\u00eas anterior. Para criar a medida, use a <a href=\"https:\/\/docs.microsoft.com\/en-us\/dax\/previousmonth-function-dax\" target=\"_blank\" rel=\"noreferrer noopener\">fun\u00e7\u00e3o DAX do m\u00eas anterior<\/a>, cuja documenta\u00e7\u00e3o e sintaxe oficial est\u00e3o dispon\u00edveis no site da Microsoft.<\/p>\n\n\n\n<h3 class=\"wp-block-heading\" id=\"h-um-pre-requisito-configurar-uma-tabela-de-datas-para-usar-funcoes-de-inteligencia-de-tempo-no-power-bi\">Um pr\u00e9-requisito: configurar uma Tabela de Datas para usar fun\u00e7\u00f5es de intelig\u00eancia de tempo no Power BI<\/h3>\n\n\n\n<p>Para usar eficazmente as fun\u00e7\u00f5es de intelig\u00eancia de tempo no Power BI, um pr\u00e9-requisito \u00e9 configurar uma Tabela de Datas. Esta tabela, apresentando um <strong>intervalo cont\u00ednuo de datas<\/strong>, \u00e9 crucial para realizar an\u00e1lises baseadas no tempo com precis\u00e3o, pois permite ao Power BI aplicar c\u00e1lculos din\u00e2micos sobre v\u00e1rios per\u00edodos, assegurando precis\u00e3o e consist\u00eancia na avalia\u00e7\u00e3o de dados temporais.<\/p>\n\n\n\n<p>\u00c0s vezes, ao construir um modelo, pode encontrar o seguinte erro: <em>&#8220;Falha ao resolver o nome &#8216;REVIOUSMONTH&#8217;. N\u00e3o \u00e9 um nome de tabela, vari\u00e1vel ou fun\u00e7\u00e3o v\u00e1lido.<\/em>&#8221; Para corrigi-lo, verifique novamente a barra de f\u00f3rmulas e os erros destacados, geralmente s\u00e3o erros de sintaxe ou par\u00eanteses faltando, ou seja, erros de desenvolvimento cl\u00e1ssicos. E as mensagens exibidas pelo Power BI s\u00e3o expl\u00edcitas.<\/p>\n\n\n\n<h2 class=\"wp-block-heading\" id=\"h-2-calcular-o-mes-anterior-diretamente-da-fonte-de-dados-do-power-bi\">2. Calcular o m\u00eas anterior diretamente da fonte de dados do Power BI<\/h2>\n\n\n\n<p>Neste primeiro exemplo, use o <strong>Power BI Desktop<\/strong> e um arquivo Power BI (extens\u00e3o pbix) para mapear diretamente a coluna da fonte de dados. E no software de desenvolvimento <strong>Visual Studio<\/strong> para um Modelo Tabular usando 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=\"F\u00f3rmula Power BI para calcular o valor do m\u00eas anterior usando 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>F\u00f3rmula Power BI para calcular o valor do m\u00eas anterior usando DAX<\/em><\/figcaption><\/figure><\/div>\n\n\n<p>E o resultado no relat\u00f3rio Power BI \u00e9 algo como isto:<\/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=\"Relat\u00f3rio Power BI mostrando vendas do \u00faltimo m\u00eas calculadas usando a fun\u00e7\u00e3o de tempo PREVIOUSMONTH\" 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>Relat\u00f3rio Power BI mostrando vendas do \u00faltimo m\u00eas calculadas usando a fun\u00e7\u00e3o de tempo PREVIOUSMONTH<\/em><\/figcaption><\/figure><\/div>\n\n\n<h2 class=\"wp-block-heading\" id=\"h-3-use-dois-niveis-de-formulas-para-obter-o-mes-anterior\">3. Use dois n\u00edveis de f\u00f3rmulas para obter o m\u00eas anterior<\/h2>\n\n\n\n<p>Esta segunda abordagem \u00e9 muito semelhante \u00e0 primeira, mas simplesmente utiliza uma medida j\u00e1 criada. \u00c9 feita em dois passos e usa duas c\u00e1lculos DAX em vez de um. Por exemplo, crie as medidas das vendas do m\u00eas atual com esta f\u00f3rmula DAX.<\/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>Depois, crie a medida de vendas do \u00faltimo m\u00eas usando esta segunda f\u00f3rmula DAX abaixo:<\/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-sobre-o-calculo-do-mes-anterior-no-power-bi\">Sobre o c\u00e1lculo do m\u00eas anterior no Power BI<\/h3>\n\n\n\n<p>Neste tutorial do Power BI, os dois exemplos mostram como \u00e9 f\u00e1cil calcular um valor do m\u00eas anterior no Power BI usando a fun\u00e7\u00e3o de tempo DAX PREVIOUSMONTH. Neste tutorial anterior sobre fun\u00e7\u00f5es DAX, confira <a href=\"https:\/\/expert-only.com\/en\/power-bi\/calculate-ytd-value-in-power-bi\/\">como criar um c\u00e1lculo YTD usando DAX e Power BI<\/a>.<\/p>\n\n\n\n<figure class=\"wp-block-embed aligncenter is-type-wp-embed is-provider-tutoriais-sql-e-ti wp-block-embed-tutoriais-sql-e-ti\"><div class=\"wp-block-embed__wrapper\">\n<blockquote class=\"wp-embedded-content\" data-secret=\"WoSsGF6zhS\"><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; Tutoriais SQL e TI\" src=\"https:\/\/expert-only.com\/en\/power-bi\/calculate-ytd-value-in-power-bi\/embed\/#?secret=4gDqLXGViQ#?secret=WoSsGF6zhS\" data-secret=\"WoSsGF6zhS\" 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>Para calcular o valor do m\u00eas anterior no Power BI, use a fun\u00e7\u00e3o de tempo PREVIOUSMONTH numa f\u00f3rmula DAX. <a class=\"mh-excerpt-more\" href=\"https:\/\/expert-only.com\/pt-pt\/power-bi\/como-calcular-o-valor-do-mes-anterior-no-power-bi\/\" title=\"Como Calcular o Valor do M\u00eas Anterior no Power BI ?\">&#8230;<\/a><\/p>\n<\/div>","protected":false},"author":1,"featured_media":5504,"comment_status":"closed","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[447],"tags":[],"class_list":{"0":"post-30545","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>Como Calcular o Valor do M\u00eas Anterior no Power BI ? DAX<\/title>\n<meta name=\"description\" content=\"Para calcular o valor do m\u00eas anterior no Power BI, utilize a fun\u00e7\u00e3o de tempo PREVIOUSMONTH numa f\u00f3rmula DAX com uma tabela de datas.\" \/>\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\/pt-pt\/power-bi\/como-calcular-o-valor-do-mes-anterior-no-power-bi\/\" \/>\n<meta property=\"og:locale\" content=\"pt_PT\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Como Calcular o Valor do M\u00eas Anterior no Power BI ?\" \/>\n<meta property=\"og:description\" content=\"Para calcular o valor do m\u00eas anterior no Power BI, utilize a fun\u00e7\u00e3o de tempo PREVIOUSMONTH numa f\u00f3rmula DAX com uma tabela de datas.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/expert-only.com\/pt-pt\/power-bi\/como-calcular-o-valor-do-mes-anterior-no-power-bi\/\" \/>\n<meta property=\"og:site_name\" content=\"Tutoriais SQL e TI\" \/>\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:47:19+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=\"Escrito por\" \/>\n\t<meta name=\"twitter:data1\" content=\"Expert-Only\" \/>\n\t<meta name=\"twitter:label2\" content=\"Tempo estimado de leitura\" \/>\n\t<meta name=\"twitter:data2\" content=\"4 minutos\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\/\/expert-only.com\/pt-pt\/power-bi\/como-calcular-o-valor-do-mes-anterior-no-power-bi\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/expert-only.com\/pt-pt\/power-bi\/como-calcular-o-valor-do-mes-anterior-no-power-bi\/\"},\"author\":{\"name\":\"Expert-Only\",\"@id\":\"https:\/\/expert-only.com\/pt-pt\/#\/schema\/person\/406a9576b52944f018739a42046873ef\"},\"headline\":\"Como Calcular o Valor do M\u00eas Anterior no Power BI ?\",\"datePublished\":\"2024-03-06T06:26:48+00:00\",\"dateModified\":\"2024-03-06T20:47:19+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/expert-only.com\/pt-pt\/power-bi\/como-calcular-o-valor-do-mes-anterior-no-power-bi\/\"},\"wordCount\":824,\"publisher\":{\"@id\":\"https:\/\/expert-only.com\/pt-pt\/#organization\"},\"image\":{\"@id\":\"https:\/\/expert-only.com\/pt-pt\/power-bi\/como-calcular-o-valor-do-mes-anterior-no-power-bi\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/expert-only.com\/wp-content\/uploads\/2022\/03\/new-york-g80e1b732a_1920_1080.jpg\",\"articleSection\":[\"Tutoriais Power BI\"],\"inLanguage\":\"pt-PT\"},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/expert-only.com\/pt-pt\/power-bi\/como-calcular-o-valor-do-mes-anterior-no-power-bi\/\",\"url\":\"https:\/\/expert-only.com\/pt-pt\/power-bi\/como-calcular-o-valor-do-mes-anterior-no-power-bi\/\",\"name\":\"Como Calcular o Valor do M\u00eas Anterior no Power BI ? DAX\",\"isPartOf\":{\"@id\":\"https:\/\/expert-only.com\/pt-pt\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/expert-only.com\/pt-pt\/power-bi\/como-calcular-o-valor-do-mes-anterior-no-power-bi\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/expert-only.com\/pt-pt\/power-bi\/como-calcular-o-valor-do-mes-anterior-no-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:47:19+00:00\",\"description\":\"Para calcular o valor do m\u00eas anterior no Power BI, utilize a fun\u00e7\u00e3o de tempo PREVIOUSMONTH numa f\u00f3rmula DAX com uma tabela de datas.\",\"breadcrumb\":{\"@id\":\"https:\/\/expert-only.com\/pt-pt\/power-bi\/como-calcular-o-valor-do-mes-anterior-no-power-bi\/#breadcrumb\"},\"inLanguage\":\"pt-PT\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/expert-only.com\/pt-pt\/power-bi\/como-calcular-o-valor-do-mes-anterior-no-power-bi\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"pt-PT\",\"@id\":\"https:\/\/expert-only.com\/pt-pt\/power-bi\/como-calcular-o-valor-do-mes-anterior-no-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\/pt-pt\/power-bi\/como-calcular-o-valor-do-mes-anterior-no-power-bi\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"pt\",\"item\":\"https:\/\/expert-only.com\/pt-pt\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Como Calcular o Valor do M\u00eas Anterior no Power BI ?\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/expert-only.com\/pt-pt\/#website\",\"url\":\"https:\/\/expert-only.com\/pt-pt\/\",\"name\":\"Tutoriais SQL e TI\",\"description\":\"\",\"publisher\":{\"@id\":\"https:\/\/expert-only.com\/pt-pt\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/expert-only.com\/pt-pt\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"pt-PT\"},{\"@type\":\"Organization\",\"@id\":\"https:\/\/expert-only.com\/pt-pt\/#organization\",\"name\":\"Expert-Only\",\"url\":\"https:\/\/expert-only.com\/pt-pt\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"pt-PT\",\"@id\":\"https:\/\/expert-only.com\/pt-pt\/#\/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\/pt-pt\/#\/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\/pt-pt\/#\/schema\/person\/406a9576b52944f018739a42046873ef\",\"name\":\"Expert-Only\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"pt-PT\",\"@id\":\"https:\/\/expert-only.com\/pt-pt\/#\/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":"Como Calcular o Valor do M\u00eas Anterior no Power BI ? DAX","description":"Para calcular o valor do m\u00eas anterior no Power BI, utilize a fun\u00e7\u00e3o de tempo PREVIOUSMONTH numa f\u00f3rmula DAX com uma tabela de datas.","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\/pt-pt\/power-bi\/como-calcular-o-valor-do-mes-anterior-no-power-bi\/","og_locale":"pt_PT","og_type":"article","og_title":"Como Calcular o Valor do M\u00eas Anterior no Power BI ?","og_description":"Para calcular o valor do m\u00eas anterior no Power BI, utilize a fun\u00e7\u00e3o de tempo PREVIOUSMONTH numa f\u00f3rmula DAX com uma tabela de datas.","og_url":"https:\/\/expert-only.com\/pt-pt\/power-bi\/como-calcular-o-valor-do-mes-anterior-no-power-bi\/","og_site_name":"Tutoriais SQL e TI","article_publisher":"https:\/\/www.facebook.com\/ExpertOnlyCom\/","article_published_time":"2024-03-06T06:26:48+00:00","article_modified_time":"2024-03-06T20:47:19+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":{"Escrito por":"Expert-Only","Tempo estimado de leitura":"4 minutos"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/expert-only.com\/pt-pt\/power-bi\/como-calcular-o-valor-do-mes-anterior-no-power-bi\/#article","isPartOf":{"@id":"https:\/\/expert-only.com\/pt-pt\/power-bi\/como-calcular-o-valor-do-mes-anterior-no-power-bi\/"},"author":{"name":"Expert-Only","@id":"https:\/\/expert-only.com\/pt-pt\/#\/schema\/person\/406a9576b52944f018739a42046873ef"},"headline":"Como Calcular o Valor do M\u00eas Anterior no Power BI ?","datePublished":"2024-03-06T06:26:48+00:00","dateModified":"2024-03-06T20:47:19+00:00","mainEntityOfPage":{"@id":"https:\/\/expert-only.com\/pt-pt\/power-bi\/como-calcular-o-valor-do-mes-anterior-no-power-bi\/"},"wordCount":824,"publisher":{"@id":"https:\/\/expert-only.com\/pt-pt\/#organization"},"image":{"@id":"https:\/\/expert-only.com\/pt-pt\/power-bi\/como-calcular-o-valor-do-mes-anterior-no-power-bi\/#primaryimage"},"thumbnailUrl":"https:\/\/expert-only.com\/wp-content\/uploads\/2022\/03\/new-york-g80e1b732a_1920_1080.jpg","articleSection":["Tutoriais Power BI"],"inLanguage":"pt-PT"},{"@type":"WebPage","@id":"https:\/\/expert-only.com\/pt-pt\/power-bi\/como-calcular-o-valor-do-mes-anterior-no-power-bi\/","url":"https:\/\/expert-only.com\/pt-pt\/power-bi\/como-calcular-o-valor-do-mes-anterior-no-power-bi\/","name":"Como Calcular o Valor do M\u00eas Anterior no Power BI ? DAX","isPartOf":{"@id":"https:\/\/expert-only.com\/pt-pt\/#website"},"primaryImageOfPage":{"@id":"https:\/\/expert-only.com\/pt-pt\/power-bi\/como-calcular-o-valor-do-mes-anterior-no-power-bi\/#primaryimage"},"image":{"@id":"https:\/\/expert-only.com\/pt-pt\/power-bi\/como-calcular-o-valor-do-mes-anterior-no-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:47:19+00:00","description":"Para calcular o valor do m\u00eas anterior no Power BI, utilize a fun\u00e7\u00e3o de tempo PREVIOUSMONTH numa f\u00f3rmula DAX com uma tabela de datas.","breadcrumb":{"@id":"https:\/\/expert-only.com\/pt-pt\/power-bi\/como-calcular-o-valor-do-mes-anterior-no-power-bi\/#breadcrumb"},"inLanguage":"pt-PT","potentialAction":[{"@type":"ReadAction","target":["https:\/\/expert-only.com\/pt-pt\/power-bi\/como-calcular-o-valor-do-mes-anterior-no-power-bi\/"]}]},{"@type":"ImageObject","inLanguage":"pt-PT","@id":"https:\/\/expert-only.com\/pt-pt\/power-bi\/como-calcular-o-valor-do-mes-anterior-no-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\/pt-pt\/power-bi\/como-calcular-o-valor-do-mes-anterior-no-power-bi\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"pt","item":"https:\/\/expert-only.com\/pt-pt\/"},{"@type":"ListItem","position":2,"name":"Como Calcular o Valor do M\u00eas Anterior no Power BI ?"}]},{"@type":"WebSite","@id":"https:\/\/expert-only.com\/pt-pt\/#website","url":"https:\/\/expert-only.com\/pt-pt\/","name":"Tutoriais SQL e TI","description":"","publisher":{"@id":"https:\/\/expert-only.com\/pt-pt\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/expert-only.com\/pt-pt\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"pt-PT"},{"@type":"Organization","@id":"https:\/\/expert-only.com\/pt-pt\/#organization","name":"Expert-Only","url":"https:\/\/expert-only.com\/pt-pt\/","logo":{"@type":"ImageObject","inLanguage":"pt-PT","@id":"https:\/\/expert-only.com\/pt-pt\/#\/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\/pt-pt\/#\/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\/pt-pt\/#\/schema\/person\/406a9576b52944f018739a42046873ef","name":"Expert-Only","image":{"@type":"ImageObject","inLanguage":"pt-PT","@id":"https:\/\/expert-only.com\/pt-pt\/#\/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\/pt-pt\/wp-json\/wp\/v2\/posts\/30545","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/expert-only.com\/pt-pt\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/expert-only.com\/pt-pt\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/expert-only.com\/pt-pt\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/expert-only.com\/pt-pt\/wp-json\/wp\/v2\/comments?post=30545"}],"version-history":[{"count":1,"href":"https:\/\/expert-only.com\/pt-pt\/wp-json\/wp\/v2\/posts\/30545\/revisions"}],"predecessor-version":[{"id":30561,"href":"https:\/\/expert-only.com\/pt-pt\/wp-json\/wp\/v2\/posts\/30545\/revisions\/30561"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/expert-only.com\/pt-pt\/wp-json\/wp\/v2\/media\/5504"}],"wp:attachment":[{"href":"https:\/\/expert-only.com\/pt-pt\/wp-json\/wp\/v2\/media?parent=30545"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/expert-only.com\/pt-pt\/wp-json\/wp\/v2\/categories?post=30545"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/expert-only.com\/pt-pt\/wp-json\/wp\/v2\/tags?post=30545"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}