{"id":850,"date":"2024-05-15T17:31:15","date_gmt":"2024-05-15T15:31:15","guid":{"rendered":"https:\/\/nordestconsulting.com\/?p=850"},"modified":"2024-05-24T12:04:08","modified_gmt":"2024-05-24T10:04:08","slug":"selector-de-dates-dinamic-a-power-bi","status":"publish","type":"post","link":"https:\/\/nordestconsulting.com\/es\/selector-de-dates-dinamic-a-power-bi\/","title":{"rendered":"Selector de fechas din\u00e1mico en Power BI"},"content":{"rendered":"\n<p class=\"wp-block-paragraph\"><\/p>\n\n\n<div class=\"gb-container gb-container-ded98166\">\n\n<figure class=\"gb-block-image gb-block-image-f979925c\"><img loading=\"lazy\" decoding=\"async\" width=\"1582\" height=\"387\" class=\"gb-image gb-image-f979925c\" src=\"https:\/\/nordestconsulting.com\/wp-content\/uploads\/2024\/04\/NORDEST-CONSULTING-01.png\" alt=\"\" title=\"NORDEST CONSULTING-01\" srcset=\"https:\/\/nordestconsulting.com\/wp-content\/uploads\/2024\/04\/NORDEST-CONSULTING-01.png 1582w, https:\/\/nordestconsulting.com\/wp-content\/uploads\/2024\/04\/NORDEST-CONSULTING-01-300x73.png 300w, https:\/\/nordestconsulting.com\/wp-content\/uploads\/2024\/04\/NORDEST-CONSULTING-01-1024x250.png 1024w, https:\/\/nordestconsulting.com\/wp-content\/uploads\/2024\/04\/NORDEST-CONSULTING-01-768x188.png 768w, https:\/\/nordestconsulting.com\/wp-content\/uploads\/2024\/04\/NORDEST-CONSULTING-01-1536x376.png 1536w\" sizes=\"auto, (max-width: 1582px) 100vw, 1582px\" \/><\/figure>\n\n\n<nav class=\"is-responsive wp-block-navigation is-layout-flex wp-block-navigation-is-layout-flex\" aria-label=\"Menu 1\" \n\t\t data-wp-interactive=\"core\/navigation\" data-wp-context='{\"overlayOpenedBy\":{\"click\":false,\"hover\":false,\"focus\":false},\"type\":\"overlay\",\"roleAttribute\":\"\",\"ariaLabel\":\"Men\\u00fa\"}'><button aria-haspopup=\"dialog\" aria-label=\"Abrir el men\u00fa\" class=\"wp-block-navigation__responsive-container-open\" \n\t\t\t\tdata-wp-on--click=\"actions.openMenuOnClick\"\n\t\t\t\tdata-wp-on--keydown=\"actions.handleMenuKeydown\"\n\t\t\t><svg width=\"24\" height=\"24\" xmlns=\"http:\/\/www.w3.org\/2000\/svg\" viewBox=\"0 0 24 24\"><path d=\"M5 5v1.5h14V5H5z\"><\/path><path d=\"M5 12.8h14v-1.5H5v1.5z\"><\/path><path d=\"M5 19h14v-1.5H5V19z\"><\/path><\/svg><\/button>\n\t\t\t\t<div class=\"wp-block-navigation__responsive-container\"  id=\"modal-1\" \n\t\t\t\tdata-wp-class--has-modal-open=\"state.isMenuOpen\"\n\t\t\t\tdata-wp-class--is-menu-open=\"state.isMenuOpen\"\n\t\t\t\tdata-wp-watch=\"callbacks.initMenu\"\n\t\t\t\tdata-wp-on--keydown=\"actions.handleMenuKeydown\"\n\t\t\t\tdata-wp-on--focusout=\"actions.handleMenuFocusout\"\n\t\t\t\ttabindex=\"-1\"\n\t\t\t>\n\t\t\t\t\t<div class=\"wp-block-navigation__responsive-close\" tabindex=\"-1\">\n\t\t\t\t\t\t<div class=\"wp-block-navigation__responsive-dialog\" \n\t\t\t\tdata-wp-bind--aria-modal=\"state.ariaModal\"\n\t\t\t\tdata-wp-bind--aria-label=\"state.ariaLabel\"\n\t\t\t\tdata-wp-bind--role=\"state.roleAttribute\"\n\t\t\t>\n\t\t\t\t\t\t\t<button aria-label=\"Cerrar el men\u00fa\" class=\"wp-block-navigation__responsive-container-close\" \n\t\t\t\tdata-wp-on--click=\"actions.closeMenuOnClick\"\n\t\t\t><svg xmlns=\"http:\/\/www.w3.org\/2000\/svg\" viewBox=\"0 0 24 24\" width=\"24\" height=\"24\" aria-hidden=\"true\" focusable=\"false\"><path d=\"m13.06 12 6.47-6.47-1.06-1.06L12 10.94 5.53 4.47 4.47 5.53 10.94 12l-6.47 6.47 1.06 1.06L12 13.06l6.47 6.47 1.06-1.06L13.06 12Z\"><\/path><\/svg><\/button>\n\t\t\t\t\t\t\t<div class=\"wp-block-navigation__responsive-container-content\" \n\t\t\t\tdata-wp-watch=\"callbacks.focusFirstElement\"\n\t\t\t id=\"modal-1-content\">\n\t\t\t\t\t\t\t\t<ul class=\"wp-block-navigation__container is-responsive wp-block-navigation\"><li class=\"wp-block-navigation-item wp-block-navigation-link\"><a class=\"wp-block-navigation-item__content\"  href=\"https:\/\/nordestconsulting.com\/es\/inicio\/\"><span class=\"wp-block-navigation-item__label\">INICIO<\/span><\/a><\/li><li class=\"wp-block-navigation-item wp-block-navigation-link\"><a class=\"wp-block-navigation-item__content\"  href=\"https:\/\/nordestconsulting.com\/es\/servicios\/\"><span class=\"wp-block-navigation-item__label\">SERVICIOS<\/span><\/a><\/li><li class=\"wp-block-navigation-item wp-block-navigation-link\"><a class=\"wp-block-navigation-item__content\"  href=\"https:\/\/nordestconsulting.com\/es\/industrias\/\"><span class=\"wp-block-navigation-item__label\">INDUSTRIAS<\/span><\/a><\/li><li class=\"wp-block-navigation-item wp-block-navigation-link\"><a class=\"wp-block-navigation-item__content\"  href=\"https:\/\/nordestconsulting.com\/es\/blog\/\"><span class=\"wp-block-navigation-item__label\">BLOG<\/span><\/a><\/li><li class=\"wp-block-navigation-item wp-block-navigation-link\"><a class=\"wp-block-navigation-item__content\"  href=\"https:\/\/nordestconsulting.com\/es\/contacto\/\"><span class=\"wp-block-navigation-item__label\">CONTACTO<\/span><\/a><\/li><li data-wp-context=\"{ &quot;submenuOpenedBy&quot;: { &quot;click&quot;: false, &quot;hover&quot;: false, &quot;focus&quot;: false }, &quot;type&quot;: &quot;submenu&quot;, &quot;modal&quot;: null, &quot;previousFocus&quot;: null }\" data-wp-interactive=\"core\/navigation\" data-wp-on--focusout=\"actions.handleMenuFocusout\" data-wp-on--keydown=\"actions.handleMenuKeydown\" data-wp-on--pointerenter=\"actions.openMenuOnHover\" data-wp-on--pointerleave=\"actions.closeMenuOnHover\" data-wp-watch=\"callbacks.initMenu\" tabindex=\"-1\" class=\"wp-block-navigation-item has-child open-on-hover-click dropdownslang catcat wp-block-navigation-submenu\"><a class=\"wp-block-navigation-item__content\" href=\"#\"><span class=\"wp-block-navigation-item__label\">ES<\/span><\/a><button data-wp-bind--aria-expanded=\"state.isSubmenuOpen\" data-wp-on--click=\"actions.toggleMenuOnClick\" aria-label=\"Submen\u00fa de ES\" class=\"wp-block-navigation__submenu-icon wp-block-navigation-submenu__toggle\" ><svg xmlns=\"http:\/\/www.w3.org\/2000\/svg\" width=\"12\" height=\"12\" viewBox=\"0 0 12 12\" fill=\"none\" aria-hidden=\"true\" focusable=\"false\"><path d=\"M1.50002 4L6.00002 8L10.5 4\" stroke-width=\"1.5\"><\/path><\/svg><\/button><ul data-wp-on--focus=\"actions.openMenuOnFocus\" class=\"wp-block-navigation__submenu-container dropdownslang catcat wp-block-navigation-submenu\"><li class=\"wp-block-navigation-item wp-block-navigation-link\"><a class=\"wp-block-navigation-item__content\"  href=\"https:\/\/nordestconsulting.com\/inici\"><span class=\"wp-block-navigation-item__label\">CAT<\/span><\/a><\/li><li class=\"wp-block-navigation-item wp-block-navigation-link\"><a class=\"wp-block-navigation-item__content\"  href=\"https:\/\/nordestconsulting.com\/es\/inicio\"><span class=\"wp-block-navigation-item__label\">ES<\/span><\/a><\/li><\/ul><\/li><\/ul>\n\t\t\t\t\t\t\t\t\n\t\t\t\t\t\t\t<\/div>\n\t\t\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t\t\t<\/div><\/nav>\n<\/div>\n\n<div class=\"gb-container gb-container-f384faee\">\n\n<p class=\"has-text-align-left has-base-3-color has-text-color has-link-color wp-elements-1 wp-block-paragraph\" style=\"font-size:40px\">les \u00faltimes <br>not\u00edcies<\/p>\n\n<\/div>\n\n<div class=\"gb-container gb-container-96222c44\">\n<figure class=\"gb-block-image gb-block-image-e96e924f\"><img loading=\"lazy\" decoding=\"async\" width=\"1152\" height=\"648\" src=\"https:\/\/nordestconsulting.com\/wp-content\/uploads\/2024\/05\/1715010342694.gif\" class=\"gb-image-e96e924f\" alt=\"\" \/><\/figure>\n\n\n<p class=\"has-text-color has-large-font-size wp-block-paragraph\" style=\"color:#222c6f\"><strong>Selector de fechas din\u00e1mico en Power BI<\/strong><\/p>\n\n\n<h2 class=\"gb-headline gb-headline-4b1f69c8 gb-headline-text\"><time class=\"entry-date published\" datetime=\"2024-05-15T17:31:15+02:00\">15 de mayo de 2024<\/time><\/h2>\n\n<div class=\"gb-container gb-container-dd92d994\"><\/div>\n\n\n<p class=\"wp-block-paragraph\">s de lan\u00e0lisi <\/p>\n\n\n\n<p class=\"wp-block-paragraph\" id=\"ember41\">En el mundo del an\u00e1lisis de datos con Power BI, la selecci\u00f3n eficiente de fechas es crucial para una visualizaci\u00f3n y manipulaci\u00f3n de datos efectiva. Sin embargo, Power BI carece de un selector de fechas integrado que cumpla con las expectativas de usabilidad de la mayor\u00eda de los usuarios. Este tutorial proporciona una gu\u00eda paso a paso para crear un selector de fechas personalizado en Power BI, superando las limitaciones del selector predeterminado.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\" id=\"ember43\"><strong>1.- Tabla de \u00daltima Actualizaci\u00f3n: <\/strong>Para comenzar, generamos una tabla en el editor de Power Query que captura la \u00faltima fecha y hora de actualizaci\u00f3n del informe. Es esencial considerar el huso horario local para asegurar la precisi\u00f3n al publicar en Power BI Service. A continuaci\u00f3n, se presenta el c\u00f3digo de Power Query necesario para esta tarea:<\/p>\n\n\n\n<pre class=\"wp-block-preformatted\">let\n\ndate = DateTime.Date(DateTimeZone.SwitchZone(DateTimeZone.UtcNow(),+1,0)),\ntime = DateTime.Time(DateTimeZone.SwitchZone(DateTimeZone.UtcNow(),+1,0)),\n\/\/+1 hora para obtener hora de invierno de Espa\u00f1a respecto a hora UTC.\n\n\nfirstSundayOfNovember = Date.StartOfWeek(#date(Date.Year(date), 11, 7), Day.Sunday),\nSecondSundayOfMarch = Date.StartOfWeek(#date(Date.Year(date), 3, 14), Day.Sunday),\n\n\nisSummerTime =\u2003\u2003(date = SecondSundayOfMarch and time &gt;= #time(1,0,0))\n\u2003\u2003        or\n\u2003\u2003\u2003\u2003(date &gt; SecondSundayOfMarch and date &lt; firstSundayOfNovember) \n\u2003\u2003\u2003\u2003or \n\u2003\u2003\u2003\u2003(date = firstSundayOfNovember and time &gt;= #time(1,0,0)),\n\n\ntimeZone = (Number.From(isSummerTime))*1, \n\/\/sumamos una hora para el horario de verano en el huso horario de Espa\u00f1a\n\n\nltime = \n            DateTime.From(date) \n            + #duration(0,Time.Hour(time),Time.Minute(time),Time.Second(time))  \n            + #duration(0, timeZone, 0, 0),\n    #\"Convertida en tabla\" = #table(1, {{ltime}}),\n    #\"Columnas con nombre cambiado\" = Table.RenameColumns(#\"Convertida en tabla\",{{\"Column1\", \"UltimaActualizaci\u00f3n\"}}),\n    #\"Tipo cambiado\" = Table.TransformColumnTypes(#\"Columnas con nombre cambiado\",{{\"UltimaActualizaci\u00f3n\", type datetime}})\nin\n    #\"Tipo cambiado\"<\/pre>\n\n\n\n<p class=\"wp-block-paragraph\" id=\"ember45\"><strong>2.- Creaci\u00f3n de un Calendario Independiente:<\/strong> El siguiente paso es crear un calendario en Power Query que se utilizar\u00e1 en las medidas del informe2. Este calendario debe permanecer sin vincular a otras tablas en el modelo. El c\u00f3digo M para la creaci\u00f3n del calendario es el siguiente:<\/p>\n\n\n\n<pre class=\"wp-block-preformatted\">let\n    Source = #date(2018, 1, 1), \n    FechaFinal = #date(Date.Year(DateTime.LocalNow()),12,31),\n    ListaInicioFinal = {Number.From(Source)..Number.From(FechaFinal)},\n    #\"Converted to Table\" = Table.FromList(ListaInicioFinal, Splitter.SplitByNothing(), null, null, ExtraValues.Error),\n    #\"Changed Type\" = Table.TransformColumnTypes(#\"Converted to Table\",{{\"Column1\", type date}}),\n    #\"Renamed Columns\" = Table.RenameColumns(#\"Changed Type\",{{\"Column1\", \"Fecha\"}}),\n    #\"Added Custom Column\" = Table.AddColumn(#\"Renamed Columns\", \"Custom\", each Text.Combine({Date.ToText([Fecha], \"yyyy\"), Date.ToText([Fecha], \"MM\"), Date.ToText([Fecha], \"dd\")}), type text),\n    #\"Inserted Year\" = Table.AddColumn(#\"Added Custom Column\", \"Year\", each Date.Year([Fecha]), Int64.Type),\n    #\"Inserted Quarter\" = Table.AddColumn(#\"Inserted Year\", \"Quarter\", each Date.QuarterOfYear([Fecha]), Int64.Type),\n    #\"Inserted Month\" = Table.AddColumn(#\"Inserted Quarter\", \"Month\", each Date.Month([Fecha]), Int64.Type),\n    #\"Inserted Day\" = Table.AddColumn(#\"Inserted Month\", \"Day\", each Date.Day([Fecha]), Int64.Type),\n    #\"Inserted Merged Column\" = Table.AddColumn(#\"Inserted Day\", \"Merged\", each Text.Combine({\"T\", Text.From([Quarter], \"es-MX\")}), type text),\n    #\"Inserted Month Name\" = Table.AddColumn(#\"Inserted Merged Column\", \"Month Name\", each Date.MonthName([Fecha]), type text),\n    #\"Inserted First Characters\" = Table.AddColumn(#\"Inserted Month Name\", \"First Characters\", each Text.Start([Month Name], 3), type text),\n    #\"Inserted Day of Week\" = Table.AddColumn(#\"Inserted First Characters\", \"Day of Week\", each Date.DayOfWeek([Fecha]), Int64.Type),\n    #\"Inserted Week of Year\" = Table.AddColumn(#\"Inserted Day of Week\", \"Week of Year\", each Date.WeekOfYear([Fecha]), Int64.Type),\n    #\"Inserted Week of Month\" = Table.AddColumn(#\"Inserted Week of Year\", \"Week of Month\", each Date.WeekOfMonth([Fecha]), Int64.Type),\n    #\"Inserted End of Week\" = Table.AddColumn(#\"Inserted Week of Month\", \"End of Week\", each Date.EndOfWeek([Fecha],Day.Monday), type date),\n    #\"Inserted Day of Year\" = Table.AddColumn(#\"Inserted End of Week\", \"Day of Year\", each Date.DayOfYear([Fecha]), Int64.Type),\n    #\"Inserted Day Name\" = Table.AddColumn(#\"Inserted Day of Year\", \"Day Name\", each Date.DayOfWeekName([Fecha]), type text),\n    #\"Inserted First Characters1\" = Table.AddColumn(#\"Inserted Day Name\", \"First Characters.1\", each Text.Start([Day Name], 3), type text),\n    #\"Inserted Merged Column1\" = Table.AddColumn(#\"Inserted First Characters1\", \"Merged.1\", each Text.Combine({Text.From([Year], \"es-MX\"), [Merged]}, \"\/\"), type text),\n    #\"Inserted First Characters2\" = Table.AddColumn(#\"Inserted Merged Column1\", \"First Characters.2\", each Text.Start([Custom], 6), type text),\n    #\"Split Column by Position\" = Table.SplitColumn(#\"Inserted First Characters2\", \"First Characters.2\", Splitter.SplitTextByPositions({0, 4}, false), {\"First Characters.2.1\", \"First Characters.2.2\"}),\n    #\"Merged Columns\" = Table.CombineColumns(#\"Split Column by Position\",{\"First Characters.2.1\", \"First Characters.2.2\"},Combiner.CombineTextByDelimiter(\"\/\", QuoteStyle.None),\"Merged.3\"),\n    #\"Inserted Merged Column2\" = Table.AddColumn(#\"Merged Columns\", \"Merged.2\", each Text.Combine({Text.From([Year], \"es-MX\"), \"\/\", [First Characters]}), type text),\n    #\"Replaced Value\" = Table.ReplaceValue(#\"Inserted Merged Column2\",0,7,Replacer.ReplaceValue,{\"Day of Week\"}),\n    #\"Renamed Columns1\" = Table.RenameColumns(#\"Replaced Value\",{{\"Custom\", \"FechaSK\"}, {\"Year\", \"#A\u00f1o\"}, {\"Quarter\", \"#Trimestre\"}, {\"Month\", \"#Mes\"}, {\"Day\", \"#D\u00eda\"}, {\"Merged\", \"Trimestre\"}, {\"Month Name\", \"Mes\"}, {\"First Characters\", \"MesCorto\"}, {\"Day of Week\", \"#D\u00edaSemana\"}, {\"Week of Year\", \"#SemanaA\u00f1o\"}, {\"Week of Month\", \"#SemanaMes\"}, {\"End of Week\", \"CierreSemana\"}, {\"Day of Year\", \"#D\u00edaA\u00f1o\"}, {\"Day Name\", \"D\u00eda\"}, {\"First Characters.1\", \"D\u00edaCorto\"}, {\"Merged.1\", \"A\u00f1oTrimestre\"}, {\"Merged.3\", \"A\u00f1o#Mes\"}, {\"Merged.2\", \"A\u00f1oMesCorto\"}}),\n    #\"Tipo cambiado\" = Table.TransformColumnTypes(#\"Renamed Columns1\",{{\"Fecha\", type date}}),\n    #\"Columna duplicada\" = Table.AddColumn(#\"Tipo cambiado\", \"Fecha - Copia\", each [Fecha], type date),\n    #\"Columnas quitadas\" = Table.RemoveColumns(#\"Columna duplicada\",{\"Fecha\"}),\n    #\"Columnas con nombre cambiado\" = Table.RenameColumns(#\"Columnas quitadas\",{{\"Fecha - Copia\", \"Fecha\"}})\nin\n    #\"Columnas con nombre cambiado\"<\/pre>\n\n\n\n<p class=\"wp-block-paragraph\" id=\"ember47\"><strong>3.- Definici\u00f3n de Per\u00edodos Seleccionables con DAX:<\/strong> Una vez establecidas la tabla de calendario y la fecha de actualizaci\u00f3n, pasamos a DAX para crear distintos per\u00edodos seleccionables como \u201cHoy\u201d, \u201cEsta semana\u201d, \u201cEste mes\u201d, entre otros. Utilizamos una nueva tabla en la vista de tablas de Power BI y creamos la siguiente estructura con DAX:<\/p>\n\n\n\n<pre class=\"wp-block-preformatted\">Periodos = UNION(\n            ADDCOLUMNS(\n            CALENDAR(                                 \n                MAX('\u00daltimaActualizaci\u00f3n'[UltimaActualizaci\u00f3n]) - WEEKDAY(MAX('\u00daltimaActualizaci\u00f3n'[UltimaActualizaci\u00f3n]), 1) + 2,    \n                MAX('\u00daltimaActualizaci\u00f3n'[UltimaActualizaci\u00f3n])  \n            ),\n            \"Tipo\", \"Semana Hasta la Fecha\",\n            \"Orden\", 2\n            ),    \n            ADDCOLUMNS(\n            CALENDAR(\n                MAX('\u00daltimaActualizaci\u00f3n'[UltimaActualizaci\u00f3n]) - WEEKDAY(MAX('\u00daltimaActualizaci\u00f3n'[UltimaActualizaci\u00f3n]), 1) - 5,\n                MAX('\u00daltimaActualizaci\u00f3n'[UltimaActualizaci\u00f3n]) - WEEKDAY(MAX('\u00daltimaActualizaci\u00f3n'[UltimaActualizaci\u00f3n]), 1) + 1\n            ),\n            \"Tipo\", \"Semana Anterior\",\n            \"Orden\", 8\n            ),\n            ADDCOLUMNS(\n            CALENDAR(\n                date(year(MAX('\u00daltimaActualizaci\u00f3n'[UltimaActualizaci\u00f3n])),month(MAX('\u00daltimaActualizaci\u00f3n'[UltimaActualizaci\u00f3n])), 1),\n                MAX('\u00daltimaActualizaci\u00f3n'[UltimaActualizaci\u00f3n])\n            ), \n            \"Tipo\", \"Mes Hasta la Fecha\",\n            \"Orden\", 3\n            ),\n            ADDCOLUMNS(\n            CALENDAR(\n                date(year(MAX('\u00daltimaActualizaci\u00f3n'[UltimaActualizaci\u00f3n])),month(MAX('\u00daltimaActualizaci\u00f3n'[UltimaActualizaci\u00f3n]))-1, 1),\n                EOMONTH(date(year(MAX('\u00daltimaActualizaci\u00f3n'[UltimaActualizaci\u00f3n])),month(MAX('\u00daltimaActualizaci\u00f3n'[UltimaActualizaci\u00f3n]))-1, 1),0)\n            ), \n            \"Tipo\", \"Mes Anterior\",\n            \"Orden\", 9\n            ),\n            ADDCOLUMNS(\n            CALENDAR(\n                date(year(MAX('\u00daltimaActualizaci\u00f3n'[UltimaActualizaci\u00f3n])),month(MAX('\u00daltimaActualizaci\u00f3n'[UltimaActualizaci\u00f3n])), 1),\n                EOMONTH(MAX('\u00daltimaActualizaci\u00f3n'[UltimaActualizaci\u00f3n]),0)\n            ), \n            \"Type\", \"Mes Actual\",\n            \"Orden\", 6\n            ),\n            ADDCOLUMNS(\n            CALENDAR(\n                date(year(MAX('\u00daltimaActualizaci\u00f3n'[UltimaActualizaci\u00f3n])),1, 1),\n                MAX('\u00daltimaActualizaci\u00f3n'[UltimaActualizaci\u00f3n])\n            ), \n            \"Tipo\", \"A\u00f1o Hasta la Fecha\",\n            \"Orden\", 4\n            ),\n            ADDCOLUMNS(CALENDAR(min(Calendario[Fecha]),max(Calendario[Fecha])),\n         \"Tipo\", \"Personalizado\",\"Orden\",10),\n            ADDCOLUMNS(\n            CALENDAR(\n                date(year(MAX('\u00daltimaActualizaci\u00f3n'[UltimaActualizaci\u00f3n]))-1,1, 1),\n                date(year(MAX('\u00daltimaActualizaci\u00f3n'[UltimaActualizaci\u00f3n]))-1,12, 31)\n            ), \n            \"Tipo\", \"A\u00f1o Anterior\",\n            \"Orden\", 10\n            ),\n            ADDCOLUMNS(\n            CALENDAR(\n                date(year(MAX('\u00daltimaActualizaci\u00f3n'[UltimaActualizaci\u00f3n])),1, 1),\n                date(year(MAX('\u00daltimaActualizaci\u00f3n'[UltimaActualizaci\u00f3n])),12, 31)\n            ), \n            \"Tipo\", \"A\u00f1o Actual\",\n            \"Orden\", 7\n        ),\n        ADDCOLUMNS(\n            CALENDAR(                                 \n                MAX('\u00daltimaActualizaci\u00f3n'[UltimaActualizaci\u00f3n]) - WEEKDAY(MAX('\u00daltimaActualizaci\u00f3n'[UltimaActualizaci\u00f3n]), 1) + 2,    \n        MAX('\u00daltimaActualizaci\u00f3n'[UltimaActualizaci\u00f3n]) + (7 - WEEKDAY(MAX('\u00daltimaActualizaci\u00f3n'[UltimaActualizaci\u00f3n]), 2))  \n            ),\n            \"Tipo\", \"Semana Actual\",\n            \"Orden\", 5\n        ),\n\n        ADDCOLUMNS(\n            CALENDAR(                                 \n                MAX('\u00daltimaActualizaci\u00f3n'[UltimaActualizaci\u00f3n]),\n                MAX('\u00daltimaActualizaci\u00f3n'[UltimaActualizaci\u00f3n])\n            ),\n            \"Tipo\", \"Hoy\",\n            \"Orden\", 1\n        )\n)<\/pre>\n\n\n\n<figure class=\"wp-block-image\"><img decoding=\"async\" src=\"https:\/\/media.licdn.com\/dms\/image\/D4D12AQEIbKu71PPSLw\/article-inline_image-shrink_1500_2232\/0\/1715007269132?e=1721260800&amp;v=beta&amp;t=248K37_47X4dXEPQuCv0BLK0K3Cl8b8hPYEU6GeAE5c\" alt=\"\"\/><figcaption class=\"wp-element-caption\">Desplegable con los per\u00edodos seleccionables por el usuario<\/figcaption><\/figure>\n\n\n\n<p class=\"wp-block-paragraph\" id=\"ember50\"><strong>4.- Medidas para el An\u00e1lisis de Per\u00edodos:<\/strong> Es crucial almacenar en una medida el per\u00edodo seleccionado por el usuario. Esto nos permite identificar cu\u00e1ndo el per\u00edodo es personalizado y, por ende, filtrar seg\u00fan la selecci\u00f3n realizada en el calendario. Las medidas relevantes son:<\/p>\n\n\n\n<pre class=\"wp-block-preformatted\">Periodo Seleccionado = SELECTEDVALUE('Periodos'[Tipo])<\/pre>\n\n\n\n<pre class=\"wp-block-preformatted\"> MinDate = if(ISFILTERED(Calendario[Fecha]) &amp;&amp; [Periodo  Seleccionado] = \"Personalizado\", min(Calendario[Fecha]),min(Periodos[Date]))<\/pre>\n\n\n\n<pre class=\"wp-block-preformatted\">MaxDate = if(ISFILTERED(Calendario[Fecha]) &amp;&amp; [Periodo Seleccionado] = \"Personalizado\", max(Calendario[Fecha]), MAX(Periodos[Date]))<\/pre>\n\n\n\n<pre class=\"wp-block-preformatted\">Periodo Analizado = [MinDate] &amp; \"-\" &amp; [MaxDate]<\/pre>\n\n\n\n<p class=\"wp-block-paragraph\" id=\"ember52\"><strong>6.- Integraci\u00f3n de un Slider para Selecci\u00f3n de Fechas:<\/strong> Para que el usuario pueda seleccionar un rango de fechas personalizado, incorporamos un slider que permite seleccionar fechas de manera interactiva. Este slider se vincula directamente con la tabla de Calendario que hemos creado previamente. Opcionalmente, se pueden configurar mediante marcadores para mostar u ocultar este calendario.<\/p>\n\n\n\n<figure class=\"wp-block-image\"><img decoding=\"async\" src=\"https:\/\/media.licdn.com\/dms\/image\/D4D12AQHu_J4FoZaCXA\/article-inline_image-shrink_1500_2232\/0\/1715007344603?e=1721260800&amp;v=beta&amp;t=tFGaqow2LB5X0z7xPeZmSHdDz-GqxblxuXt3AGgcWxo\" alt=\"\"\/><figcaption class=\"wp-element-caption\">Selector de fechas personalizadas por el usuario<\/figcaption><\/figure>\n\n\n\n<p class=\"wp-block-paragraph\" id=\"ember55\"><strong>7.- Implementaci\u00f3n de Medidas para Visualizaciones:<\/strong> Con las medidas anteriores, podemos crear medidas que se utilizar\u00e1n en tablas y gr\u00e1ficos. Es importante especificar siempre el filtro de fecha dentro de la medida, como se muestra en el siguiente ejemplo:<\/p>\n\n\n\n<pre class=\"wp-block-preformatted\">Ventas A\u00f1o Actual = \nCALCULATE(\n    sum(FactTable[Importe]),\nFILTER (FactTable, FactTable[fecha] &lt;= [MaxDate] &amp;&amp; FactTable[fecha] &gt;= [MinDate]))<\/pre>\n\n\n\n<p class=\"wp-block-paragraph\" id=\"ember57\">Siguiendo estos pasos, podr\u00e1s implementar un selector de fechas personalizado en Power BI que mejore significativamente la interacci\u00f3n del usuario con los informes. Este enfoque permite una selecci\u00f3n de fechas m\u00e1s intuitiva y adaptada a las necesidades espec\u00edficas del an\u00e1lisis de datos.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\" style=\"font-size:12px\">Segueix-nos<\/p>\n\n\n\n<figure class=\"gb-block-image gb-block-image-1b856d31\"><a href=\"https:\/\/www.linkedin.com\/company\/nordest-consulting\/\"><img loading=\"lazy\" decoding=\"async\" width=\"65\" height=\"65\" class=\"gb-image gb-image-1b856d31\" src=\"https:\/\/nordestconsulting.com\/wp-content\/uploads\/2024\/04\/icona-linkedin.png\" alt=\"\" title=\"icona linkedin\"\/><\/a><\/figure>\n\n\n<div class=\"gb-container gb-container-13c4dd2a\">\n\n<p class=\"wp-block-paragraph\">Comparteix l&#8217;entrada!<\/p>\n\n\n<div class=\"addtoany_shortcode\"><div class=\"a2a_kit a2a_kit_size_32 addtoany_list\" data-a2a-url=\"https:\/\/nordestconsulting.com\/es\/selector-de-dates-dinamic-a-power-bi\/\" data-a2a-title=\"Selector de fechas din\u00e1mico en Power BI\"><a class=\"a2a_button_facebook\" href=\"https:\/\/www.addtoany.com\/add_to\/facebook?linkurl=https%3A%2F%2Fnordestconsulting.com%2Fes%2Fselector-de-dates-dinamic-a-power-bi%2F&amp;linkname=Selector%20de%20fechas%20din%C3%A1mico%20en%20Power%20BI\" title=\"Facebook\" rel=\"nofollow noopener\" target=\"_blank\"><\/a><a class=\"a2a_button_linkedin\" href=\"https:\/\/www.addtoany.com\/add_to\/linkedin?linkurl=https%3A%2F%2Fnordestconsulting.com%2Fes%2Fselector-de-dates-dinamic-a-power-bi%2F&amp;linkname=Selector%20de%20fechas%20din%C3%A1mico%20en%20Power%20BI\" title=\"LinkedIn\" rel=\"nofollow noopener\" target=\"_blank\"><\/a><a class=\"a2a_button_whatsapp\" href=\"https:\/\/www.addtoany.com\/add_to\/whatsapp?linkurl=https%3A%2F%2Fnordestconsulting.com%2Fes%2Fselector-de-dates-dinamic-a-power-bi%2F&amp;linkname=Selector%20de%20fechas%20din%C3%A1mico%20en%20Power%20BI\" title=\"WhatsApp\" rel=\"nofollow noopener\" target=\"_blank\"><\/a><a class=\"a2a_button_email\" href=\"https:\/\/www.addtoany.com\/add_to\/email?linkurl=https%3A%2F%2Fnordestconsulting.com%2Fes%2Fselector-de-dates-dinamic-a-power-bi%2F&amp;linkname=Selector%20de%20fechas%20din%C3%A1mico%20en%20Power%20BI\" title=\"Email\" rel=\"nofollow noopener\" target=\"_blank\"><\/a><a class=\"a2a_dd addtoany_share_save addtoany_share\" href=\"https:\/\/www.addtoany.com\/share\"><\/a><\/div><\/div>\n\n<\/div>\n\n<div class=\"gb-container gb-container-f5071b6d\">\n\n\n\n<\/div>\n\n<div class=\"gb-container gb-container-dd92d994\"><\/div>\n<\/div>\n\n<div class=\"gb-container gb-container-411764dd\">\n<div class=\"gb-container gb-container-b681e1f5\">\n<div class=\"gb-container gb-container-7567673a\">\n\n<p class=\"has-text-align-center has-base-3-color has-text-color has-link-color has-medium-font-size wp-elements-2 wp-block-paragraph\">\u00bfNecesitas m\u00e1s informaci\u00f3n?<br\/>Contacta con nosotros<\/p>\n\n\n\n<ul style=\"list-style: none; color:#222c6f; font-weight: bold; padding-left: 0;\">\n  <li style=\"margin-left: 20px; background: url('https:\/\/nordestconsulting.com\/wp-content\/uploads\/2024\/04\/icona-telefon-1.png') no-repeat left center; padding-left: 40px; background-size: contain; margin-bottom: 10px;\"><a href=\"tel:+34%20690%20321%20793\" style=\"color:white; text-decoration:none;\">+34 690 321 793<\/a><\/li>\n  <li style=\"margin-left: 20px; background: url('https:\/\/nordestconsulting.com\/wp-content\/uploads\/2024\/04\/icona-mail.png') no-repeat left center; padding-left: 40px; background-size: contain; margin-bottom: 10px;\"><a href=\"mailto:info@nordestconsulting.com\" style=\"color:white;text-decoration:none;\">info@nordestconsulting.com<\/a><\/li>\n<\/ul>\n\n<\/div>\n\n<div class=\"gb-container gb-container-b496869e\">\n\n<a class=\"gb-button gb-button-f1855f5d gb-button-text\" href=\"https:\/\/nordestconsulting.com\/es\/contacto\/\">contacto<\/a>\n\n\n\n<figure class=\"wp-block-image size-full is-resized\"><a href=\"https:\/\/www.linkedin.com\/company\/nordest-consulting\/\" target=\"_blank\" rel=\"noreferrer noopener\"><img loading=\"lazy\" decoding=\"async\" width=\"50\" height=\"50\" src=\"https:\/\/nordestconsulting.com\/wp-content\/uploads\/2024\/05\/icons8-linkedin-50.png\" alt=\"\" class=\"wp-image-938\" style=\"width:40px\"\/><\/a><\/figure>\n\n<\/div>\n<\/div>\n\n<div class=\"gb-container gb-container-2e1aa124\"><\/div>\n<\/div><div class=\"gb-container gb-container-49be90b3\">\n\n<p class=\"has-text-align-center has-contrast-color has-text-color has-link-color wp-elements-3 wp-block-paragraph\"><a href=\"https:\/\/nordestconsulting.com\/es\/aviso-legal\/\">AVISO LEGAL<\/a><\/p>\n\n\n\n<p class=\"has-text-align-center has-contrast-color has-text-color has-link-color wp-elements-4 wp-block-paragraph\"><a href=\"https:\/\/nordestconsulting.com\/es\/politica-de-cookies-2\/\">POL\u00cdTICA DE COOKIES<\/a><\/p>\n\n\n\n<p class=\"has-text-align-center has-contrast-color has-text-color has-link-color wp-elements-5 wp-block-paragraph\"><a href=\"https:\/\/nordestconsulting.com\/es\/politica-de-privacidad\/\">POL\u00cdTICA DE PRIVACIDAD<\/a><\/p>\n\n\n\n<p class=\"has-text-align-center has-contrast-color has-text-color has-link-color wp-elements-6 wp-block-paragraph\"><a href=\"https:\/\/nordestconsulting.com\/es\/kit-digital-2\/\">KIT DIGITAL<\/a><\/p>\n\n<\/div>","protected":false},"excerpt":{"rendered":"<p>En el mundo del an\u00e1lisis de datos con Power BI, la selecci\u00f3n eficiente de fechas es crucial para una visualizaci\u00f3n y manipulaci\u00f3n de datos efectiva. Sin embargo, Power BI carece de un selector de fechas integrado&#8230;<\/p>\n","protected":false},"author":1,"featured_media":608,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[1],"tags":[],"class_list":["post-850","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-uncategorized-ca"],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v24.8.1 - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>Selector de fechas din\u00e1mico en Power BI - Nordest Consulting<\/title>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/nordestconsulting.com\/es\/selector-de-dates-dinamic-a-power-bi\/\" \/>\n<meta property=\"og:locale\" content=\"es_ES\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Selector de fechas din\u00e1mico en Power BI - Nordest Consulting\" \/>\n<meta property=\"og:description\" content=\"En el mundo del an\u00e1lisis de datos con Power BI, la selecci\u00f3n eficiente de fechas es crucial para una visualizaci\u00f3n y manipulaci\u00f3n de datos efectiva. Sin embargo, Power BI carece de un selector de fechas integrado...\" \/>\n<meta property=\"og:url\" content=\"https:\/\/nordestconsulting.com\/es\/selector-de-dates-dinamic-a-power-bi\/\" \/>\n<meta property=\"og:site_name\" content=\"Nordest Consulting\" \/>\n<meta property=\"article:published_time\" content=\"2024-05-15T15:31:15+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2024-05-24T10:04:08+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/nordestconsulting.com\/wp-content\/uploads\/2024\/05\/1715010342694-1024x576.gif\" \/>\n\t<meta property=\"og:image:width\" content=\"1024\" \/>\n\t<meta property=\"og:image:height\" content=\"576\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/gif\" \/>\n<meta name=\"author\" content=\"admin\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Escrito por\" \/>\n\t<meta name=\"twitter:data1\" content=\"admin\" \/>\n\t<meta name=\"twitter:label2\" content=\"Tiempo de lectura\" \/>\n\t<meta name=\"twitter:data2\" content=\"10 minutos\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\/\/nordestconsulting.com\/es\/selector-de-dates-dinamic-a-power-bi\/\",\"url\":\"https:\/\/nordestconsulting.com\/es\/selector-de-dates-dinamic-a-power-bi\/\",\"name\":\"Selector de fechas din\u00e1mico en Power BI - Nordest Consulting\",\"isPartOf\":{\"@id\":\"https:\/\/nordestconsulting.com\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/nordestconsulting.com\/es\/selector-de-dates-dinamic-a-power-bi\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/nordestconsulting.com\/es\/selector-de-dates-dinamic-a-power-bi\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/nordestconsulting.com\/wp-content\/uploads\/2024\/05\/1715010342694.gif\",\"datePublished\":\"2024-05-15T15:31:15+00:00\",\"dateModified\":\"2024-05-24T10:04:08+00:00\",\"author\":{\"@id\":\"https:\/\/nordestconsulting.com\/#\/schema\/person\/984fa426b6a099c8d257531b4059f4e1\"},\"breadcrumb\":{\"@id\":\"https:\/\/nordestconsulting.com\/es\/selector-de-dates-dinamic-a-power-bi\/#breadcrumb\"},\"inLanguage\":\"es\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/nordestconsulting.com\/es\/selector-de-dates-dinamic-a-power-bi\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"es\",\"@id\":\"https:\/\/nordestconsulting.com\/es\/selector-de-dates-dinamic-a-power-bi\/#primaryimage\",\"url\":\"https:\/\/nordestconsulting.com\/wp-content\/uploads\/2024\/05\/1715010342694.gif\",\"contentUrl\":\"https:\/\/nordestconsulting.com\/wp-content\/uploads\/2024\/05\/1715010342694.gif\",\"width\":1152,\"height\":648},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/nordestconsulting.com\/es\/selector-de-dates-dinamic-a-power-bi\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Inici\",\"item\":\"https:\/\/nordestconsulting.com\/es\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Selector de fechas din\u00e1mico en Power BI\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/nordestconsulting.com\/#website\",\"url\":\"https:\/\/nordestconsulting.com\/\",\"name\":\"Nordest Consulting\",\"description\":\"Especialistes en gesti\u00f3 i anal\u00edtica de dades\",\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/nordestconsulting.com\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"es\"},{\"@type\":\"Person\",\"@id\":\"https:\/\/nordestconsulting.com\/#\/schema\/person\/984fa426b6a099c8d257531b4059f4e1\",\"name\":\"admin\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"es\",\"@id\":\"https:\/\/nordestconsulting.com\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/12b4f664de4b7f91bcc922e63f0c4d6ac4fff4f6c2ea1fdb77f1f675ec8bafb8?s=96&d=mm&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/12b4f664de4b7f91bcc922e63f0c4d6ac4fff4f6c2ea1fdb77f1f675ec8bafb8?s=96&d=mm&r=g\",\"caption\":\"admin\"},\"sameAs\":[\"https:\/\/nordestconsulting.com\"],\"url\":\"https:\/\/nordestconsulting.com\/es\/author\/admin\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Selector de fechas din\u00e1mico en Power BI - Nordest Consulting","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:\/\/nordestconsulting.com\/es\/selector-de-dates-dinamic-a-power-bi\/","og_locale":"es_ES","og_type":"article","og_title":"Selector de fechas din\u00e1mico en Power BI - Nordest Consulting","og_description":"En el mundo del an\u00e1lisis de datos con Power BI, la selecci\u00f3n eficiente de fechas es crucial para una visualizaci\u00f3n y manipulaci\u00f3n de datos efectiva. Sin embargo, Power BI carece de un selector de fechas integrado...","og_url":"https:\/\/nordestconsulting.com\/es\/selector-de-dates-dinamic-a-power-bi\/","og_site_name":"Nordest Consulting","article_published_time":"2024-05-15T15:31:15+00:00","article_modified_time":"2024-05-24T10:04:08+00:00","og_image":[{"width":1024,"height":576,"url":"https:\/\/nordestconsulting.com\/wp-content\/uploads\/2024\/05\/1715010342694-1024x576.gif","type":"image\/gif"}],"author":"admin","twitter_card":"summary_large_image","twitter_misc":{"Escrito por":"admin","Tiempo de lectura":"10 minutos"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/nordestconsulting.com\/es\/selector-de-dates-dinamic-a-power-bi\/","url":"https:\/\/nordestconsulting.com\/es\/selector-de-dates-dinamic-a-power-bi\/","name":"Selector de fechas din\u00e1mico en Power BI - Nordest Consulting","isPartOf":{"@id":"https:\/\/nordestconsulting.com\/#website"},"primaryImageOfPage":{"@id":"https:\/\/nordestconsulting.com\/es\/selector-de-dates-dinamic-a-power-bi\/#primaryimage"},"image":{"@id":"https:\/\/nordestconsulting.com\/es\/selector-de-dates-dinamic-a-power-bi\/#primaryimage"},"thumbnailUrl":"https:\/\/nordestconsulting.com\/wp-content\/uploads\/2024\/05\/1715010342694.gif","datePublished":"2024-05-15T15:31:15+00:00","dateModified":"2024-05-24T10:04:08+00:00","author":{"@id":"https:\/\/nordestconsulting.com\/#\/schema\/person\/984fa426b6a099c8d257531b4059f4e1"},"breadcrumb":{"@id":"https:\/\/nordestconsulting.com\/es\/selector-de-dates-dinamic-a-power-bi\/#breadcrumb"},"inLanguage":"es","potentialAction":[{"@type":"ReadAction","target":["https:\/\/nordestconsulting.com\/es\/selector-de-dates-dinamic-a-power-bi\/"]}]},{"@type":"ImageObject","inLanguage":"es","@id":"https:\/\/nordestconsulting.com\/es\/selector-de-dates-dinamic-a-power-bi\/#primaryimage","url":"https:\/\/nordestconsulting.com\/wp-content\/uploads\/2024\/05\/1715010342694.gif","contentUrl":"https:\/\/nordestconsulting.com\/wp-content\/uploads\/2024\/05\/1715010342694.gif","width":1152,"height":648},{"@type":"BreadcrumbList","@id":"https:\/\/nordestconsulting.com\/es\/selector-de-dates-dinamic-a-power-bi\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Inici","item":"https:\/\/nordestconsulting.com\/es\/"},{"@type":"ListItem","position":2,"name":"Selector de fechas din\u00e1mico en Power BI"}]},{"@type":"WebSite","@id":"https:\/\/nordestconsulting.com\/#website","url":"https:\/\/nordestconsulting.com\/","name":"Nordest Consulting","description":"Especialistes en gesti\u00f3 i anal\u00edtica de dades","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/nordestconsulting.com\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"es"},{"@type":"Person","@id":"https:\/\/nordestconsulting.com\/#\/schema\/person\/984fa426b6a099c8d257531b4059f4e1","name":"admin","image":{"@type":"ImageObject","inLanguage":"es","@id":"https:\/\/nordestconsulting.com\/#\/schema\/person\/image\/","url":"https:\/\/secure.gravatar.com\/avatar\/12b4f664de4b7f91bcc922e63f0c4d6ac4fff4f6c2ea1fdb77f1f675ec8bafb8?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/12b4f664de4b7f91bcc922e63f0c4d6ac4fff4f6c2ea1fdb77f1f675ec8bafb8?s=96&d=mm&r=g","caption":"admin"},"sameAs":["https:\/\/nordestconsulting.com"],"url":"https:\/\/nordestconsulting.com\/es\/author\/admin\/"}]}},"_links":{"self":[{"href":"https:\/\/nordestconsulting.com\/es\/wp-json\/wp\/v2\/posts\/850","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/nordestconsulting.com\/es\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/nordestconsulting.com\/es\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/nordestconsulting.com\/es\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/nordestconsulting.com\/es\/wp-json\/wp\/v2\/comments?post=850"}],"version-history":[{"count":3,"href":"https:\/\/nordestconsulting.com\/es\/wp-json\/wp\/v2\/posts\/850\/revisions"}],"predecessor-version":[{"id":990,"href":"https:\/\/nordestconsulting.com\/es\/wp-json\/wp\/v2\/posts\/850\/revisions\/990"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/nordestconsulting.com\/es\/wp-json\/wp\/v2\/media\/608"}],"wp:attachment":[{"href":"https:\/\/nordestconsulting.com\/es\/wp-json\/wp\/v2\/media?parent=850"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/nordestconsulting.com\/es\/wp-json\/wp\/v2\/categories?post=850"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/nordestconsulting.com\/es\/wp-json\/wp\/v2\/tags?post=850"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}