{"id":26148,"date":"2023-06-19T06:33:00","date_gmt":"2023-06-19T04:33:00","guid":{"rendered":"https:\/\/expert-only.com\/?p=26148"},"modified":"2023-07-06T16:09:07","modified_gmt":"2023-07-06T14:09:07","slug":"valor-del-ultimo-ano-con-power-bi","status":"publish","type":"post","link":"https:\/\/expert-only.com\/es\/power-bi\/valor-del-ultimo-ano-con-power-bi\/","title":{"rendered":"\u00bfC\u00f3mo calcular el valor del \u00faltimo a\u00f1o con Power BI y DAX?"},"content":{"rendered":"\n<h4 class=\"wp-block-heading has-text-align-center\"><strong><em>Con Power BI, \u00bfc\u00f3mo calcular el valor del a\u00f1o anterior en DAX?<\/em><\/strong><\/h4>\n\n\n\n<p>Para calcular el valor del \u00faltimo a\u00f1o en una f\u00f3rmula de Power BI, basta con utilizar las dos funciones DAX CALCULAR disponibles combinadas con la funci\u00f3n A\u00d1O ANTERIOR. En los cuadros de mando e informes financieros, utilice el valor del a\u00f1o anterior para la comparaci\u00f3n y el c\u00e1lculo de la varianza con el a\u00f1o en curso. De hecho, el an\u00e1lisis de las cifras financieras se basa a menudo en la comparaci\u00f3n temporal y las previsiones m\u00f3viles. Las previsiones financieras utilizan meses, trimestres o a\u00f1os m\u00f3viles.<\/p>\n\n\n\n<h2 class=\"wp-block-heading\" id=\"h-calcular-el-total-del-ultimo-ano-directamente-desde-la-columna-de-origen-en-dax\">Calcular el total del \u00faltimo a\u00f1o directamente desde la columna de origen en DAX<\/h2>\n\n\n\n<p>La primera opci\u00f3n es utilizar directamente el valor de una columna existente de la tabla de origen. El desarrollador o usuario de negocio importa la columna existente en un Modelo Tabular o Power BI.<\/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 Year := CALCULATE(SUM('ShopSales'[SalesAmount]), PREVIOUSYEAR('Time'[DateKey]))<\/pre>\n\n\n\n<h2 class=\"wp-block-heading\" id=\"h-mostrar-el-importe-del-ano-anterior-utilizando-otra-medida-del-modelo-de-power-bi\">Mostrar el importe del a\u00f1o anterior utilizando otra medida del modelo de Power BI<\/h2>\n\n\n\n<p>La segunda opci\u00f3n es utilizar otra medida DAX y utilizarla como fuente, como en el siguiente ejemplo de 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 Last Year := CALCULATE([Sales], PREVIOUSYEAR('Time'[DateKey]))<\/pre>\n\n\n\n<p>Para ir m\u00e1s lejos, el t\u00e9rmino DAX significa Expresi\u00f3n de An\u00e1lisis de Datos y es un lenguaje de Microsoft. Por ejemplo, PowerPivot, los informes y cuadros de mando de Power BI y tambi\u00e9n los modelos tabulares utilizan el lenguaje DAX. Consulte la documentaci\u00f3n detallada de las dos funciones de este art\u00edculo en el sitio web oficial de Power BI:<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li>La documentaci\u00f3n oficial de la funci\u00f3n <a href=\"https:\/\/learn.microsoft.com\/es-es\/dax\/calculate-function-dax\" target=\"_blank\" rel=\"noreferrer noopener\">CALCULATE function<\/a>.<\/li>\n\n\n\n<li>Y la documentaci\u00f3n oficial de la funci\u00f3n <a href=\"https:\/\/learn.microsoft.com\/es-es\/dax\/previousyear-function-dax\" target=\"_blank\" rel=\"noreferrer noopener nofollow\">PREVIOUSYEAR function<\/a>.<\/li>\n<\/ul>\n\n\n\n<p>Este art\u00edculo trata sobre el c\u00e1lculo del valor del \u00faltimo a\u00f1o con Power BI y una formula DAX, pero tambi\u00e9n se aplica a la creaci\u00f3n de medidas de tiempo en un modelo tabular de Analysis Services. Por ejemplo, es posible tambi\u00e9n <a href=\"https:\/\/expert-only.com\/en\/power-bi\/power-bi-previous-month-value\/\">calcular el valor del \u00faltimo mes con DAX<\/a>.<\/p>\n\n\n\n<h3 class=\"wp-block-heading\" id=\"h-consulte-estas-preguntas-frecuentes-sobre-dax-y-power-bi\"><strong>Consulte estas preguntas frecuentes sobre DAX y Power BI<\/strong><\/h3>\n\n\n\n<div class=\"schema-faq wp-block-yoast-faq-block\"><div class=\"schema-faq-section\" id=\"faq-question-1598373676095\"><strong class=\"schema-faq-question\">\u00bfSe calcula autom\u00e1ticamente el total de ventas del \u00faltimo a\u00f1o en Power BI?<\/strong> <p class=\"schema-faq-answer\">Por defecto, el software no calcula autom\u00e1ticamente el total de ventas del a\u00f1o anterior. Sin embargo, DAX para Power BI permite crear una medida utilizando funciones temporales para calcular las ventas del a\u00f1o anterior.<\/p> <\/div> <div class=\"schema-faq-section\" id=\"faq-question-1598373709032\"><strong class=\"schema-faq-question\">\u00bfCu\u00e1les son las opciones para calcular el a\u00f1o anterior en DAX?<\/strong> <p class=\"schema-faq-answer\">En Power BI hay muchas opciones para calcular nuevas medidas, incluidas las que tienen funciones temporales. Utilice la columna base mapeada desde una tabla u otras medidas.<\/p> <\/div> <div class=\"schema-faq-section\" id=\"faq-question-1598373727551\"><strong class=\"schema-faq-question\">\u00bfCu\u00e1l es la diferencia entre los lenguajes DAX y MDX?<\/strong> <p class=\"schema-faq-answer\">DAX significa Expresiones de An\u00e1lisis de Datos, y se utiliza para crear medidas y c\u00e1lculos para Power BI y Power BI. Por ejemplo, los cubos de Analysis Services contienen c\u00f3digo MDX.<\/p> <\/div> <div class=\"schema-faq-section\" id=\"faq-question-1598373752771\"><strong class=\"schema-faq-question\">\u00bfCu\u00e1l es la funci\u00f3n DAX para el \u00faltimo a\u00f1o?<\/strong> <p class=\"schema-faq-answer\">La funci\u00f3n DAX para calcular el \u00faltimo a\u00f1o es la funci\u00f3n PREVIOUSYEAR incorporada en Power BI, que devuelve todas las fechas hasta el a\u00f1o proporcionado como par\u00e1metro de entrada.<\/p> <\/div> <\/div>\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\">\nhttps:\/\/expert-only.com\/en\/power-bi\/power-bi-previous-month-value\/\n<\/div><\/figure>\n","protected":false},"excerpt":{"rendered":"<div class=\"mh-excerpt\"><p>Con Power BI, \u00bfc\u00f3mo calcular el valor del a\u00f1o anterior en DAX? Para calcular el valor del \u00faltimo a\u00f1o en una f\u00f3rmula de Power BI, basta con utilizar las dos funciones DAX CALCULAR disponibles combinadas con la funci\u00f3n A\u00d1O <a class=\"mh-excerpt-more\" href=\"https:\/\/expert-only.com\/es\/power-bi\/valor-del-ultimo-ano-con-power-bi\/\" title=\"\u00bfC\u00f3mo calcular el valor del \u00faltimo a\u00f1o con Power BI y DAX?\">&#8230;<\/a><\/p>\n<\/div>","protected":false},"author":1,"featured_media":10951,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[445],"tags":[],"class_list":{"0":"post-26148","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>Valor del \u00faltimo a\u00f1o con Power BI - Microsoft BI<\/title>\n<meta name=\"description\" content=\"Para calcular el valor del \u00faltimo a\u00f1o con Power BI y DAX, siga este ejemplo utilizando las funciones CALCULAR y PREVIOUSYEAR combinadas.\" \/>\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\/valor-del-ultimo-ano-con-power-bi\/\" \/>\n<meta property=\"og:locale\" content=\"es_ES\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"\u00bfC\u00f3mo calcular el valor del \u00faltimo a\u00f1o con Power BI y DAX?\" \/>\n<meta property=\"og:description\" content=\"Para calcular el valor del \u00faltimo a\u00f1o con Power BI y DAX, siga este ejemplo utilizando las funciones CALCULAR y PREVIOUSYEAR combinadas.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/expert-only.com\/es\/power-bi\/valor-del-ultimo-ano-con-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=\"2023-06-19T04:33:00+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2023-07-06T14:09:07+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/expert-only.com\/wp-content\/uploads\/2022\/09\/working-at-night-E575151C571_1920x1080.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=\"3 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\/valor-del-ultimo-ano-con-power-bi\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/expert-only.com\/es\/power-bi\/valor-del-ultimo-ano-con-power-bi\/\"},\"author\":{\"name\":\"Expert-Only\",\"@id\":\"https:\/\/expert-only.com\/es\/#\/schema\/person\/406a9576b52944f018739a42046873ef\"},\"headline\":\"\u00bfC\u00f3mo calcular el valor del \u00faltimo a\u00f1o con Power BI y DAX?\",\"datePublished\":\"2023-06-19T04:33:00+00:00\",\"dateModified\":\"2023-07-06T14:09:07+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/expert-only.com\/es\/power-bi\/valor-del-ultimo-ano-con-power-bi\/\"},\"wordCount\":553,\"commentCount\":0,\"publisher\":{\"@id\":\"https:\/\/expert-only.com\/es\/#organization\"},\"image\":{\"@id\":\"https:\/\/expert-only.com\/es\/power-bi\/valor-del-ultimo-ano-con-power-bi\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/expert-only.com\/wp-content\/uploads\/2022\/09\/working-at-night-E575151C571_1920x1080.jpg\",\"articleSection\":[\"Power BI\"],\"inLanguage\":\"es\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\/\/expert-only.com\/es\/power-bi\/valor-del-ultimo-ano-con-power-bi\/#respond\"]}]},{\"@type\":[\"WebPage\",\"FAQPage\"],\"@id\":\"https:\/\/expert-only.com\/es\/power-bi\/valor-del-ultimo-ano-con-power-bi\/\",\"url\":\"https:\/\/expert-only.com\/es\/power-bi\/valor-del-ultimo-ano-con-power-bi\/\",\"name\":\"Valor del \u00faltimo a\u00f1o con Power BI - Microsoft BI\",\"isPartOf\":{\"@id\":\"https:\/\/expert-only.com\/es\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/expert-only.com\/es\/power-bi\/valor-del-ultimo-ano-con-power-bi\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/expert-only.com\/es\/power-bi\/valor-del-ultimo-ano-con-power-bi\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/expert-only.com\/wp-content\/uploads\/2022\/09\/working-at-night-E575151C571_1920x1080.jpg\",\"datePublished\":\"2023-06-19T04:33:00+00:00\",\"dateModified\":\"2023-07-06T14:09:07+00:00\",\"description\":\"Para calcular el valor del \u00faltimo a\u00f1o con Power BI y DAX, siga este ejemplo utilizando las funciones CALCULAR y PREVIOUSYEAR combinadas.\",\"breadcrumb\":{\"@id\":\"https:\/\/expert-only.com\/es\/power-bi\/valor-del-ultimo-ano-con-power-bi\/#breadcrumb\"},\"mainEntity\":[{\"@id\":\"https:\/\/expert-only.com\/es\/power-bi\/valor-del-ultimo-ano-con-power-bi\/#faq-question-1598373676095\"},{\"@id\":\"https:\/\/expert-only.com\/es\/power-bi\/valor-del-ultimo-ano-con-power-bi\/#faq-question-1598373709032\"},{\"@id\":\"https:\/\/expert-only.com\/es\/power-bi\/valor-del-ultimo-ano-con-power-bi\/#faq-question-1598373727551\"},{\"@id\":\"https:\/\/expert-only.com\/es\/power-bi\/valor-del-ultimo-ano-con-power-bi\/#faq-question-1598373752771\"}],\"inLanguage\":\"es\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/expert-only.com\/es\/power-bi\/valor-del-ultimo-ano-con-power-bi\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"es\",\"@id\":\"https:\/\/expert-only.com\/es\/power-bi\/valor-del-ultimo-ano-con-power-bi\/#primaryimage\",\"url\":\"https:\/\/expert-only.com\/wp-content\/uploads\/2022\/09\/working-at-night-E575151C571_1920x1080.jpg\",\"contentUrl\":\"https:\/\/expert-only.com\/wp-content\/uploads\/2022\/09\/working-at-night-E575151C571_1920x1080.jpg\",\"width\":1920,\"height\":1080},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/expert-only.com\/es\/power-bi\/valor-del-ultimo-ano-con-power-bi\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"es\",\"item\":\"https:\/\/expert-only.com\/es\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"\u00bfC\u00f3mo calcular el valor del \u00faltimo a\u00f1o con Power BI y DAX?\"}]},{\"@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\"}},{\"@type\":\"Question\",\"@id\":\"https:\/\/expert-only.com\/es\/power-bi\/valor-del-ultimo-ano-con-power-bi\/#faq-question-1598373676095\",\"position\":1,\"url\":\"https:\/\/expert-only.com\/es\/power-bi\/valor-del-ultimo-ano-con-power-bi\/#faq-question-1598373676095\",\"name\":\"\u00bfSe calcula autom\u00e1ticamente el total de ventas del \u00faltimo a\u00f1o en Power BI?\",\"answerCount\":1,\"acceptedAnswer\":{\"@type\":\"Answer\",\"text\":\"Por defecto, el software no calcula autom\u00e1ticamente el total de ventas del a\u00f1o anterior. Sin embargo, DAX para Power BI permite crear una medida utilizando funciones temporales para calcular las ventas del a\u00f1o anterior.\",\"inLanguage\":\"es\"},\"inLanguage\":\"es\"},{\"@type\":\"Question\",\"@id\":\"https:\/\/expert-only.com\/es\/power-bi\/valor-del-ultimo-ano-con-power-bi\/#faq-question-1598373709032\",\"position\":2,\"url\":\"https:\/\/expert-only.com\/es\/power-bi\/valor-del-ultimo-ano-con-power-bi\/#faq-question-1598373709032\",\"name\":\"\u00bfCu\u00e1les son las opciones para calcular el a\u00f1o anterior en DAX?\",\"answerCount\":1,\"acceptedAnswer\":{\"@type\":\"Answer\",\"text\":\"En Power BI hay muchas opciones para calcular nuevas medidas, incluidas las que tienen funciones temporales. Utilice la columna base mapeada desde una tabla u otras medidas.\",\"inLanguage\":\"es\"},\"inLanguage\":\"es\"},{\"@type\":\"Question\",\"@id\":\"https:\/\/expert-only.com\/es\/power-bi\/valor-del-ultimo-ano-con-power-bi\/#faq-question-1598373727551\",\"position\":3,\"url\":\"https:\/\/expert-only.com\/es\/power-bi\/valor-del-ultimo-ano-con-power-bi\/#faq-question-1598373727551\",\"name\":\"\u00bfCu\u00e1l es la diferencia entre los lenguajes DAX y MDX?\",\"answerCount\":1,\"acceptedAnswer\":{\"@type\":\"Answer\",\"text\":\"DAX significa Expresiones de An\u00e1lisis de Datos, y se utiliza para crear medidas y c\u00e1lculos para Power BI y Power BI. Por ejemplo, los cubos de Analysis Services contienen c\u00f3digo MDX.\",\"inLanguage\":\"es\"},\"inLanguage\":\"es\"},{\"@type\":\"Question\",\"@id\":\"https:\/\/expert-only.com\/es\/power-bi\/valor-del-ultimo-ano-con-power-bi\/#faq-question-1598373752771\",\"position\":4,\"url\":\"https:\/\/expert-only.com\/es\/power-bi\/valor-del-ultimo-ano-con-power-bi\/#faq-question-1598373752771\",\"name\":\"\u00bfCu\u00e1l es la funci\u00f3n DAX para el \u00faltimo a\u00f1o?\",\"answerCount\":1,\"acceptedAnswer\":{\"@type\":\"Answer\",\"text\":\"La funci\u00f3n DAX para calcular el \u00faltimo a\u00f1o es la funci\u00f3n PREVIOUSYEAR incorporada en Power BI, que devuelve todas las fechas hasta el a\u00f1o proporcionado como par\u00e1metro de entrada.\",\"inLanguage\":\"es\"},\"inLanguage\":\"es\"}]}<\/script>\n<!-- \/ Yoast SEO Premium plugin. -->","yoast_head_json":{"title":"Valor del \u00faltimo a\u00f1o con Power BI - Microsoft BI","description":"Para calcular el valor del \u00faltimo a\u00f1o con Power BI y DAX, siga este ejemplo utilizando las funciones CALCULAR y PREVIOUSYEAR combinadas.","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\/valor-del-ultimo-ano-con-power-bi\/","og_locale":"es_ES","og_type":"article","og_title":"\u00bfC\u00f3mo calcular el valor del \u00faltimo a\u00f1o con Power BI y DAX?","og_description":"Para calcular el valor del \u00faltimo a\u00f1o con Power BI y DAX, siga este ejemplo utilizando las funciones CALCULAR y PREVIOUSYEAR combinadas.","og_url":"https:\/\/expert-only.com\/es\/power-bi\/valor-del-ultimo-ano-con-power-bi\/","og_site_name":"Tutoriales de SQL y TI","article_publisher":"https:\/\/www.facebook.com\/ExpertOnlyCom\/","article_published_time":"2023-06-19T04:33:00+00:00","article_modified_time":"2023-07-06T14:09:07+00:00","og_image":[{"width":1920,"height":1080,"url":"https:\/\/expert-only.com\/wp-content\/uploads\/2022\/09\/working-at-night-E575151C571_1920x1080.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":"3 minutos"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/expert-only.com\/es\/power-bi\/valor-del-ultimo-ano-con-power-bi\/#article","isPartOf":{"@id":"https:\/\/expert-only.com\/es\/power-bi\/valor-del-ultimo-ano-con-power-bi\/"},"author":{"name":"Expert-Only","@id":"https:\/\/expert-only.com\/es\/#\/schema\/person\/406a9576b52944f018739a42046873ef"},"headline":"\u00bfC\u00f3mo calcular el valor del \u00faltimo a\u00f1o con Power BI y DAX?","datePublished":"2023-06-19T04:33:00+00:00","dateModified":"2023-07-06T14:09:07+00:00","mainEntityOfPage":{"@id":"https:\/\/expert-only.com\/es\/power-bi\/valor-del-ultimo-ano-con-power-bi\/"},"wordCount":553,"commentCount":0,"publisher":{"@id":"https:\/\/expert-only.com\/es\/#organization"},"image":{"@id":"https:\/\/expert-only.com\/es\/power-bi\/valor-del-ultimo-ano-con-power-bi\/#primaryimage"},"thumbnailUrl":"https:\/\/expert-only.com\/wp-content\/uploads\/2022\/09\/working-at-night-E575151C571_1920x1080.jpg","articleSection":["Power BI"],"inLanguage":"es","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/expert-only.com\/es\/power-bi\/valor-del-ultimo-ano-con-power-bi\/#respond"]}]},{"@type":["WebPage","FAQPage"],"@id":"https:\/\/expert-only.com\/es\/power-bi\/valor-del-ultimo-ano-con-power-bi\/","url":"https:\/\/expert-only.com\/es\/power-bi\/valor-del-ultimo-ano-con-power-bi\/","name":"Valor del \u00faltimo a\u00f1o con Power BI - Microsoft BI","isPartOf":{"@id":"https:\/\/expert-only.com\/es\/#website"},"primaryImageOfPage":{"@id":"https:\/\/expert-only.com\/es\/power-bi\/valor-del-ultimo-ano-con-power-bi\/#primaryimage"},"image":{"@id":"https:\/\/expert-only.com\/es\/power-bi\/valor-del-ultimo-ano-con-power-bi\/#primaryimage"},"thumbnailUrl":"https:\/\/expert-only.com\/wp-content\/uploads\/2022\/09\/working-at-night-E575151C571_1920x1080.jpg","datePublished":"2023-06-19T04:33:00+00:00","dateModified":"2023-07-06T14:09:07+00:00","description":"Para calcular el valor del \u00faltimo a\u00f1o con Power BI y DAX, siga este ejemplo utilizando las funciones CALCULAR y PREVIOUSYEAR combinadas.","breadcrumb":{"@id":"https:\/\/expert-only.com\/es\/power-bi\/valor-del-ultimo-ano-con-power-bi\/#breadcrumb"},"mainEntity":[{"@id":"https:\/\/expert-only.com\/es\/power-bi\/valor-del-ultimo-ano-con-power-bi\/#faq-question-1598373676095"},{"@id":"https:\/\/expert-only.com\/es\/power-bi\/valor-del-ultimo-ano-con-power-bi\/#faq-question-1598373709032"},{"@id":"https:\/\/expert-only.com\/es\/power-bi\/valor-del-ultimo-ano-con-power-bi\/#faq-question-1598373727551"},{"@id":"https:\/\/expert-only.com\/es\/power-bi\/valor-del-ultimo-ano-con-power-bi\/#faq-question-1598373752771"}],"inLanguage":"es","potentialAction":[{"@type":"ReadAction","target":["https:\/\/expert-only.com\/es\/power-bi\/valor-del-ultimo-ano-con-power-bi\/"]}]},{"@type":"ImageObject","inLanguage":"es","@id":"https:\/\/expert-only.com\/es\/power-bi\/valor-del-ultimo-ano-con-power-bi\/#primaryimage","url":"https:\/\/expert-only.com\/wp-content\/uploads\/2022\/09\/working-at-night-E575151C571_1920x1080.jpg","contentUrl":"https:\/\/expert-only.com\/wp-content\/uploads\/2022\/09\/working-at-night-E575151C571_1920x1080.jpg","width":1920,"height":1080},{"@type":"BreadcrumbList","@id":"https:\/\/expert-only.com\/es\/power-bi\/valor-del-ultimo-ano-con-power-bi\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"es","item":"https:\/\/expert-only.com\/es\/"},{"@type":"ListItem","position":2,"name":"\u00bfC\u00f3mo calcular el valor del \u00faltimo a\u00f1o con Power BI y DAX?"}]},{"@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"}},{"@type":"Question","@id":"https:\/\/expert-only.com\/es\/power-bi\/valor-del-ultimo-ano-con-power-bi\/#faq-question-1598373676095","position":1,"url":"https:\/\/expert-only.com\/es\/power-bi\/valor-del-ultimo-ano-con-power-bi\/#faq-question-1598373676095","name":"\u00bfSe calcula autom\u00e1ticamente el total de ventas del \u00faltimo a\u00f1o en Power BI?","answerCount":1,"acceptedAnswer":{"@type":"Answer","text":"Por defecto, el software no calcula autom\u00e1ticamente el total de ventas del a\u00f1o anterior. Sin embargo, DAX para Power BI permite crear una medida utilizando funciones temporales para calcular las ventas del a\u00f1o anterior.","inLanguage":"es"},"inLanguage":"es"},{"@type":"Question","@id":"https:\/\/expert-only.com\/es\/power-bi\/valor-del-ultimo-ano-con-power-bi\/#faq-question-1598373709032","position":2,"url":"https:\/\/expert-only.com\/es\/power-bi\/valor-del-ultimo-ano-con-power-bi\/#faq-question-1598373709032","name":"\u00bfCu\u00e1les son las opciones para calcular el a\u00f1o anterior en DAX?","answerCount":1,"acceptedAnswer":{"@type":"Answer","text":"En Power BI hay muchas opciones para calcular nuevas medidas, incluidas las que tienen funciones temporales. Utilice la columna base mapeada desde una tabla u otras medidas.","inLanguage":"es"},"inLanguage":"es"},{"@type":"Question","@id":"https:\/\/expert-only.com\/es\/power-bi\/valor-del-ultimo-ano-con-power-bi\/#faq-question-1598373727551","position":3,"url":"https:\/\/expert-only.com\/es\/power-bi\/valor-del-ultimo-ano-con-power-bi\/#faq-question-1598373727551","name":"\u00bfCu\u00e1l es la diferencia entre los lenguajes DAX y MDX?","answerCount":1,"acceptedAnswer":{"@type":"Answer","text":"DAX significa Expresiones de An\u00e1lisis de Datos, y se utiliza para crear medidas y c\u00e1lculos para Power BI y Power BI. Por ejemplo, los cubos de Analysis Services contienen c\u00f3digo MDX.","inLanguage":"es"},"inLanguage":"es"},{"@type":"Question","@id":"https:\/\/expert-only.com\/es\/power-bi\/valor-del-ultimo-ano-con-power-bi\/#faq-question-1598373752771","position":4,"url":"https:\/\/expert-only.com\/es\/power-bi\/valor-del-ultimo-ano-con-power-bi\/#faq-question-1598373752771","name":"\u00bfCu\u00e1l es la funci\u00f3n DAX para el \u00faltimo a\u00f1o?","answerCount":1,"acceptedAnswer":{"@type":"Answer","text":"La funci\u00f3n DAX para calcular el \u00faltimo a\u00f1o es la funci\u00f3n PREVIOUSYEAR incorporada en Power BI, que devuelve todas las fechas hasta el a\u00f1o proporcionado como par\u00e1metro de entrada.","inLanguage":"es"},"inLanguage":"es"}]}},"_links":{"self":[{"href":"https:\/\/expert-only.com\/es\/wp-json\/wp\/v2\/posts\/26148","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=26148"}],"version-history":[{"count":0,"href":"https:\/\/expert-only.com\/es\/wp-json\/wp\/v2\/posts\/26148\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/expert-only.com\/es\/wp-json\/wp\/v2\/media\/10951"}],"wp:attachment":[{"href":"https:\/\/expert-only.com\/es\/wp-json\/wp\/v2\/media?parent=26148"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/expert-only.com\/es\/wp-json\/wp\/v2\/categories?post=26148"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/expert-only.com\/es\/wp-json\/wp\/v2\/tags?post=26148"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}