{"id":30544,"date":"2024-03-06T07:26:48","date_gmt":"2024-03-06T06:26:48","guid":{"rendered":"https:\/\/expert-only.com\/?p=30544"},"modified":"2024-03-06T21:37:07","modified_gmt":"2024-03-06T20:37:07","slug":"como-calcular-el-valor-del-mes-anterior-en-power-bi","status":"publish","type":"post","link":"https:\/\/expert-only.com\/es\/power-bi\/como-calcular-el-valor-del-mes-anterior-en-power-bi\/","title":{"rendered":"C\u00f3mo Calcular el Valor del Mes Anterior en Power BI ?"},"content":{"rendered":"\n<h4 class=\"wp-block-heading has-text-align-left\"><em>C\u00f3mo crear un c\u00e1lculo del valor del mes anterior usando f\u00f3rmulas DAX en Power BI<\/em><\/h4>\n\n\n\n<p>Descubre c\u00f3mo calcular el valor del mes anterior en Power BI en este tutorial utilizando 2 enfoques diferentes. Gerentes, contadores, asesores financieros y consultores de Inteligencia de Negocios utilizan Power BI y comparaciones mensuales extensivamente, como los valores del mes anterior y los valores del \u00faltimo a\u00f1o. Para crear estas medidas de comparaci\u00f3n, utiliza las funciones de inteligencia de tiempo DAX disponibles en el editor DAX. Abordemos esto usando la funci\u00f3n DAX PREVIOUS MONTH.<\/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\/es\/power-bi\/como-calcular-el-valor-del-mes-anterior-en-power-bi\/#1-utiliza-la-funcion-previousmonth-en-dax-para-calcular-el-mes-anterior\" >1. Utiliza la funci\u00f3n PREVIOUSMONTH en DAX para calcular el mes anterior<\/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\/es\/power-bi\/como-calcular-el-valor-del-mes-anterior-en-power-bi\/#2-calcula-el-mes-anterior-directamente-desde-la-fuente-de-datos-de-power-bi\" >2. Calcula el mes anterior directamente desde la fuente de datos de Power BI<\/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\/es\/power-bi\/como-calcular-el-valor-del-mes-anterior-en-power-bi\/#3-utiliza-dos-niveles-de-formulas-para-obtener-el-mes-anterior\" >3. Utiliza dos niveles de f\u00f3rmulas para obtener el mes anterior<\/a><\/li><\/ul><\/nav><\/div>\n<h2 class=\"wp-block-heading\" id=\"h-1-utiliza-la-funcion-previousmonth-en-dax-para-calcular-el-mes-anterior\"><span class=\"ez-toc-section\" id=\"1-utiliza-la-funcion-previousmonth-en-dax-para-calcular-el-mes-anterior\"><\/span>1. Utiliza la funci\u00f3n PREVIOUSMONTH en DAX para calcular el mes anterior<span class=\"ez-toc-section-end\"><\/span><\/h2>\n\n\n\n<p>El objetivo de la funci\u00f3n DAX PREVIOUSMONTH es <strong>recuperar datos del mes inmediatamente anterior basado en una columna de fecha especificada<\/strong>. Por ejemplo, si tienes datos de ventas y quieres comparar las ventas de este mes con las del mes pasado, podr\u00edas usar <strong><em>PREVIOUSMONTH(&#8216;Table'[Date])<\/em><\/strong> dentro de una medida.<\/p>\n\n\n\n<p>Al aplicarse, la funci\u00f3n filtra los datos para incluir solo valores del mes inmediatamente anterior a la \u00faltima fecha en la columna. Es vital notar que <strong>la funci\u00f3n opera dentro del contexto de tu modelo de datos de Power BI<\/strong>. En otras palabras, funciona mejor cuando tienes una tabla de fechas adecuada relacionada con tus datos transaccionales. Recomiendo encarecidamente verificar la configuraci\u00f3n de tu tabla marcada como fecha.<\/p>\n\n\n\n<h3 class=\"wp-block-heading\" id=\"h-dos-opciones-disponibles-usando-formulas-dax-para-este-calculo\">Dos opciones disponibles usando f\u00f3rmulas DAX para este c\u00e1lculo<\/h3>\n\n\n\n<p>Consideremos la tabla de ventas con ventas almacenadas por mes, por a\u00f1o y el n\u00famero de cliente. Adem\u00e1s, para cualquier funci\u00f3n de inteligencia de tiempo en DAX, es decir, en Power BI o en un modelo Tabular, una columna de fecha debe ser la referencia. Consideremos que tienes estas dos columnas disponibles en tu modelo de datos:<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li>La columna de Cantidad de Ventas almacena el n\u00famero de ventas registradas ese d\u00eda.<\/li>\n\n\n\n<li>La columna de clave de tiempo Fecha es una fecha utilizada como la clave para las uniones de Power BI.<\/li>\n<\/ul>\n\n\n\n<p>Considera tambi\u00e9n la posibilidad de almacenar el total de ventas de un mes en un d\u00eda \u00fanico. Como el 31 de enero de 2020 para el mes de enero, por ejemplo. De hecho, el objetivo es introducir una clave de fecha \u00fanica para las funciones de tiempo DAX, para habilitar el c\u00e1lculo de ventas del mes anterior. Para crear la medida, utiliza la <a href=\"https:\/\/docs.microsoft.com\/en-us\/dax\/previousmonth-function-dax\" target=\"_blank\" rel=\"noreferrer noopener\">funci\u00f3n DAX del mes anterior<\/a>, su documentaci\u00f3n oficial y sintaxis est\u00e1n disponibles en el sitio web de Microsoft.<\/p>\n\n\n\n<h3 class=\"wp-block-heading\" id=\"h-un-requisito-previo-configurar-una-tabla-de-fecha-para-usar-funciones-de-inteligencia-de-tiempo-en-power-bi\">Un requisito previo: configurar una Tabla de Fecha para usar funciones de inteligencia de tiempo en Power BI<\/h3>\n\n\n\n<p>Para usar efectivamente las funciones de inteligencia de tiempo en Power BI, un requisito previo es configurar una Tabla de Fecha. Esta tabla, que presenta un <strong>rango continuo de fechas<\/strong>, es crucial para realizar an\u00e1lisis temporales precisos, ya que permite a Power BI aplicar c\u00e1lculos din\u00e1micos sobre varios per\u00edodos, asegurando precisi\u00f3n y consistencia en la evaluaci\u00f3n de datos temporales.<\/p>\n\n\n\n<h2 class=\"wp-block-heading\" id=\"h-2-calcula-el-mes-anterior-directamente-desde-la-fuente-de-datos-de-power-bi\"><span class=\"ez-toc-section\" id=\"2-calcula-el-mes-anterior-directamente-desde-la-fuente-de-datos-de-power-bi\"><\/span>2. Calcula el mes anterior directamente desde la fuente de datos de Power BI<span class=\"ez-toc-section-end\"><\/span><\/h2>\n\n\n\n<p>En este primer ejemplo, utiliza <strong>Power BI Desktop<\/strong> y un archivo de Power BI (extensi\u00f3n pbix) para mapear directamente la columna desde la fuente de datos. Y en el software de desarrollo <strong>Visual Studio<\/strong> para un 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=\"\">Ventas del \u00daltimo Mes = \nCALCULATE (\n    SUM ( ventas[ventas] ),\n    PREVIOUSMONTH ( 'tiempo'[clave_fecha]),\n    REMOVEFILTERS ( ventas )\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 de Power BI para calcular el valor del mes 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 de Power BI para calcular el valor del mes anterior usando DAX<\/em><\/figcaption><\/figure><\/div>\n\n\n<p>Y el resultado en el informe de Power BI es algo as\u00ed:<\/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=\"Informe de Power BI que muestra las ventas del \u00faltimo mes calculadas usando la funci\u00f3n de tiempo 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>Informe de Power BI que muestra las ventas del \u00faltimo mes calculadas usando la funci\u00f3n de tiempo PREVIOUSMONTH<\/em><\/figcaption><\/figure><\/div>\n\n\n<h2 class=\"wp-block-heading\" id=\"h-3-utiliza-dos-niveles-de-formulas-para-obtener-el-mes-anterior\"><span class=\"ez-toc-section\" id=\"3-utiliza-dos-niveles-de-formulas-para-obtener-el-mes-anterior\"><\/span>3. Utiliza dos niveles de f\u00f3rmulas para obtener el mes anterior<span class=\"ez-toc-section-end\"><\/span><\/h2>\n\n\n\n<p>Este segundo enfoque es muy similar al primero, pero simplemente usa una medida ya creada. Se realiza en dos pasos y utiliza dos c\u00e1lculos DAX en lugar de uno. Por ejemplo, crea las medidas de las ventas del mes actual con 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=\"\">Ventas := SUM('ventas'[CantidadVentas])<\/pre>\n\n\n\n<p>Luego crea la medida de ventas del \u00faltimo mes usando esta segunda f\u00f3rmula DAX a continuaci\u00f3n:<\/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=\"\">Ventas del \u00daltimo Mes = \nCALCULATE (\n    ventas[ventas],\n    PREVIOUSMONTH ( 'tiempo'[clave_fecha]),\n    REMOVEFILTERS ( ventas )\n)<\/pre>\n\n\n\n<h3 class=\"wp-block-heading\" id=\"h-acerca-del-calculo-del-mes-anterior-en-power-bi-y-dax\">Acerca del c\u00e1lculo del mes anterior en Power BI y DAX<\/h3>\n\n\n\n<p>En este tutorial de Power BI, los dos ejemplos muestran lo f\u00e1cil que es calcular el valor del mes anterior en Power BI usando la funci\u00f3n de tiempo DAX PREVIOUSMONTH. En este tutorial anterior sobre funciones DAX, consulta <a href=\"https:\/\/expert-only.com\/en\/power-bi\/calculate-ytd-value-in-power-bi\/\">c\u00f3mo crear un c\u00e1lculo YTD usando DAX y Power BI<\/a>.<\/p>\n\n\n\n<figure class=\"wp-block-embed aligncenter is-type-wp-embed is-provider-tutoriales-de-sql-y-ti wp-block-embed-tutoriales-de-sql-y-ti\"><div class=\"wp-block-embed__wrapper\">\n<blockquote class=\"wp-embedded-content\" data-secret=\"ZwQcL0A6A5\"><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=\"\u00abHow to calculate a YTD value with Power BI?\u00bb \u2014 Tutoriales de SQL y TI\" src=\"https:\/\/expert-only.com\/en\/power-bi\/calculate-ytd-value-in-power-bi\/embed\/#?secret=2XROVclSQS#?secret=ZwQcL0A6A5\" data-secret=\"ZwQcL0A6A5\" 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 el valor del mes anterior en Power BI, usa la funci\u00f3n de tiempo PREVIOUSMONTH en una f\u00f3rmula DAX. <a class=\"mh-excerpt-more\" href=\"https:\/\/expert-only.com\/es\/power-bi\/como-calcular-el-valor-del-mes-anterior-en-power-bi\/\" title=\"C\u00f3mo Calcular el Valor del Mes Anterior en Power BI ?\">&#8230;<\/a><\/p>\n<\/div>","protected":false},"author":1,"featured_media":5505,"comment_status":"closed","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[445],"tags":[],"class_list":{"0":"post-30544","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>C\u00f3mo Calcular el Valor del Mes Anterior en Power BI ? DAX<\/title>\n<meta name=\"description\" content=\"Para calcular el valor del mes anterior en Power BI, usa la funci\u00f3n de tiempo PREVIOUSMONTH en una f\u00f3rmula DAX.\" \/>\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\/es\/power-bi\/como-calcular-el-valor-del-mes-anterior-en-power-bi\/\" \/>\n<meta property=\"og:locale\" content=\"es_ES\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"C\u00f3mo Calcular el Valor del Mes Anterior en Power BI ?\" \/>\n<meta property=\"og:description\" content=\"Para calcular el valor del mes anterior en Power BI, usa la funci\u00f3n de tiempo PREVIOUSMONTH en una f\u00f3rmula DAX.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/expert-only.com\/es\/power-bi\/como-calcular-el-valor-del-mes-anterior-en-power-bi\/\" \/>\n<meta property=\"og:site_name\" content=\"Tutoriales de SQL y 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:37:07+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=\"Tiempo de lectura\" \/>\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\/es\/power-bi\/como-calcular-el-valor-del-mes-anterior-en-power-bi\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/expert-only.com\/es\/power-bi\/como-calcular-el-valor-del-mes-anterior-en-power-bi\/\"},\"author\":{\"name\":\"Expert-Only\",\"@id\":\"https:\/\/expert-only.com\/es\/#\/schema\/person\/406a9576b52944f018739a42046873ef\"},\"headline\":\"C\u00f3mo Calcular el Valor del Mes Anterior en Power BI ?\",\"datePublished\":\"2024-03-06T06:26:48+00:00\",\"dateModified\":\"2024-03-06T20:37:07+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/expert-only.com\/es\/power-bi\/como-calcular-el-valor-del-mes-anterior-en-power-bi\/\"},\"wordCount\":761,\"publisher\":{\"@id\":\"https:\/\/expert-only.com\/es\/#organization\"},\"image\":{\"@id\":\"https:\/\/expert-only.com\/es\/power-bi\/como-calcular-el-valor-del-mes-anterior-en-power-bi\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/expert-only.com\/wp-content\/uploads\/2022\/03\/new-york-g80e1b732a_1920_1080.jpg\",\"articleSection\":[\"Power BI\"],\"inLanguage\":\"es\"},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/expert-only.com\/es\/power-bi\/como-calcular-el-valor-del-mes-anterior-en-power-bi\/\",\"url\":\"https:\/\/expert-only.com\/es\/power-bi\/como-calcular-el-valor-del-mes-anterior-en-power-bi\/\",\"name\":\"C\u00f3mo Calcular el Valor del Mes Anterior en Power BI ? DAX\",\"isPartOf\":{\"@id\":\"https:\/\/expert-only.com\/es\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/expert-only.com\/es\/power-bi\/como-calcular-el-valor-del-mes-anterior-en-power-bi\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/expert-only.com\/es\/power-bi\/como-calcular-el-valor-del-mes-anterior-en-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:37:07+00:00\",\"description\":\"Para calcular el valor del mes anterior en Power BI, usa la funci\u00f3n de tiempo PREVIOUSMONTH en una f\u00f3rmula DAX.\",\"breadcrumb\":{\"@id\":\"https:\/\/expert-only.com\/es\/power-bi\/como-calcular-el-valor-del-mes-anterior-en-power-bi\/#breadcrumb\"},\"inLanguage\":\"es\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/expert-only.com\/es\/power-bi\/como-calcular-el-valor-del-mes-anterior-en-power-bi\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"es\",\"@id\":\"https:\/\/expert-only.com\/es\/power-bi\/como-calcular-el-valor-del-mes-anterior-en-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\/es\/power-bi\/como-calcular-el-valor-del-mes-anterior-en-power-bi\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"es\",\"item\":\"https:\/\/expert-only.com\/es\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"C\u00f3mo Calcular el Valor del Mes Anterior en Power BI ?\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/expert-only.com\/es\/#website\",\"url\":\"https:\/\/expert-only.com\/es\/\",\"name\":\"Tutoriales de SQL y TI\",\"description\":\"\",\"publisher\":{\"@id\":\"https:\/\/expert-only.com\/es\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/expert-only.com\/es\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"es\"},{\"@type\":\"Organization\",\"@id\":\"https:\/\/expert-only.com\/es\/#organization\",\"name\":\"Expert-Only\",\"url\":\"https:\/\/expert-only.com\/es\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"es\",\"@id\":\"https:\/\/expert-only.com\/es\/#\/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\/es\/#\/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\/es\/#\/schema\/person\/406a9576b52944f018739a42046873ef\",\"name\":\"Expert-Only\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"es\",\"@id\":\"https:\/\/expert-only.com\/es\/#\/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":"C\u00f3mo Calcular el Valor del Mes Anterior en Power BI ? DAX","description":"Para calcular el valor del mes anterior en Power BI, usa la funci\u00f3n de tiempo PREVIOUSMONTH en una f\u00f3rmula DAX.","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\/es\/power-bi\/como-calcular-el-valor-del-mes-anterior-en-power-bi\/","og_locale":"es_ES","og_type":"article","og_title":"C\u00f3mo Calcular el Valor del Mes Anterior en Power BI ?","og_description":"Para calcular el valor del mes anterior en Power BI, usa la funci\u00f3n de tiempo PREVIOUSMONTH en una f\u00f3rmula DAX.","og_url":"https:\/\/expert-only.com\/es\/power-bi\/como-calcular-el-valor-del-mes-anterior-en-power-bi\/","og_site_name":"Tutoriales de SQL y TI","article_publisher":"https:\/\/www.facebook.com\/ExpertOnlyCom\/","article_published_time":"2024-03-06T06:26:48+00:00","article_modified_time":"2024-03-06T20:37:07+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","Tiempo de lectura":"4 minutos"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/expert-only.com\/es\/power-bi\/como-calcular-el-valor-del-mes-anterior-en-power-bi\/#article","isPartOf":{"@id":"https:\/\/expert-only.com\/es\/power-bi\/como-calcular-el-valor-del-mes-anterior-en-power-bi\/"},"author":{"name":"Expert-Only","@id":"https:\/\/expert-only.com\/es\/#\/schema\/person\/406a9576b52944f018739a42046873ef"},"headline":"C\u00f3mo Calcular el Valor del Mes Anterior en Power BI ?","datePublished":"2024-03-06T06:26:48+00:00","dateModified":"2024-03-06T20:37:07+00:00","mainEntityOfPage":{"@id":"https:\/\/expert-only.com\/es\/power-bi\/como-calcular-el-valor-del-mes-anterior-en-power-bi\/"},"wordCount":761,"publisher":{"@id":"https:\/\/expert-only.com\/es\/#organization"},"image":{"@id":"https:\/\/expert-only.com\/es\/power-bi\/como-calcular-el-valor-del-mes-anterior-en-power-bi\/#primaryimage"},"thumbnailUrl":"https:\/\/expert-only.com\/wp-content\/uploads\/2022\/03\/new-york-g80e1b732a_1920_1080.jpg","articleSection":["Power BI"],"inLanguage":"es"},{"@type":"WebPage","@id":"https:\/\/expert-only.com\/es\/power-bi\/como-calcular-el-valor-del-mes-anterior-en-power-bi\/","url":"https:\/\/expert-only.com\/es\/power-bi\/como-calcular-el-valor-del-mes-anterior-en-power-bi\/","name":"C\u00f3mo Calcular el Valor del Mes Anterior en Power BI ? DAX","isPartOf":{"@id":"https:\/\/expert-only.com\/es\/#website"},"primaryImageOfPage":{"@id":"https:\/\/expert-only.com\/es\/power-bi\/como-calcular-el-valor-del-mes-anterior-en-power-bi\/#primaryimage"},"image":{"@id":"https:\/\/expert-only.com\/es\/power-bi\/como-calcular-el-valor-del-mes-anterior-en-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:37:07+00:00","description":"Para calcular el valor del mes anterior en Power BI, usa la funci\u00f3n de tiempo PREVIOUSMONTH en una f\u00f3rmula DAX.","breadcrumb":{"@id":"https:\/\/expert-only.com\/es\/power-bi\/como-calcular-el-valor-del-mes-anterior-en-power-bi\/#breadcrumb"},"inLanguage":"es","potentialAction":[{"@type":"ReadAction","target":["https:\/\/expert-only.com\/es\/power-bi\/como-calcular-el-valor-del-mes-anterior-en-power-bi\/"]}]},{"@type":"ImageObject","inLanguage":"es","@id":"https:\/\/expert-only.com\/es\/power-bi\/como-calcular-el-valor-del-mes-anterior-en-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\/es\/power-bi\/como-calcular-el-valor-del-mes-anterior-en-power-bi\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"es","item":"https:\/\/expert-only.com\/es\/"},{"@type":"ListItem","position":2,"name":"C\u00f3mo Calcular el Valor del Mes Anterior en Power BI ?"}]},{"@type":"WebSite","@id":"https:\/\/expert-only.com\/es\/#website","url":"https:\/\/expert-only.com\/es\/","name":"Tutoriales de SQL y TI","description":"","publisher":{"@id":"https:\/\/expert-only.com\/es\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/expert-only.com\/es\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"es"},{"@type":"Organization","@id":"https:\/\/expert-only.com\/es\/#organization","name":"Expert-Only","url":"https:\/\/expert-only.com\/es\/","logo":{"@type":"ImageObject","inLanguage":"es","@id":"https:\/\/expert-only.com\/es\/#\/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\/es\/#\/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\/es\/#\/schema\/person\/406a9576b52944f018739a42046873ef","name":"Expert-Only","image":{"@type":"ImageObject","inLanguage":"es","@id":"https:\/\/expert-only.com\/es\/#\/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\/es\/wp-json\/wp\/v2\/posts\/30544","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/expert-only.com\/es\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/expert-only.com\/es\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/expert-only.com\/es\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/expert-only.com\/es\/wp-json\/wp\/v2\/comments?post=30544"}],"version-history":[{"count":1,"href":"https:\/\/expert-only.com\/es\/wp-json\/wp\/v2\/posts\/30544\/revisions"}],"predecessor-version":[{"id":30556,"href":"https:\/\/expert-only.com\/es\/wp-json\/wp\/v2\/posts\/30544\/revisions\/30556"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/expert-only.com\/es\/wp-json\/wp\/v2\/media\/5505"}],"wp:attachment":[{"href":"https:\/\/expert-only.com\/es\/wp-json\/wp\/v2\/media?parent=30544"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/expert-only.com\/es\/wp-json\/wp\/v2\/categories?post=30544"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/expert-only.com\/es\/wp-json\/wp\/v2\/tags?post=30544"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}