{"id":84200,"date":"2022-07-05T20:35:07","date_gmt":"2022-07-05T18:35:07","guid":{"rendered":"https:\/\/rmarketingdigital.com\/powerbi\/funciones-de-fecha-de-power-bi-dax\/"},"modified":"2020-09-17T07:14:26","modified_gmt":"2020-09-17T10:14:26","slug":"funciones-de-fecha-de-power-bi-dax","status":"publish","type":"post","link":"https:\/\/rmarketingdigital.com\/de\/energiebi\/funciones-de-fecha-de-power-bi-dax\/","title":{"rendered":"Power BI DAX-Datumsfunktionen"},"content":{"rendered":"<div id=\"ez-toc-container\" class=\"ez-toc-v2_0_86 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\">Contenidos<\/p>\n<span class=\"ez-toc-title-toggle\"><a href=\"#\" class=\"ez-toc-pull-right ez-toc-btn ez-toc-btn-xs ez-toc-btn-default ez-toc-toggle\" aria-label=\"Toggle Table of Content\"><span class=\"ez-toc-js-icon-con\"><span class=\"\"><span class=\"eztoc-hide\" style=\"display:none;\">Toggle<\/span><span class=\"ez-toc-icon-toggle-span\"><svg style=\"fill: #999;color:#999\" xmlns=\"http:\/\/www.w3.org\/2000\/svg\" class=\"list-377408\" width=\"20px\" height=\"20px\" viewBox=\"0 0 24 24\" fill=\"none\"><path d=\"M6 6H4v2h2V6zm14 0H8v2h12V6zM4 11h2v2H4v-2zm16 0H8v2h12v-2zM4 16h2v2H4v-2zm16 0H8v2h12v-2z\" fill=\"currentColor\"><\/path><\/svg><svg style=\"fill: #999;color:#999\" class=\"arrow-unsorted-368013\" xmlns=\"http:\/\/www.w3.org\/2000\/svg\" width=\"10px\" height=\"10px\" viewBox=\"0 0 24 24\" version=\"1.2\" baseProfile=\"tiny\"><path d=\"M18.2 9.3l-6.2-6.3-6.2 6.3c-.2.2-.3.4-.3.7s.1.5.3.7c.2.2.4.3.7.3h11c.3 0 .5-.1.7-.3.2-.2.3-.5.3-.7s-.1-.5-.3-.7zM5.8 14.7l6.2 6.3 6.2-6.3c.2-.2.3-.5.3-.7s-.1-.5-.3-.7c-.2-.2-.4-.3-.7-.3h-11c-.3 0-.5.1-.7.3-.2.2-.3.5-.3.7s.1.5.3.7z\"\/><\/svg><\/span><\/span><\/span><\/a><\/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:\/\/rmarketingdigital.com\/de\/energiebi\/funciones-de-fecha-de-power-bi-dax\/#Funciones-de-fecha-de-Power-BI-DAX\" >Funciones de fecha de Power BI DAX<\/a><ul class='ez-toc-list-level-3' ><li class='ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-2\" href=\"https:\/\/rmarketingdigital.com\/de\/energiebi\/funciones-de-fecha-de-power-bi-dax\/#Funcion-Power-BI-DAX-NOW\" >Funci\u00f3n Power BI DAX NOW<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-3\" href=\"https:\/\/rmarketingdigital.com\/de\/energiebi\/funciones-de-fecha-de-power-bi-dax\/#Funcion-Power-BI-DAX-DAY\" >Funci\u00f3n Power BI DAX DAY<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-4\" href=\"https:\/\/rmarketingdigital.com\/de\/energiebi\/funciones-de-fecha-de-power-bi-dax\/#Funcion-MES-de-Power-BI-DAX\" >Funci\u00f3n MES de Power BI DAX<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-5\" href=\"https:\/\/rmarketingdigital.com\/de\/energiebi\/funciones-de-fecha-de-power-bi-dax\/#Funcion-Power-BI-DAX-YEAR\" >Funci\u00f3n Power BI DAX YEAR<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-6\" href=\"https:\/\/rmarketingdigital.com\/de\/energiebi\/funciones-de-fecha-de-power-bi-dax\/#Funcion-Power-BI-DAX-HOUR\" >Funci\u00f3n Power BI DAX HOUR<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-7\" href=\"https:\/\/rmarketingdigital.com\/de\/energiebi\/funciones-de-fecha-de-power-bi-dax\/#Funcion-MINUTE-de-Power-BI-DAX\" >Funci\u00f3n MINUTE de Power BI DAX<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-8\" href=\"https:\/\/rmarketingdigital.com\/de\/energiebi\/funciones-de-fecha-de-power-bi-dax\/#Funcion-SEGUNDA-de-Power-BI-DAX\" >Funci\u00f3n SEGUNDA de Power BI DAX<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-9\" href=\"https:\/\/rmarketingdigital.com\/de\/energiebi\/funciones-de-fecha-de-power-bi-dax\/#Funcion-Power-BI-DAX-TODAY\" >Funci\u00f3n Power BI DAX TODAY<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-10\" href=\"https:\/\/rmarketingdigital.com\/de\/energiebi\/funciones-de-fecha-de-power-bi-dax\/#Funcion-Power-BI-DAX-DATE\" >Funci\u00f3n Power BI DAX DATE<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-11\" href=\"https:\/\/rmarketingdigital.com\/de\/energiebi\/funciones-de-fecha-de-power-bi-dax\/#Funcion-Power-BI-DAX-TIME\" >Funci\u00f3n Power BI DAX TIME<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-12\" href=\"https:\/\/rmarketingdigital.com\/de\/energiebi\/funciones-de-fecha-de-power-bi-dax\/#Funcion-de-dia-de-la-semana-de-Power-BI-DAX\" >Funci\u00f3n de d\u00eda de la semana de Power BI DAX<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-13\" href=\"https:\/\/rmarketingdigital.com\/de\/energiebi\/funciones-de-fecha-de-power-bi-dax\/#Funcion-WeekNum-de-Power-BI-DAX\" >Funci\u00f3n WeekNum de Power BI DAX<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-14\" href=\"https:\/\/rmarketingdigital.com\/de\/energiebi\/funciones-de-fecha-de-power-bi-dax\/#Funcion-UTCNOW-de-Power-BI-DAX\" >Funci\u00f3n UTCNOW de Power BI DAX<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-15\" href=\"https:\/\/rmarketingdigital.com\/de\/energiebi\/funciones-de-fecha-de-power-bi-dax\/#Funcion-Power-BI-DAX-UTCTODAY\" >Funci\u00f3n Power BI DAX UTCTODAY<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-16\" href=\"https:\/\/rmarketingdigital.com\/de\/energiebi\/funciones-de-fecha-de-power-bi-dax\/#Funcion-Power-BI-DAX-YEARFRAC\" >Funci\u00f3n Power BI DAX YEARFRAC<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-17\" href=\"https:\/\/rmarketingdigital.com\/de\/energiebi\/funciones-de-fecha-de-power-bi-dax\/#Funcion-EDATE-de-Power-BI-DAX\" >Funci\u00f3n EDATE de Power BI DAX<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-18\" href=\"https:\/\/rmarketingdigital.com\/de\/energiebi\/funciones-de-fecha-de-power-bi-dax\/#Funcion-Power-BI-DAX-EOMONTH\" >Funci\u00f3n Power BI DAX EOMONTH<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-19\" href=\"https:\/\/rmarketingdigital.com\/de\/energiebi\/funciones-de-fecha-de-power-bi-dax\/#Funcion-Power-BI-DAX-DATEDIFF\" >Funci\u00f3n Power BI DAX DATEDIFF<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-20\" href=\"https:\/\/rmarketingdigital.com\/de\/energiebi\/funciones-de-fecha-de-power-bi-dax\/#Funcion-Power-BI-DAX-DATEVALUE\" >Funci\u00f3n Power BI DAX DATEVALUE<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-21\" href=\"https:\/\/rmarketingdigital.com\/de\/energiebi\/funciones-de-fecha-de-power-bi-dax\/#Funcion-de-Power-BI-DAX-TIMEVALUE\" >Funci\u00f3n de Power BI DAX TIMEVALUE<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-22\" href=\"https:\/\/rmarketingdigital.com\/de\/energiebi\/funciones-de-fecha-de-power-bi-dax\/#Funcion-CALENDARIO-de-Power-BI-DAX\" >Funci\u00f3n CALENDARIO de Power BI DAX<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-23\" href=\"https:\/\/rmarketingdigital.com\/de\/energiebi\/funciones-de-fecha-de-power-bi-dax\/#Funcion-Power-BI-DAX-CALENDARAUTO\" >Funci\u00f3n Power BI DAX CALENDARAUTO<\/a><\/li><\/ul><\/li><\/ul><\/nav><\/div>\n<div>\n<p>\u00bfC\u00f3mo usar las funciones de fecha de Power BI DAX con ejemplos?  Microsoft Power BI DAX proporciona varias funciones de fecha, como a\u00f1o, mes, d\u00eda, calendario, fecha, hora, dateiff, ahora, hoy, utcnow, utctoday, datevalue, timevalue, etc.<\/p>\n<p><span id=\"ezoic-pub-ad-placeholder-104\"\/><span style=\"display:block !important;float:none !important;margin-bottom:15px !important;margin-left:0px !important;margin-right:0px !important;margin-top:15px !important;min-height:90px;min-width:728px;text-align:center !important;\" class=\"ezoic-ad medrectangle-3 adtester-container adtester-container-104\" data-ez-name=\"tutorialgateway_org-medrectangle-3\"><span id=\"div-gpt-ad-tutorialgateway_org-medrectangle-3-0\" ezaw=\"728\" ezah=\"90\" style=\"position:relative;z-index:0;display:inline-block;width:100%;max-width:1200px;margin-left:auto !important;margin-right:auto !important;min-height:90px;min-width:728px;\" class=\"ezoic-ad\"\/><\/span><\/p>\n<p>Para demostrar estas funciones de Power BI DAX Date, usamos los datos que se muestran a continuaci\u00f3n.  Como puede ver, hay 15 registros en esta tabla.<\/p>\n<figure class=\"wp-block-image\"><img alt='power-bi-dax-date-functions-1-7298587' width='1061' height='659' alt=\"Funciones de fecha de Power BI DAX 1\" class=\"wp-image-32909\" srcset='\/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Power-BI-DAX-Date-Functions-1-7298587.png 1061w, \/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Power-BI-DAX-Date-Functions-1-7298587-300x186.png 300w, \/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Power-BI-DAX-Date-Functions-1-7298587-1024x636.png 1024w, \/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Power-BI-DAX-Date-Functions-1-7298587-768x477.png 768w' data-lazy-sizes='(max-width: 1061px) 100vw, 1061px' src='https:\/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Power-BI-DAX-Date-Functions-1-7298587.png'\/><noscript><img alt='power-bi-dax-date-functions-1-7298587' width='1061' height='659' src='https:\/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Power-BI-DAX-Date-Functions-1-7298587.png' alt=\"Funciones de fecha de Power BI DAX 1\" class=\"wp-image-32909\" srcset='\/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Power-BI-DAX-Date-Functions-1-7298587.png 1061w, \/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Power-BI-DAX-Date-Functions-1-7298587-300x186.png 300w, \/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Power-BI-DAX-Date-Functions-1-7298587-1024x636.png 1024w, \/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Power-BI-DAX-Date-Functions-1-7298587-768x477.png 768w' sizes='(max-width: 1061px) 100vw, 1061px'\/><\/noscript><\/figure>\n<h2><span class=\"ez-toc-section\" id=\"Funciones-de-fecha-de-Power-BI-DAX\"><\/span>Funciones de fecha de Power BI DAX<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p>La siguiente serie de ejemplos muestra la lista de funciones de fecha DAX en Power BI<\/p>\n<h3><span class=\"ez-toc-section\" id=\"Funcion-Power-BI-DAX-NOW\"><\/span>Funci\u00f3n Power BI DAX NOW<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p>La funci\u00f3n Power BI DAX Now es una de las funciones de fecha de Power BI, que se utiliza para devolver la fecha y hora actuales.  La sintaxis de este Power BI DAX NOW es<\/p>\n<pre class=\"wp-block-preformatted lang:tsql decode:true\">NOW()<\/pre>\n<p>Para demostrar las funciones de Power BI DAX NOW, tenemos que usar la columna Calculado.  Para crear una columna, haga clic en el <strong>Nueva columna<\/strong> opci\u00f3n bajo la <strong>Hogar<\/strong> pesta\u00f1a, o <strong>Modelado <\/strong>leng\u00fceta.<\/p>\n<p><span id=\"ezoic-pub-ad-placeholder-105\"\/><span style=\"display:block !important;float:none !important;margin-bottom:15px !important;margin-left:0px !important;margin-right:0px !important;margin-top:15px !important;min-height:400px;min-width:580px;text-align:center !important;\" class=\"ezoic-ad box-4 adtester-container adtester-container-105\" data-ez-name=\"tutorialgateway_org-box-4\"><span id=\"div-gpt-ad-tutorialgateway_org-box-4-0\" ezaw=\"580\" ezah=\"400\" style=\"position:relative;z-index:0;display:inline-block;width:100%;max-width:1200px;margin-left:auto !important;margin-right:auto !important;min-height:400px;min-width:580px;\" class=\"ezoic-ad ezoic-adl\"\/><\/span><\/p>\n<figure class=\"wp-block-image\"><img alt='power-bi-dax-date-functions-2-2668610' width='1031' height='702' alt=\"Funciones de fecha 2 de Power BI DAX\" class=\"wp-image-32910\" srcset='\/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Power-BI-DAX-Date-Functions-2-2668610.png 1031w, \/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Power-BI-DAX-Date-Functions-2-2668610-300x204.png 300w, \/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Power-BI-DAX-Date-Functions-2-2668610-1024x697.png 1024w, \/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Power-BI-DAX-Date-Functions-2-2668610-768x523.png 768w' data-lazy-sizes='(max-width: 1031px) 100vw, 1031px' src='https:\/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Power-BI-DAX-Date-Functions-2-2668610.png'\/><noscript><img alt='power-bi-dax-date-functions-2-2668610' width='1031' height='702' src='https:\/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Power-BI-DAX-Date-Functions-2-2668610.png' alt=\"Funciones de fecha 2 de Power BI DAX\" class=\"wp-image-32910\" srcset='\/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Power-BI-DAX-Date-Functions-2-2668610.png 1031w, \/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Power-BI-DAX-Date-Functions-2-2668610-300x204.png 300w, \/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Power-BI-DAX-Date-Functions-2-2668610-1024x697.png 1024w, \/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Power-BI-DAX-Date-Functions-2-2668610-768x523.png 768w' sizes='(max-width: 1031px) 100vw, 1031px'\/><\/noscript><\/figure>\n<p>Cambiamos el nombre del nombre de columna predeterminado como Hoy.  Como puede ver en la captura de pantalla siguiente, mientras escrib\u00eda, Power BI muestra las sugerencias.<\/p>\n<figure class=\"wp-block-image\"><img alt='power-bi-dax-date-functions-3-9376601' width='1031' height='703' alt=\"Funciones de fecha 3 de Power BI DAX\" class=\"wp-image-32911\" srcset='\/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Power-BI-DAX-Date-Functions-3-9376601.png 1031w, \/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Power-BI-DAX-Date-Functions-3-9376601-300x205.png 300w, \/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Power-BI-DAX-Date-Functions-3-9376601-1024x698.png 1024w, \/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Power-BI-DAX-Date-Functions-3-9376601-768x524.png 768w' data-lazy-sizes='(max-width: 1031px) 100vw, 1031px' src='https:\/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Power-BI-DAX-Date-Functions-3-9376601.png'\/><noscript><img alt='power-bi-dax-date-functions-3-9376601' width='1031' height='703' src='https:\/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Power-BI-DAX-Date-Functions-3-9376601.png' alt=\"Funciones de fecha 3 de Power BI DAX\" class=\"wp-image-32911\" srcset='\/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Power-BI-DAX-Date-Functions-3-9376601.png 1031w, \/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Power-BI-DAX-Date-Functions-3-9376601-300x205.png 300w, \/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Power-BI-DAX-Date-Functions-3-9376601-1024x698.png 1024w, \/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Power-BI-DAX-Date-Functions-3-9376601-768x524.png 768w' sizes='(max-width: 1031px) 100vw, 1031px'\/><\/noscript><\/figure>\n<p>Al hacer clic en Intro o en cualquier tecla, se crea una nueva columna.<\/p>\n<figure class=\"wp-block-image\"><img alt='power-bi-dax-date-functions-4-3100626' width='956' height='668' alt=\"Funci\u00f3n 4 de Power BI DAX NOW\" class=\"wp-image-32912\" srcset='\/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Power-BI-DAX-Date-Functions-4-3100626.png 956w, \/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Power-BI-DAX-Date-Functions-4-3100626-300x210.png 300w, \/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Power-BI-DAX-Date-Functions-4-3100626-768x537.png 768w' data-lazy-sizes='(max-width: 956px) 100vw, 956px' src='https:\/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Power-BI-DAX-Date-Functions-4-3100626.png'\/><noscript><img alt='power-bi-dax-date-functions-4-3100626' width='956' height='668' src='https:\/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Power-BI-DAX-Date-Functions-4-3100626.png' alt=\"Funci\u00f3n 4 de Power BI DAX NOW\" class=\"wp-image-32912\" srcset='\/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Power-BI-DAX-Date-Functions-4-3100626.png 956w, \/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Power-BI-DAX-Date-Functions-4-3100626-300x210.png 300w, \/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Power-BI-DAX-Date-Functions-4-3100626-768x537.png 768w' sizes='(max-width: 956px) 100vw, 956px'\/><\/noscript><\/figure>\n<p>Perm\u00edtanme agregar esta columna a la tabla que creamos anteriormente.  Consulte el art\u00edculo Crear informe de tabla para comprender los pasos necesarios para crear una tabla.<\/p>\n<figure class=\"wp-block-image\"><img alt='power-bi-dax-date-functions-5-8230769' width='979' height='606' alt=\"Funci\u00f3n 5 de Power BI DAX NOW\" class=\"wp-image-32913\" srcset='\/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Power-BI-DAX-Date-Functions-5-8230769.png 979w, \/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Power-BI-DAX-Date-Functions-5-8230769-300x186.png 300w, \/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Power-BI-DAX-Date-Functions-5-8230769-768x475.png 768w' data-lazy-sizes='(max-width: 979px) 100vw, 979px' src='https:\/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Power-BI-DAX-Date-Functions-5-8230769.png'\/><noscript><img alt='power-bi-dax-date-functions-5-8230769' width='979' height='606' src='https:\/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Power-BI-DAX-Date-Functions-5-8230769.png' alt=\"Funci\u00f3n 5 de Power BI DAX NOW\" class=\"wp-image-32913\" srcset='\/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Power-BI-DAX-Date-Functions-5-8230769.png 979w, \/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Power-BI-DAX-Date-Functions-5-8230769-300x186.png 300w, \/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Power-BI-DAX-Date-Functions-5-8230769-768x475.png 768w' sizes='(max-width: 979px) 100vw, 979px'\/><\/noscript><\/figure>\n<p>Como puede ver en la captura de pantalla anterior, muestra la fecha y hora de hoy.<\/p>\n<h3><span class=\"ez-toc-section\" id=\"Funcion-Power-BI-DAX-DAY\"><\/span>Funci\u00f3n Power BI DAX DAY<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p>La funci\u00f3n D\u00cdA de Power BI DAX extrae o devuelve el n\u00famero de d\u00eda de la fecha indicada.  La sintaxis de la funci\u00f3n Power BI DAX DAY es<\/p>\n<pre class=\"wp-block-preformatted lang:tsql decode:true\">DAY(Date)<\/pre>\n<p>Perm\u00edtame crear una columna para devolver el n\u00famero de d\u00eda de la columna Fecha de contrataci\u00f3n<\/p>\n<pre class=\"wp-block-preformatted lang:tsql decode:true\">DayinDate = DAY(EmployeeSales[HireDate])<\/pre>\n<figure class=\"wp-block-image\"><img alt='power-bi-dax-date-functions-6-3281288' width='946' height='587' alt=\"Funci\u00f3n 6 de Power BI DAX DAY\" class=\"wp-image-32914\" srcset='\/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Power-BI-DAX-Date-Functions-6-3281288.png 946w, \/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Power-BI-DAX-Date-Functions-6-3281288-300x186.png 300w, \/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Power-BI-DAX-Date-Functions-6-3281288-768x477.png 768w' data-lazy-sizes='(max-width: 946px) 100vw, 946px' src='https:\/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Power-BI-DAX-Date-Functions-6-3281288.png'\/><noscript><img alt='power-bi-dax-date-functions-6-3281288' width='946' height='587' src='https:\/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Power-BI-DAX-Date-Functions-6-3281288.png' alt=\"Funci\u00f3n 6 de Power BI DAX DAY\" class=\"wp-image-32914\" srcset='\/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Power-BI-DAX-Date-Functions-6-3281288.png 946w, \/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Power-BI-DAX-Date-Functions-6-3281288-300x186.png 300w, \/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Power-BI-DAX-Date-Functions-6-3281288-768x477.png 768w' sizes='(max-width: 946px) 100vw, 946px'\/><\/noscript><\/figure>\n<h3><span class=\"ez-toc-section\" id=\"Funcion-MES-de-Power-BI-DAX\"><\/span>Funci\u00f3n MES de Power BI DAX<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p>La funci\u00f3n de mes de Power BI DAX devuelve el n\u00famero de mes a partir de una fecha determinada.  La sintaxis de la funci\u00f3n Power BI DAX MONTH es<\/p>\n<pre class=\"wp-block-preformatted lang:tsql decode:true\">MONTH(Date)<\/pre>\n<p>Perm\u00edtame crear una columna para devolver el n\u00famero de mes de la columna Fecha de contrataci\u00f3n<\/p>\n<pre class=\"wp-block-preformatted lang:tsql decode:true\">MonthinDate = MONTH(EmployeeSales[HireDate])<\/pre>\n<p>Aqu\u00ed, agregamos el resultado de una funci\u00f3n anterior (funci\u00f3n de d\u00eda) a la Tabla.<\/p>\n<figure class=\"wp-block-image\"><img alt='power-bi-dax-date-functions-7-6639266' width='946' height='658' alt=\"Funci\u00f3n 7 de Power BI DAX MONTH\" class=\"wp-image-32915\" srcset='\/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Power-BI-DAX-Date-Functions-7-6639266.png 946w, \/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Power-BI-DAX-Date-Functions-7-6639266-300x209.png 300w, \/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Power-BI-DAX-Date-Functions-7-6639266-768x534.png 768w' data-lazy-sizes='(max-width: 946px) 100vw, 946px' src='https:\/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Power-BI-DAX-Date-Functions-7-6639266.png'\/><noscript><img alt='power-bi-dax-date-functions-7-6639266' width='946' height='658' src='https:\/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Power-BI-DAX-Date-Functions-7-6639266.png' alt=\"Funci\u00f3n 7 de Power BI DAX MONTH\" class=\"wp-image-32915\" srcset='\/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Power-BI-DAX-Date-Functions-7-6639266.png 946w, \/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Power-BI-DAX-Date-Functions-7-6639266-300x209.png 300w, \/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Power-BI-DAX-Date-Functions-7-6639266-768x534.png 768w' sizes='(max-width: 946px) 100vw, 946px'\/><\/noscript><\/figure>\n<h3><span class=\"ez-toc-section\" id=\"Funcion-Power-BI-DAX-YEAR\"><\/span>Funci\u00f3n Power BI DAX YEAR<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p>La funci\u00f3n Power BI DAX YEAR extrae o devuelve el n\u00famero de a\u00f1o de la fecha indicada.  La sintaxis de este Power BI DAX YEAR:<span id=\"ezoic-pub-ad-placeholder-106\" class=\"ezoic-adpicker-ad\"\/><span style=\"display:block !important;float:none;margin-bottom:15px !important;margin-left:0px !important;margin-right:0px !important;margin-top:15px !important;min-height:250px;min-width:300px;text-align:center !important;\" class=\"ezoic-ad banner-1 adtester-container adtester-container-106\" data-ez-name=\"tutorialgateway_org-banner-1\"><span id=\"div-gpt-ad-tutorialgateway_org-banner-1-0\" ezaw=\"300\" ezah=\"250\" style=\"position:relative;z-index:0;display:inline-block;min-height:250px;min-width:300px;\" class=\"ezoic-ad\"\/><\/span><\/p>\n<pre class=\"wp-block-preformatted lang:tsql decode:true\">YEAR(Date)<\/pre>\n<p>Perm\u00edtanme crear una columna para devolver el a\u00f1o de la columna de fecha de contrataci\u00f3n<\/p>\n<pre class=\"wp-block-preformatted lang:tsql decode:true\">YearInDt = YEAR(EmployeeSales[HireDate])<\/pre>\n<figure class=\"wp-block-image\"><img alt='power-bi-dax-date-functions-8-3528892' width='946' height='590' alt=\"Funci\u00f3n 4 de Power BI DAX YEAR\" class=\"wp-image-32916\" srcset='\/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Power-BI-DAX-Date-Functions-8-3528892.png 946w, \/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Power-BI-DAX-Date-Functions-8-3528892-300x187.png 300w, \/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Power-BI-DAX-Date-Functions-8-3528892-768x479.png 768w' data-lazy-sizes='(max-width: 946px) 100vw, 946px' src='https:\/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Power-BI-DAX-Date-Functions-8-3528892.png'\/><noscript><img alt='power-bi-dax-date-functions-8-3528892' width='946' height='590' src='https:\/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Power-BI-DAX-Date-Functions-8-3528892.png' alt=\"Funci\u00f3n 4 de Power BI DAX YEAR\" class=\"wp-image-32916\" srcset='\/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Power-BI-DAX-Date-Functions-8-3528892.png 946w, \/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Power-BI-DAX-Date-Functions-8-3528892-300x187.png 300w, \/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Power-BI-DAX-Date-Functions-8-3528892-768x479.png 768w' sizes='(max-width: 946px) 100vw, 946px'\/><\/noscript><\/figure>\n<h3><span class=\"ez-toc-section\" id=\"Funcion-Power-BI-DAX-HOUR\"><\/span>Funci\u00f3n Power BI DAX HOUR<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p>La funci\u00f3n HORA de Power BI DAX devuelve Horas (en formato de 24 horas) desde una fecha determinada.  La sintaxis de la funci\u00f3n Power BI DAX HOUR es:<\/p>\n<pre class=\"wp-block-preformatted lang:tsql decode:true\">HOUR(DateTime)<\/pre>\n<p>Perm\u00edtanme crear una columna para devolver las horas de la columna de fecha de contrataci\u00f3n<\/p>\n<pre class=\"wp-block-preformatted lang:tsql decode:true\">Hour = HOUR(EmployeeSales[HireDate])<\/pre>\n<figure class=\"wp-block-image\"><img alt='power-bi-dax-date-functions-9-3665215' width='946' height='659' alt=\"Funci\u00f3n 9 de Power BI DAX HOUR\" class=\"wp-image-32917\" srcset='\/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Power-BI-DAX-Date-Functions-9-3665215.png 946w, \/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Power-BI-DAX-Date-Functions-9-3665215-300x209.png 300w, \/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Power-BI-DAX-Date-Functions-9-3665215-768x535.png 768w' data-lazy-sizes='(max-width: 946px) 100vw, 946px' src='https:\/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Power-BI-DAX-Date-Functions-9-3665215.png'\/><noscript><img alt='power-bi-dax-date-functions-9-3665215' width='946' height='659' src='https:\/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Power-BI-DAX-Date-Functions-9-3665215.png' alt=\"Funci\u00f3n 9 de Power BI DAX HOUR\" class=\"wp-image-32917\" srcset='\/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Power-BI-DAX-Date-Functions-9-3665215.png 946w, \/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Power-BI-DAX-Date-Functions-9-3665215-300x209.png 300w, \/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Power-BI-DAX-Date-Functions-9-3665215-768x535.png 768w' sizes='(max-width: 946px) 100vw, 946px'\/><\/noscript><\/figure>\n<h3><span class=\"ez-toc-section\" id=\"Funcion-MINUTE-de-Power-BI-DAX\"><\/span>Funci\u00f3n MINUTE de Power BI DAX<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p>La funci\u00f3n MINUTO de Power BI DAX devuelve el n\u00famero de minutos.  La sintaxis de este Power BI DAX MINUTE es:<\/p>\n<pre class=\"wp-block-preformatted lang:tsql decode:true\">MINUTE(DateTime)<\/pre>\n<p>Perm\u00edtame crear una columna para devolver la cantidad de minutos de la columna Fecha de contrataci\u00f3n<\/p>\n<pre class=\"wp-block-preformatted lang:tsql decode:true\">Min = MINUTE(EmployeeSales[HireDate])<\/pre>\n<figure class=\"wp-block-image\"><img alt='power-bi-dax-date-functions-10-4700845' width='946' height='658' alt=\"Funci\u00f3n 10 de Power BI DAX MINUTE\" class=\"wp-image-32918\" srcset='\/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Power-BI-DAX-Date-Functions-10-4700845.png 946w, \/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Power-BI-DAX-Date-Functions-10-4700845-300x209.png 300w, \/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Power-BI-DAX-Date-Functions-10-4700845-768x534.png 768w' data-lazy-sizes='(max-width: 946px) 100vw, 946px' src='https:\/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Power-BI-DAX-Date-Functions-10-4700845.png'\/><noscript><img alt='power-bi-dax-date-functions-10-4700845' width='946' height='658' src='https:\/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Power-BI-DAX-Date-Functions-10-4700845.png' alt=\"Funci\u00f3n 10 de Power BI DAX MINUTE\" class=\"wp-image-32918\" srcset='\/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Power-BI-DAX-Date-Functions-10-4700845.png 946w, \/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Power-BI-DAX-Date-Functions-10-4700845-300x209.png 300w, \/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Power-BI-DAX-Date-Functions-10-4700845-768x534.png 768w' sizes='(max-width: 946px) 100vw, 946px'\/><\/noscript><\/figure>\n<h3><span class=\"ez-toc-section\" id=\"Funcion-SEGUNDA-de-Power-BI-DAX\"><\/span>Funci\u00f3n SEGUNDA de Power BI DAX<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p>La funci\u00f3n SEGUNDO de Power BI DAX devuelve el n\u00famero de segundos.  La sintaxis de este Power BI DAX SEGUNDO es:<\/p>\n<pre class=\"wp-block-preformatted lang:tsql decode:true\">SECOND(DateTime)<\/pre>\n<p>Perm\u00edtame crear una columna para devolver el n\u00famero de segundos de la columna Fecha de contrataci\u00f3n<\/p>\n<pre class=\"wp-block-preformatted lang:tsql decode:true\">Sec = SECOND(EmployeeSales[HireDate])<\/pre>\n<figure class=\"wp-block-image\"><img alt='power-bi-dax-date-functions-11-1583272' width='946' height='657' alt=\"Funci\u00f3n 11 de Power BI DAX SECOND\" class=\"wp-image-32919\" srcset='\/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Power-BI-DAX-Date-Functions-11-1583272.png 946w, \/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Power-BI-DAX-Date-Functions-11-1583272-300x208.png 300w, \/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Power-BI-DAX-Date-Functions-11-1583272-768x533.png 768w' data-lazy-sizes='(max-width: 946px) 100vw, 946px' src='https:\/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Power-BI-DAX-Date-Functions-11-1583272.png'\/><noscript><img alt='power-bi-dax-date-functions-11-1583272' width='946' height='657' src='https:\/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Power-BI-DAX-Date-Functions-11-1583272.png' alt=\"Funci\u00f3n 11 de Power BI DAX SECOND\" class=\"wp-image-32919\" srcset='\/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Power-BI-DAX-Date-Functions-11-1583272.png 946w, \/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Power-BI-DAX-Date-Functions-11-1583272-300x208.png 300w, \/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Power-BI-DAX-Date-Functions-11-1583272-768x533.png 768w' sizes='(max-width: 946px) 100vw, 946px'\/><\/noscript><\/figure>\n<p>Perm\u00edtanme agregar los resultados de las funciones A\u00f1o, Mes, D\u00eda, Hora, Minuto y Segundo a la tabla.<\/p>\n<figure class=\"wp-block-image\"><img alt='power-bi-dax-date-functions-12-6935550' width='995' height='652' alt=\"Funciones de Power BI DAX DATE 12\" class=\"wp-image-32920\" srcset='\/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Power-BI-DAX-Date-Functions-12-6935550.png 995w, \/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Power-BI-DAX-Date-Functions-12-6935550-300x197.png 300w, \/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Power-BI-DAX-Date-Functions-12-6935550-768x503.png 768w' data-lazy-sizes='(max-width: 995px) 100vw, 995px' src='https:\/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Power-BI-DAX-Date-Functions-12-6935550.png'\/><noscript><img alt='power-bi-dax-date-functions-12-6935550' width='995' height='652' src='https:\/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Power-BI-DAX-Date-Functions-12-6935550.png' alt=\"Funciones de Power BI DAX DATE 12\" class=\"wp-image-32920\" srcset='\/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Power-BI-DAX-Date-Functions-12-6935550.png 995w, \/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Power-BI-DAX-Date-Functions-12-6935550-300x197.png 300w, \/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Power-BI-DAX-Date-Functions-12-6935550-768x503.png 768w' sizes='(max-width: 995px) 100vw, 995px'\/><\/noscript><\/figure>\n<h3><span class=\"ez-toc-section\" id=\"Funcion-Power-BI-DAX-TODAY\"><\/span>Funci\u00f3n Power BI DAX TODAY<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p>La funci\u00f3n Power BI DAX Today devuelve la fecha de hoy con la hora predeterminada del sistema.  La sintaxis de este Power BI DAX Today es:<\/p>\n<pre class=\"wp-block-preformatted lang:tsql decode:true\">TODAY()<\/pre>\n<p>D\u00e9jame crear una columna para mostrar la fecha de hoy.<\/p>\n<pre class=\"wp-block-preformatted lang:tsql decode:true\">Today 2 = TODAY()<\/pre>\n<figure class=\"wp-block-image\"><img alt='power-bi-dax-date-functions-13-7619269' width='914' height='641' alt=\"Funci\u00f3n 13 de Power BI DAX TODAY\" class=\"wp-image-32921\" srcset='\/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Power-BI-DAX-Date-Functions-13-7619269.png 914w, \/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Power-BI-DAX-Date-Functions-13-7619269-300x210.png 300w, \/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Power-BI-DAX-Date-Functions-13-7619269-768x539.png 768w' data-lazy-sizes='(max-width: 914px) 100vw, 914px' src='https:\/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Power-BI-DAX-Date-Functions-13-7619269.png'\/><noscript><img alt='power-bi-dax-date-functions-13-7619269' width='914' height='641' src='https:\/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Power-BI-DAX-Date-Functions-13-7619269.png' alt=\"Funci\u00f3n 13 de Power BI DAX TODAY\" class=\"wp-image-32921\" srcset='\/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Power-BI-DAX-Date-Functions-13-7619269.png 914w, \/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Power-BI-DAX-Date-Functions-13-7619269-300x210.png 300w, \/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Power-BI-DAX-Date-Functions-13-7619269-768x539.png 768w' sizes='(max-width: 914px) 100vw, 914px'\/><\/noscript><\/figure>\n<p>Perm\u00edtanme comparar AHORA () y HOY ().<\/p>\n<p>En la captura de pantalla a continuaci\u00f3n, puede ver que hay una diferencia de tiempo entre los dos.<\/p>\n<figure class=\"wp-block-image\"><img alt='power-bi-dax-date-functions-14-4383108' width='990' height='632' alt=\"Funciones de Power BI DAX DATE 14\" class=\"wp-image-32922\" srcset='\/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Power-BI-DAX-Date-Functions-14-4383108.png 990w, \/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Power-BI-DAX-Date-Functions-14-4383108-300x192.png 300w, \/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Power-BI-DAX-Date-Functions-14-4383108-768x490.png 768w' data-lazy-sizes='(max-width: 990px) 100vw, 990px' src='https:\/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Power-BI-DAX-Date-Functions-14-4383108.png'\/><noscript><img alt='power-bi-dax-date-functions-14-4383108' width='990' height='632' src='https:\/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Power-BI-DAX-Date-Functions-14-4383108.png' alt=\"Funciones de Power BI DAX DATE 14\" class=\"wp-image-32922\" srcset='\/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Power-BI-DAX-Date-Functions-14-4383108.png 990w, \/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Power-BI-DAX-Date-Functions-14-4383108-300x192.png 300w, \/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Power-BI-DAX-Date-Functions-14-4383108-768x490.png 768w' sizes='(max-width: 990px) 100vw, 990px'\/><\/noscript><\/figure>\n<h3><span class=\"ez-toc-section\" id=\"Funcion-Power-BI-DAX-DATE\"><\/span>Funci\u00f3n Power BI DAX DATE<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p>La funci\u00f3n Power BI DAX Date es \u00fatil para devolver la fecha del a\u00f1o, mes y d\u00eda.  La sintaxis de la funci\u00f3n Power BI DAX Date es:<\/p>\n<pre class=\"wp-block-preformatted lang:tsql decode:true\">DATE(year, month, day)<\/pre>\n<p>Perm\u00edtame crear una sola columna para crear una fecha a partir del a\u00f1o, mes y d\u00eda<\/p>\n<pre class=\"wp-block-preformatted lang:tsql decode:true\">Date = DATE(YEAR(EmployeeSales[HireDate]), MONTH(EmployeeSales[HireDate]),                  \n          DAY(EmployeeSales[HireDate]))<\/pre>\n<figure class=\"wp-block-image\"><img alt='power-bi-dax-date-functions-17-8708226' width='936' height='678' alt=\"Funci\u00f3n de fecha de Power BI DAX 17\" class=\"wp-image-32925\" srcset='\/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Power-BI-DAX-Date-Functions-17-8708226.png 936w, \/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Power-BI-DAX-Date-Functions-17-8708226-300x217.png 300w, \/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Power-BI-DAX-Date-Functions-17-8708226-768x556.png 768w' data-lazy-sizes='(max-width: 936px) 100vw, 936px' src='https:\/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Power-BI-DAX-Date-Functions-17-8708226.png'\/><noscript><img alt='power-bi-dax-date-functions-17-8708226' width='936' height='678' src='https:\/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Power-BI-DAX-Date-Functions-17-8708226.png' alt=\"Funci\u00f3n de fecha de Power BI DAX 17\" class=\"wp-image-32925\" srcset='\/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Power-BI-DAX-Date-Functions-17-8708226.png 936w, \/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Power-BI-DAX-Date-Functions-17-8708226-300x217.png 300w, \/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Power-BI-DAX-Date-Functions-17-8708226-768x556.png 768w' sizes='(max-width: 936px) 100vw, 936px'\/><\/noscript><\/figure>\n<h3><span class=\"ez-toc-section\" id=\"Funcion-Power-BI-DAX-TIME\"><\/span>Funci\u00f3n Power BI DAX TIME<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p>La funci\u00f3n de hora de Power BI DAX devuelve la hora a partir de la hora, los minutos y los segundos especificados.  La sintaxis de esta funci\u00f3n de hora de Power BI DAX es:<\/p>\n<pre class=\"wp-block-preformatted lang:tsql decode:true\">TIME(hour, minute, second)<\/pre>\n<p>Perm\u00edteme crear una columna para crear el tiempo a partir de la hora, los minutos y los segundos.<\/p>\n<pre class=\"wp-block-preformatted lang:tsql decode:true\">Time = TIME(HOUR(EmployeeSales[HireDate]), MINUTE(EmployeeSales[HireDate]),                           \n             SECOND(EmployeeSales[HireDate]))<\/pre>\n<figure class=\"wp-block-image\"><img alt='power-bi-dax-date-functions-18-7597125' width='950' height='688' alt=\"Funci\u00f3n de hora de Power BI DAX 18\" class=\"wp-image-32926\" srcset='\/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Power-BI-DAX-Date-Functions-18-7597125.png 950w, \/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Power-BI-DAX-Date-Functions-18-7597125-300x217.png 300w, \/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Power-BI-DAX-Date-Functions-18-7597125-768x556.png 768w' data-lazy-sizes='(max-width: 950px) 100vw, 950px' src='https:\/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Power-BI-DAX-Date-Functions-18-7597125.png'\/><noscript><img alt='power-bi-dax-date-functions-18-7597125' width='950' height='688' src='https:\/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Power-BI-DAX-Date-Functions-18-7597125.png' alt=\"Funci\u00f3n de hora de Power BI DAX 18\" class=\"wp-image-32926\" srcset='\/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Power-BI-DAX-Date-Functions-18-7597125.png 950w, \/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Power-BI-DAX-Date-Functions-18-7597125-300x217.png 300w, \/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Power-BI-DAX-Date-Functions-18-7597125-768x556.png 768w' sizes='(max-width: 950px) 100vw, 950px'\/><\/noscript><\/figure>\n<p>Perm\u00edtanme agregar el resultado de la funci\u00f3n Power BI DAX Time al informe de la tabla.  Si encuentra la salida como la fecha predeterminada con la hora, cambie el tipo de datos de fecha \/ hora a hora.<\/p>\n<figure class=\"wp-block-image\"><img alt='power-bi-dax-date-functions-19-7155079' width='1080' height='706' alt=\"Funci\u00f3n de hora de Power BI DAX 19\" class=\"wp-image-32927\" srcset='\/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Power-BI-DAX-Date-Functions-19-7155079.png 1080w, \/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Power-BI-DAX-Date-Functions-19-7155079-300x196.png 300w, \/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Power-BI-DAX-Date-Functions-19-7155079-1024x669.png 1024w, \/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Power-BI-DAX-Date-Functions-19-7155079-768x502.png 768w' data-lazy-sizes='(max-width: 1080px) 100vw, 1080px' src='https:\/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Power-BI-DAX-Date-Functions-19-7155079.png'\/><noscript><img alt='power-bi-dax-date-functions-19-7155079' width='1080' height='706' src='https:\/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Power-BI-DAX-Date-Functions-19-7155079.png' alt=\"Funci\u00f3n de hora de Power BI DAX 19\" class=\"wp-image-32927\" srcset='\/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Power-BI-DAX-Date-Functions-19-7155079.png 1080w, \/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Power-BI-DAX-Date-Functions-19-7155079-300x196.png 300w, \/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Power-BI-DAX-Date-Functions-19-7155079-1024x669.png 1024w, \/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Power-BI-DAX-Date-Functions-19-7155079-768x502.png 768w' sizes='(max-width: 1080px) 100vw, 1080px'\/><\/noscript><\/figure>\n<h3><span class=\"ez-toc-section\" id=\"Funcion-de-dia-de-la-semana-de-Power-BI-DAX\"><\/span>Funci\u00f3n de d\u00eda de la semana de Power BI DAX<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p>La funci\u00f3n Power BI DAX Weekday devuelve n\u00fameros del 1 al 7, donde 1 a partir del domingo y 7 a partir del lunes.  La sintaxis de la funci\u00f3n Power BI DAX Weekday es: The Power BI DAX Weekday function syntax is:<\/p>\n<pre class=\"wp-block-preformatted lang:tsql decode:true\">WEEKDAY(Date, Number)<\/pre>\n<ul>\n<li>Si N\u00famero = 1 entonces 1 a partir del domingo<\/li>\n<li>Si N\u00famero = 2 entonces 1 a partir del lunes<\/li>\n<li>y N\u00famero = 3 luego 0 a partir del lunes<\/li>\n<\/ul>\n<p>D\u00e9jame crear una columna para encontrar el n\u00famero del d\u00eda de la semana.<\/p>\n<pre class=\"wp-block-preformatted lang:tsql decode:true\">WeekDay = WEEKDAY(EmployeeSales[HireDate], 1)<\/pre>\n<figure class=\"wp-block-image\"><img alt='power-bi-dax-date-functions-22-2422382' width='924' height='582' alt=\"Funci\u00f3n 22 de Power BI DAX Weekday\" class=\"wp-image-32930\" srcset='\/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Power-BI-DAX-Date-Functions-22-2422382.png 924w, \/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Power-BI-DAX-Date-Functions-22-2422382-300x189.png 300w, \/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Power-BI-DAX-Date-Functions-22-2422382-768x484.png 768w' data-lazy-sizes='(max-width: 924px) 100vw, 924px' src='https:\/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Power-BI-DAX-Date-Functions-22-2422382.png'\/><noscript><img alt='power-bi-dax-date-functions-22-2422382' width='924' height='582' src='https:\/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Power-BI-DAX-Date-Functions-22-2422382.png' alt=\"Funci\u00f3n 22 de Power BI DAX Weekday\" class=\"wp-image-32930\" srcset='\/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Power-BI-DAX-Date-Functions-22-2422382.png 924w, \/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Power-BI-DAX-Date-Functions-22-2422382-300x189.png 300w, \/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Power-BI-DAX-Date-Functions-22-2422382-768x484.png 768w' sizes='(max-width: 924px) 100vw, 924px'\/><\/noscript><\/figure>\n<p>Puedes ver los n\u00fameros de la semana<\/p>\n<figure class=\"wp-block-image\"><img alt='power-bi-dax-date-functions-23-6153699' width='932' height='652' alt=\"Funci\u00f3n de d\u00eda de la semana de Power BI DAX 23\" class=\"wp-image-32931\" srcset='\/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Power-BI-DAX-Date-Functions-23-6153699.png 932w, \/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Power-BI-DAX-Date-Functions-23-6153699-300x210.png 300w, \/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Power-BI-DAX-Date-Functions-23-6153699-768x537.png 768w' data-lazy-sizes='(max-width: 932px) 100vw, 932px' src='https:\/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Power-BI-DAX-Date-Functions-23-6153699.png'\/><noscript><img alt='power-bi-dax-date-functions-23-6153699' width='932' height='652' src='https:\/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Power-BI-DAX-Date-Functions-23-6153699.png' alt=\"Funci\u00f3n de d\u00eda de la semana de Power BI DAX 23\" class=\"wp-image-32931\" srcset='\/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Power-BI-DAX-Date-Functions-23-6153699.png 932w, \/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Power-BI-DAX-Date-Functions-23-6153699-300x210.png 300w, \/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Power-BI-DAX-Date-Functions-23-6153699-768x537.png 768w' sizes='(max-width: 932px) 100vw, 932px'\/><\/noscript><\/figure>\n<h3><span class=\"ez-toc-section\" id=\"Funcion-WeekNum-de-Power-BI-DAX\"><\/span>Funci\u00f3n WeekNum de Power BI DAX<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p>La funci\u00f3n de Power BI DAX WeekNum devuelve el n\u00famero de semana (1 como la primera semana de enero).  La sintaxis de esta funci\u00f3n de Power BI DAX Weeknum es:<\/p>\n<pre class=\"wp-block-preformatted lang:tsql decode:true\">WEEKNUM(Date, Number)<\/pre>\n<p>Si N\u00famero = 1 La semana comienza el domingo y si N\u00famero = 2, la Semana comienza el lunes.  D\u00e9jame crear una columna para encontrar el n\u00famero de la semana.<\/p>\n<pre class=\"wp-block-preformatted lang:tsql decode:true\">WeekNum = WEEKNUM(EmployeeSales[HireDate], 1)<\/pre>\n<figure class=\"wp-block-image\"><img alt='power-bi-dax-date-functions-24-1411062' width='998' height='691' alt=\"Funci\u00f3n 24 de Power BI DAX Weeknum\" class=\"wp-image-32932\" srcset='\/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Power-BI-DAX-Date-Functions-24-1411062.png 998w, \/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Power-BI-DAX-Date-Functions-24-1411062-300x208.png 300w, \/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Power-BI-DAX-Date-Functions-24-1411062-768x532.png 768w' data-lazy-sizes='(max-width: 998px) 100vw, 998px' src='https:\/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Power-BI-DAX-Date-Functions-24-1411062.png'\/><noscript><img alt='power-bi-dax-date-functions-24-1411062' width='998' height='691' src='https:\/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Power-BI-DAX-Date-Functions-24-1411062.png' alt=\"Funci\u00f3n 24 de Power BI DAX Weeknum\" class=\"wp-image-32932\" srcset='\/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Power-BI-DAX-Date-Functions-24-1411062.png 998w, \/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Power-BI-DAX-Date-Functions-24-1411062-300x208.png 300w, \/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Power-BI-DAX-Date-Functions-24-1411062-768x532.png 768w' sizes='(max-width: 998px) 100vw, 998px'\/><\/noscript><\/figure>\n<h3><span class=\"ez-toc-section\" id=\"Funcion-UTCNOW-de-Power-BI-DAX\"><\/span>Funci\u00f3n UTCNOW de Power BI DAX<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p>La funci\u00f3n DAX UTCNOW es la misma que la funci\u00f3n Power BI DAX NOW.  Sin embargo, devuelve la fecha y la hora junto con UTC.  La sintaxis de esta funci\u00f3n UTCNOW de Power BI DAX es:<\/p>\n<pre class=\"wp-block-preformatted lang:tsql decode:true\">UTCNOW()<\/pre>\n<p>Perm\u00edtanme crear una columna para encontrar la fecha y la hora junto con UTC<\/p>\n<pre class=\"wp-block-preformatted lang:tsql decode:true\">UTCNow = UTCNOW()<\/pre>\n<figure class=\"wp-block-image\"><img alt='power-bi-dax-date-functions-25-6086461' width='1008' height='697' alt=\"Funci\u00f3n UTCNOW de Power BI DAX 25\" class=\"wp-image-32933\" srcset='\/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Power-BI-DAX-Date-Functions-25-6086461.png 1008w, \/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Power-BI-DAX-Date-Functions-25-6086461-300x207.png 300w, \/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Power-BI-DAX-Date-Functions-25-6086461-768x531.png 768w' data-lazy-sizes='(max-width: 1008px) 100vw, 1008px' src='https:\/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Power-BI-DAX-Date-Functions-25-6086461.png'\/><noscript><img alt='power-bi-dax-date-functions-25-6086461' width='1008' height='697' src='https:\/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Power-BI-DAX-Date-Functions-25-6086461.png' alt=\"Funci\u00f3n UTCNOW de Power BI DAX 25\" class=\"wp-image-32933\" srcset='\/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Power-BI-DAX-Date-Functions-25-6086461.png 1008w, \/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Power-BI-DAX-Date-Functions-25-6086461-300x207.png 300w, \/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Power-BI-DAX-Date-Functions-25-6086461-768x531.png 768w' sizes='(max-width: 1008px) 100vw, 1008px'\/><\/noscript><\/figure>\n<h3><span class=\"ez-toc-section\" id=\"Funcion-Power-BI-DAX-UTCTODAY\"><\/span>Funci\u00f3n Power BI DAX UTCTODAY<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p>La funci\u00f3n Power BI DAX UTCTODAY es la misma que la funci\u00f3n ODAY.  Sin embargo, devuelve la fecha con la hora predeterminada junto con UTC.  La sintaxis de este Power BI DAX UTCTODAY es:<\/p>\n<pre class=\"wp-block-preformatted lang:tsql decode:true\">UTCTODAY()<\/pre>\n<p>D\u00e9jame crear una columna para encontrar la fecha con UTC<\/p>\n<pre class=\"wp-block-preformatted lang:tsql decode:true\">UTCToday = UTCTODAY()<\/pre>\n<figure class=\"wp-block-image\"><img alt='power-bi-dax-date-functions-26-1852318' width='1001' height='690' alt=\"Funci\u00f3n 26 de Power BI DAX UTCTODAY\" class=\"wp-image-32934\" srcset='\/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Power-BI-DAX-Date-Functions-26-1852318.png 1001w, \/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Power-BI-DAX-Date-Functions-26-1852318-300x207.png 300w, \/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Power-BI-DAX-Date-Functions-26-1852318-768x529.png 768w' data-lazy-sizes='(max-width: 1001px) 100vw, 1001px' src='https:\/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Power-BI-DAX-Date-Functions-26-1852318.png'\/><noscript><img alt='power-bi-dax-date-functions-26-1852318' width='1001' height='690' src='https:\/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Power-BI-DAX-Date-Functions-26-1852318.png' alt=\"Funci\u00f3n 26 de Power BI DAX UTCTODAY\" class=\"wp-image-32934\" srcset='\/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Power-BI-DAX-Date-Functions-26-1852318.png 1001w, \/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Power-BI-DAX-Date-Functions-26-1852318-300x207.png 300w, \/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Power-BI-DAX-Date-Functions-26-1852318-768x529.png 768w' sizes='(max-width: 1001px) 100vw, 1001px'\/><\/noscript><\/figure>\n<h3><span class=\"ez-toc-section\" id=\"Funcion-Power-BI-DAX-YEARFRAC\"><\/span>Funci\u00f3n Power BI DAX YEARFRAC<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p>La funci\u00f3n Power BI DAX YEARFRAC devuelve la diferencia fraccionaria entre la fecha de inicio y la fecha de finalizaci\u00f3n.  La sintaxis de Power BI DAX YEARFRAC es:<\/p>\n<pre class=\"wp-block-preformatted lang:tsql decode:true\">YEARFRAC(Start_Date, End_Date)<\/pre>\n<p>Perm\u00edtame encontrar el n\u00famero exacto de a\u00f1os de diferencia entre la fecha de contrataci\u00f3n y hoy<\/p>\n<pre class=\"wp-block-preformatted lang:tsql decode:true\">YearFrac = YEARFRAC(EmployeeSales[HireDate], NOW())<\/pre>\n<figure class=\"wp-block-image\"><img alt='power-bi-dax-date-functions-27-4788488' width='1000' height='688' alt=\"Funci\u00f3n YearFrac de Power BI DAX 27\" class=\"wp-image-32935\" srcset='\/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Power-BI-DAX-Date-Functions-27-4788488.png 1000w, \/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Power-BI-DAX-Date-Functions-27-4788488-300x206.png 300w, \/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Power-BI-DAX-Date-Functions-27-4788488-768x528.png 768w' data-lazy-sizes='(max-width: 1000px) 100vw, 1000px' src='https:\/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Power-BI-DAX-Date-Functions-27-4788488.png'\/><noscript><img alt='power-bi-dax-date-functions-27-4788488' width='1000' height='688' src='https:\/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Power-BI-DAX-Date-Functions-27-4788488.png' alt=\"Funci\u00f3n YearFrac de Power BI DAX 27\" class=\"wp-image-32935\" srcset='\/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Power-BI-DAX-Date-Functions-27-4788488.png 1000w, \/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Power-BI-DAX-Date-Functions-27-4788488-300x206.png 300w, \/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Power-BI-DAX-Date-Functions-27-4788488-768x528.png 768w' sizes='(max-width: 1000px) 100vw, 1000px'\/><\/noscript><\/figure>\n<h3><span class=\"ez-toc-section\" id=\"Funcion-EDATE-de-Power-BI-DAX\"><\/span>Funci\u00f3n EDATE de Power BI DAX<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p>La funci\u00f3n EDATE de Power BI DAX devuelve fechas anteriores o fechas futuras.  Por ejemplo, la fecha de vencimiento de la pol\u00edtica agregando 24 como segundo argumento, etc. La sintaxis de esta funci\u00f3n de Power BI DAX EDATE es:<\/p>\n<pre class=\"wp-block-preformatted lang:tsql decode:true\">EDATE(Start_Date, Months)<\/pre>\n<p>D\u00e9jame agregar 2 meses a la fecha de contrataci\u00f3n<\/p>\n<pre class=\"wp-block-preformatted lang:tsql decode:true\">Edate = EDATE(EmployeeSales[HireDate], 2)<\/pre>\n<figure class=\"wp-block-image\"><img alt='power-bi-dax-date-functions-28-5147438' width='1001' height='690' alt=\"Funci\u00f3n EDate de Power BI DAX 28\" class=\"wp-image-32936\" srcset='\/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Power-BI-DAX-Date-Functions-28-5147438.png 1001w, \/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Power-BI-DAX-Date-Functions-28-5147438-300x207.png 300w, \/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Power-BI-DAX-Date-Functions-28-5147438-768x529.png 768w' data-lazy-sizes='(max-width: 1001px) 100vw, 1001px' src='https:\/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Power-BI-DAX-Date-Functions-28-5147438.png'\/><noscript><img alt='power-bi-dax-date-functions-28-5147438' width='1001' height='690' src='https:\/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Power-BI-DAX-Date-Functions-28-5147438.png' alt=\"Funci\u00f3n EDate de Power BI DAX 28\" class=\"wp-image-32936\" srcset='\/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Power-BI-DAX-Date-Functions-28-5147438.png 1001w, \/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Power-BI-DAX-Date-Functions-28-5147438-300x207.png 300w, \/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Power-BI-DAX-Date-Functions-28-5147438-768x529.png 768w' sizes='(max-width: 1001px) 100vw, 1001px'\/><\/noscript><\/figure>\n<h3><span class=\"ez-toc-section\" id=\"Funcion-Power-BI-DAX-EOMONTH\"><\/span>Funci\u00f3n Power BI DAX EOMONTH<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p>La funci\u00f3n Power BI DAX EOMONTH (EOMONTH significa el final del mes) muestra el \u00faltimo d\u00eda de un mes.  Puede utilizar el segundo argumento para devolver fechas anteriores o futuras.  La sintaxis de este Power BI DAX EDATE es:<\/p>\n<pre class=\"wp-block-preformatted lang:tsql decode:true\">EOMONTH(Start_Date, Months)<\/pre>\n<p>Perm\u00edtanme agregar 3 meses a la fecha de contrataci\u00f3n.  La siguiente declaraci\u00f3n primero agrega tres meses a la fecha de contrataci\u00f3n y luego devuelve el \u00faltimo d\u00eda de ese mes.<\/p>\n<pre class=\"wp-block-preformatted lang:tsql decode:true\">Eomonth = EOMONTH(EmployeeSales[HireDate], 3)<\/pre>\n<figure class=\"wp-block-image\"><img alt='power-bi-dax-date-functions-29-2466372' width='943' height='654' alt=\"Funci\u00f3n 29 de Power BI DAX EOMONTH\" class=\"wp-image-32937\" srcset='\/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Power-BI-DAX-Date-Functions-29-2466372.png 943w, \/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Power-BI-DAX-Date-Functions-29-2466372-300x208.png 300w, \/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Power-BI-DAX-Date-Functions-29-2466372-768x533.png 768w' data-lazy-sizes='(max-width: 943px) 100vw, 943px' src='https:\/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Power-BI-DAX-Date-Functions-29-2466372.png'\/><noscript><img alt='power-bi-dax-date-functions-29-2466372' width='943' height='654' src='https:\/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Power-BI-DAX-Date-Functions-29-2466372.png' alt=\"Funci\u00f3n 29 de Power BI DAX EOMONTH\" class=\"wp-image-32937\" srcset='\/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Power-BI-DAX-Date-Functions-29-2466372.png 943w, \/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Power-BI-DAX-Date-Functions-29-2466372-300x208.png 300w, \/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Power-BI-DAX-Date-Functions-29-2466372-768x533.png 768w' sizes='(max-width: 943px) 100vw, 943px'\/><\/noscript><\/figure>\n<h3><span class=\"ez-toc-section\" id=\"Funcion-Power-BI-DAX-DATEDIFF\"><\/span>Funci\u00f3n Power BI DAX DATEDIFF<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p>La funci\u00f3n Power BI DAX DATEDIFF devuelve la diferencia de fecha entre la fecha de inicio y la fecha de finalizaci\u00f3n.  Puede usar el tercer argumento de la funci\u00f3n Power BI DAX DATEDIFF para seleccionar el valor de diferencia.<\/p>\n<p>La funci\u00f3n Power BI DAX DATEDIFF acepta A\u00d1O, MES, D\u00cdA, SEGUNDO, MINUTO, HORA, TRIMESTRE, SEMANA.  Por ejemplo, si selecciona MES, la funci\u00f3n DateDiff devuelve el n\u00famero de diferencia de mes entre una fecha de inicio y una fecha de finalizaci\u00f3n.<\/p>\n<p>La sintaxis de esta funci\u00f3n de Power BI DAX DATEDIFF es:<\/p>\n<pre class=\"wp-block-preformatted lang:tsql decode:true\">DATEDIFF(Start_Date, End_Date, Difference_Value)<\/pre>\n<p>D\u00e9jame comprobar la diferencia entre la fecha de contrataci\u00f3n y el d\u00eda de hoy en a\u00f1os.<\/p>\n<pre class=\"wp-block-preformatted lang:tsql decode:true\">DateDiff = DATEDIFF(EmployeeSales[HireDate], NOW(), YEAR)<\/pre>\n<figure class=\"wp-block-image\"><img alt='power-bi-dax-date-functions-30-6139299' width='945' height='659' alt=\"Funci\u00f3n 30 de Power BI DAX DateDiff\" class=\"wp-image-32938\" srcset='\/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Power-BI-DAX-Date-Functions-30-6139299.png 945w, \/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Power-BI-DAX-Date-Functions-30-6139299-300x209.png 300w, \/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Power-BI-DAX-Date-Functions-30-6139299-768x536.png 768w' data-lazy-sizes='(max-width: 945px) 100vw, 945px' src='https:\/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Power-BI-DAX-Date-Functions-30-6139299.png'\/><noscript><img alt='power-bi-dax-date-functions-30-6139299' width='945' height='659' src='https:\/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Power-BI-DAX-Date-Functions-30-6139299.png' alt=\"Funci\u00f3n 30 de Power BI DAX DateDiff\" class=\"wp-image-32938\" srcset='\/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Power-BI-DAX-Date-Functions-30-6139299.png 945w, \/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Power-BI-DAX-Date-Functions-30-6139299-300x209.png 300w, \/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Power-BI-DAX-Date-Functions-30-6139299-768x536.png 768w' sizes='(max-width: 945px) 100vw, 945px'\/><\/noscript><\/figure>\n<h3><span class=\"ez-toc-section\" id=\"Funcion-Power-BI-DAX-DATEVALUE\"><\/span>Funci\u00f3n Power BI DAX DATEVALUE<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p>La funci\u00f3n DAX DATEVALUE devuelve la fecha con la hora del sistema.  La sintaxis de este Power BI DAX DATEVALUE es:<\/p>\n<pre class=\"wp-block-preformatted lang:tsql decode:true\">DATEVALUE(Date)<\/pre>\n<p>D\u00e9jeme devolver la fecha de la fecha de contrataci\u00f3n.<\/p>\n<pre class=\"wp-block-preformatted lang:tsql decode:true\">DtValue = DATEVALUE(EmployeeSales[HireDate])<\/pre>\n<figure class=\"wp-block-image\"><img alt='power-bi-dax-date-functions-31-2184160' width='989' height='691' alt=\"Funciones de Power BI DAX DateValue 31\" class=\"wp-image-32939\" srcset='\/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Power-BI-DAX-Date-Functions-31-2184160.png 989w, \/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Power-BI-DAX-Date-Functions-31-2184160-300x210.png 300w, \/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Power-BI-DAX-Date-Functions-31-2184160-768x537.png 768w' data-lazy-sizes='(max-width: 989px) 100vw, 989px' src='https:\/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Power-BI-DAX-Date-Functions-31-2184160.png'\/><noscript><img alt='power-bi-dax-date-functions-31-2184160' width='989' height='691' src='https:\/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Power-BI-DAX-Date-Functions-31-2184160.png' alt=\"Funciones de Power BI DAX DateValue 31\" class=\"wp-image-32939\" srcset='\/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Power-BI-DAX-Date-Functions-31-2184160.png 989w, \/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Power-BI-DAX-Date-Functions-31-2184160-300x210.png 300w, \/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Power-BI-DAX-Date-Functions-31-2184160-768x537.png 768w' sizes='(max-width: 989px) 100vw, 989px'\/><\/noscript><\/figure>\n<h3><span class=\"ez-toc-section\" id=\"Funcion-de-Power-BI-DAX-TIMEVALUE\"><\/span>Funci\u00f3n de Power BI DAX TIMEVALUE<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p>La funci\u00f3n Power BI DAX TIMEVALUE devuelve la hora con la fecha predeterminada del sistema.  La sintaxis de la funci\u00f3n Power BI DAX TIMEVALUE es:<\/p>\n<pre class=\"wp-block-preformatted lang:tsql decode:true\">TIMEVALUE(Date)<\/pre>\n<p>D\u00e9jeme devolver el valor de tiempo de la fecha de contrataci\u00f3n.  Recuerde, el 30\/12\/1899 es el Power BI predeterminado generado hasta la fecha.<\/p>\n<pre class=\"wp-block-preformatted lang:tsql decode:true\">TimeVal = TIMEVALUE(EmployeeSales[HireDate])<\/pre>\n<figure class=\"wp-block-image\"><img alt='power-bi-dax-date-functions-32-7715917' width='988' height='669' alt=\"Funciones de Power BI DAX TimeValue 32\" class=\"wp-image-32940\" srcset='\/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Power-BI-DAX-Date-Functions-32-7715917.png 988w, \/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Power-BI-DAX-Date-Functions-32-7715917-300x203.png 300w, \/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Power-BI-DAX-Date-Functions-32-7715917-768x520.png 768w' data-lazy-sizes='(max-width: 988px) 100vw, 988px' src='https:\/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Power-BI-DAX-Date-Functions-32-7715917.png'\/><noscript><img alt='power-bi-dax-date-functions-32-7715917' width='988' height='669' src='https:\/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Power-BI-DAX-Date-Functions-32-7715917.png' alt=\"Funciones de Power BI DAX TimeValue 32\" class=\"wp-image-32940\" srcset='\/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Power-BI-DAX-Date-Functions-32-7715917.png 988w, \/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Power-BI-DAX-Date-Functions-32-7715917-300x203.png 300w, \/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Power-BI-DAX-Date-Functions-32-7715917-768x520.png 768w' sizes='(max-width: 988px) 100vw, 988px'\/><\/noscript><\/figure>\n<h3><span class=\"ez-toc-section\" id=\"Funcion-CALENDARIO-de-Power-BI-DAX\"><\/span>Funci\u00f3n CALENDARIO de Power BI DAX<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p>La funci\u00f3n CALENDARIO de Power BI DAX devuelve una tabla de fechas desde la fecha de inicio hasta la fecha de finalizaci\u00f3n.  La sintaxis de una funci\u00f3n de CALENDARIO de Power BI DAX es:<\/p>\n<pre class=\"wp-block-preformatted lang:tsql decode:true\">CALENDAR(Start_Date, End_Date)<\/pre>\n<p>La siguiente funci\u00f3n de CALENDARIO de Power BI DAX devuelve las fechas del 1 de enero de 2018 al 15 de enero de 2018. Le sugiero que consulte el art\u00edculo Crear una tabla calculada para comprender el proceso de creaci\u00f3n de una nueva tabla.<\/p>\n<pre class=\"wp-block-preformatted lang:tsql decode:true\">Calender = CALENDAR(DATE(2018,1, 1), DATE(2018, 1, 15))<\/pre>\n<figure class=\"wp-block-image\"><img alt='power-bi-dax-date-functions-15-5093909' width='871' height='632' alt=\"Funci\u00f3n 15 de CALENDARIO de DAX de Power BI\" class=\"wp-image-32923\" srcset='\/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Power-BI-DAX-Date-Functions-15-5093909.png 871w, \/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Power-BI-DAX-Date-Functions-15-5093909-300x218.png 300w, \/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Power-BI-DAX-Date-Functions-15-5093909-768x557.png 768w' data-lazy-sizes='(max-width: 871px) 100vw, 871px' src='https:\/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Power-BI-DAX-Date-Functions-15-5093909.png'\/><noscript><img alt='power-bi-dax-date-functions-15-5193812' width='871' height='632' src='https:\/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Power-BI-DAX-Date-Functions-15-5193812.png' alt=\"Funci\u00f3n 15 de CALENDARIO de DAX de Power BI\" class=\"wp-image-32923\" srcset='\/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Power-BI-DAX-Date-Functions-15-5193812.png 871w, \/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Power-BI-DAX-Date-Functions-15-5193812-300x218.png 300w, \/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Power-BI-DAX-Date-Functions-15-5193812-768x557.png 768w' sizes='(max-width: 871px) 100vw, 871px'\/><\/noscript><\/figure>\n<p>D\u00e9jame crear una tabla usando esta salida<\/p>\n<figure class=\"wp-block-image\"><img alt='power-bi-dax-date-functions-16-3043192' width='871' height='632' alt=\"Funci\u00f3n 16 de CALENDARIO de DAX de Power BI\" class=\"wp-image-32924\" srcset='\/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Power-BI-DAX-Date-Functions-16-3043192.png 871w, \/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Power-BI-DAX-Date-Functions-16-3043192-300x218.png 300w, \/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Power-BI-DAX-Date-Functions-16-3043192-768x557.png 768w' data-lazy-sizes='(max-width: 871px) 100vw, 871px' src='https:\/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Power-BI-DAX-Date-Functions-16-3043192.png'\/><noscript><img alt='power-bi-dax-date-functions-16-3043192' width='871' height='632' src='https:\/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Power-BI-DAX-Date-Functions-16-3043192.png' alt=\"Funci\u00f3n 16 de CALENDARIO de DAX de Power BI\" class=\"wp-image-32924\" srcset='\/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Power-BI-DAX-Date-Functions-16-3043192.png 871w, \/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Power-BI-DAX-Date-Functions-16-3043192-300x218.png 300w, \/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Power-BI-DAX-Date-Functions-16-3043192-768x557.png 768w' sizes='(max-width: 871px) 100vw, 871px'\/><\/noscript><\/figure>\n<h3><span class=\"ez-toc-section\" id=\"Funcion-Power-BI-DAX-CALENDARAUTO\"><\/span>Funci\u00f3n Power BI DAX CALENDARAUTO<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p>La funci\u00f3n DAX CALENDARAUTO, que devuelve fechas continuas utilizando la fecha del modelo de datos.  La sintaxis de un Power BI DAX CALENDARAUTO es:<\/p>\n<pre class=\"wp-block-preformatted lang:tsql decode:true\">CALENDARAUTO(year_end_month)<\/pre>\n<p>El valor del argumento es una opci\u00f3n para esta funci\u00f3n de Power BI DAX CALENDARAUTO.  Acepta n\u00fameros de 1 a 12 meses y, si los omite, trata el valor como 12 (predeterminado)<\/p>\n<pre class=\"wp-block-preformatted lang:tsql decode:true\">CalenderAutotable = CALENDARAUTO()<\/pre>\n<figure class=\"wp-block-image\"><img alt='power-bi-dax-date-functions-20-2220113' width='960' height='591' alt=\"Funciones de Auto Power BI DAX Calendarauto 20\" class=\"wp-image-32928\" srcset='\/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Power-BI-DAX-Date-Functions-20-2220113.png 960w, \/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Power-BI-DAX-Date-Functions-20-2220113-300x185.png 300w, \/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Power-BI-DAX-Date-Functions-20-2220113-768x473.png 768w' data-lazy-sizes='(max-width: 960px) 100vw, 960px' src='https:\/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Power-BI-DAX-Date-Functions-20-2220113.png'\/><noscript><img alt='power-bi-dax-date-functions-20-2220113' width='960' height='591' src='https:\/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Power-BI-DAX-Date-Functions-20-2220113.png' alt=\"Funciones de Auto Power BI DAX Calendarauto 20\" class=\"wp-image-32928\" srcset='\/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Power-BI-DAX-Date-Functions-20-2220113.png 960w, \/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Power-BI-DAX-Date-Functions-20-2220113-300x185.png 300w, \/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Power-BI-DAX-Date-Functions-20-2220113-768x473.png 768w' sizes='(max-width: 960px) 100vw, 960px'\/><\/noscript><\/figure>\n<p>Puede ver el resultado de esta funci\u00f3n de fecha de Power BI<\/p>\n<figure class=\"wp-block-image\"><img alt='power-bi-dax-date-functions-21-2937267' width='962' height='569' alt=\"Funciones de Auto Power BI DAX Calendarauto 21\" class=\"wp-image-32929\" srcset='\/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Power-BI-DAX-Date-Functions-21-2937267.png 962w, \/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Power-BI-DAX-Date-Functions-21-2937267-300x177.png 300w, \/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Power-BI-DAX-Date-Functions-21-2937267-768x454.png 768w' data-lazy-sizes='(max-width: 962px) 100vw, 962px' src='https:\/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Power-BI-DAX-Date-Functions-21-2937267.png'\/><noscript><img alt='power-bi-dax-date-functions-21-5765066' width='962' height='569' src='https:\/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Power-BI-DAX-Date-Functions-21-5765066.png' alt=\"Funciones de Auto Power BI DAX Calendarauto 21\" class=\"wp-image-32929\" srcset='\/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Power-BI-DAX-Date-Functions-21-5765066.png 962w, \/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Power-BI-DAX-Date-Functions-21-5765066-300x177.png 300w, \/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Power-BI-DAX-Date-Functions-21-5765066-768x454.png 768w' sizes='(max-width: 962px) 100vw, 962px'\/><\/noscript><\/figure>\n<\/div>\n","protected":false},"excerpt":{"rendered":"<p>Wie verwende ich Power BI DAX-Datumsfunktionen anhand von Beispielen? Microsoft Power BI DAX bietet verschiedene Datumsfunktionen, wie Jahr, Monat, Tag, Kalender, Datum, Uhrzeit, Dateiff, jetzt, \u2026<\/p>","protected":false},"author":1,"featured_media":84199,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[1359,1360],"tags":[],"class_list":["post-84200","post","type-post","status-publish","format-standard","has-post-thumbnail","category-powerbi","category-tutoriales-power-bi"],"yoast_head":"<!-- This site is optimized with the Yoast SEO Premium plugin v27.0 (Yoast SEO v28.2) - https:\/\/yoast.com\/product\/yoast-seo-premium-wordpress\/ -->\n<title>Funciones de fecha de Power BI DAX - R Marketing Digital<\/title>\n<meta name=\"description\" content=\"\u00bfC\u00f3mo usar las funciones de fecha de Power BI DAX con ejemplos? Microsoft Power BI DAX proporciona varias funciones de fecha, como a\u00f1o, mes, d\u00eda,\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/rmarketingdigital.com\/de\/energiebi\/power-bi-dax-date-functions\/\" \/>\n<meta property=\"og:locale\" content=\"de_DE\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Funciones de fecha de Power BI DAX\" \/>\n<meta property=\"og:description\" content=\"\u00bfC\u00f3mo usar las funciones de fecha de Power BI DAX con ejemplos? Microsoft Power BI DAX proporciona varias funciones de fecha, como a\u00f1o, mes, d\u00eda,\" \/>\n<meta property=\"og:url\" content=\"https:\/\/rmarketingdigital.com\/de\/energiebi\/power-bi-dax-date-functions\/\" \/>\n<meta property=\"og:site_name\" content=\"R Marketing Digital\" \/>\n<meta property=\"article:published_time\" content=\"2022-07-05T18:35:07+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Power-BI-DAX-Date-Functions-30-3146592.png\" \/>\n\t<meta property=\"og:image:width\" content=\"945\" \/>\n\t<meta property=\"og:image:height\" content=\"659\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/png\" \/>\n<meta name=\"author\" content=\"R Marketing Digital\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\\\/\\\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\\\/\\\/rmarketingdigital.com\\\/en\\\/powerbi\\\/power-bi-dax-date-functions\\\/#article\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/rmarketingdigital.com\\\/en\\\/powerbi\\\/power-bi-dax-date-functions\\\/\"},\"author\":{\"name\":\"R Marketing Digital\",\"@id\":\"https:\\\/\\\/rmarketingdigital.com\\\/#\\\/schema\\\/person\\\/7c0d9782b2977b840b3740f00c69a73e\"},\"headline\":\"Funciones de fecha de Power BI DAX\",\"datePublished\":\"2022-07-05T18:35:07+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\\\/\\\/rmarketingdigital.com\\\/en\\\/powerbi\\\/power-bi-dax-date-functions\\\/\"},\"wordCount\":1711,\"image\":{\"@id\":\"https:\\\/\\\/rmarketingdigital.com\\\/en\\\/powerbi\\\/power-bi-dax-date-functions\\\/#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/rmarketingdigital.com\\\/wp-content\\\/uploads\\\/2020\\\/09\\\/Power-BI-DAX-Date-Functions-30-3146592.png\",\"articleSection\":[\"Power BI\",\"Tutoriales PowerBI\"],\"inLanguage\":\"de\"},{\"@type\":\"WebPage\",\"@id\":\"https:\\\/\\\/rmarketingdigital.com\\\/en\\\/powerbi\\\/power-bi-dax-date-functions\\\/\",\"url\":\"https:\\\/\\\/rmarketingdigital.com\\\/en\\\/powerbi\\\/power-bi-dax-date-functions\\\/\",\"name\":\"Funciones de fecha de Power BI DAX - R Marketing Digital\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/rmarketingdigital.com\\\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\\\/\\\/rmarketingdigital.com\\\/en\\\/powerbi\\\/power-bi-dax-date-functions\\\/#primaryimage\"},\"image\":{\"@id\":\"https:\\\/\\\/rmarketingdigital.com\\\/en\\\/powerbi\\\/power-bi-dax-date-functions\\\/#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/rmarketingdigital.com\\\/wp-content\\\/uploads\\\/2020\\\/09\\\/Power-BI-DAX-Date-Functions-30-3146592.png\",\"datePublished\":\"2022-07-05T18:35:07+00:00\",\"author\":{\"@id\":\"https:\\\/\\\/rmarketingdigital.com\\\/#\\\/schema\\\/person\\\/7c0d9782b2977b840b3740f00c69a73e\"},\"description\":\"\u00bfC\u00f3mo usar las funciones de fecha de Power BI DAX con ejemplos? Microsoft Power BI DAX proporciona varias funciones de fecha, como a\u00f1o, mes, d\u00eda,\",\"inLanguage\":\"de\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\\\/\\\/rmarketingdigital.com\\\/en\\\/powerbi\\\/power-bi-dax-date-functions\\\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"de\",\"@id\":\"https:\\\/\\\/rmarketingdigital.com\\\/en\\\/powerbi\\\/power-bi-dax-date-functions\\\/#primaryimage\",\"url\":\"https:\\\/\\\/rmarketingdigital.com\\\/wp-content\\\/uploads\\\/2020\\\/09\\\/Power-BI-DAX-Date-Functions-30-3146592.png\",\"contentUrl\":\"https:\\\/\\\/rmarketingdigital.com\\\/wp-content\\\/uploads\\\/2020\\\/09\\\/Power-BI-DAX-Date-Functions-30-3146592.png\",\"width\":945,\"height\":659,\"caption\":\"power-bi-dax-date-functions-30-3146592-9981010-png\"},{\"@type\":\"WebSite\",\"@id\":\"https:\\\/\\\/rmarketingdigital.com\\\/#website\",\"url\":\"https:\\\/\\\/rmarketingdigital.com\\\/\",\"name\":\"R Marketing Digital\",\"description\":\"Agencia SEO | Publicidad redes sociales | Community Management\",\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\\\/\\\/rmarketingdigital.com\\\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"de\"},{\"@type\":\"Person\",\"@id\":\"https:\\\/\\\/rmarketingdigital.com\\\/#\\\/schema\\\/person\\\/7c0d9782b2977b840b3740f00c69a73e\",\"name\":\"R Marketing Digital\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"de\",\"@id\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/c5599c203e0120b8ccbff4666af86f35f9b3dcad468a8bc6295313a3964a80be?s=96&d=mm&r=g\",\"url\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/c5599c203e0120b8ccbff4666af86f35f9b3dcad468a8bc6295313a3964a80be?s=96&d=mm&r=g\",\"contentUrl\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/c5599c203e0120b8ccbff4666af86f35f9b3dcad468a8bc6295313a3964a80be?s=96&d=mm&r=g\",\"caption\":\"R Marketing Digital\"}}]}<\/script>\n<!-- \/ Yoast SEO Premium plugin. -->","yoast_head_json":{"title":"Power BI DAX-Datumsfunktionen \u2013 R Digital Marketing","description":"Wie verwende ich Power BI DAX-Datumsfunktionen mit Beispielen? Microsoft Power BI DAX bietet verschiedene Datumsfunktionen wie Jahr, Monat, Tag,","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:\/\/rmarketingdigital.com\/de\/energiebi\/power-bi-dax-date-functions\/","og_locale":"de_DE","og_type":"article","og_title":"Funciones de fecha de Power BI DAX","og_description":"\u00bfC\u00f3mo usar las funciones de fecha de Power BI DAX con ejemplos? Microsoft Power BI DAX proporciona varias funciones de fecha, como a\u00f1o, mes, d\u00eda,","og_url":"https:\/\/rmarketingdigital.com\/de\/energiebi\/power-bi-dax-date-functions\/","og_site_name":"R Marketing Digital","article_published_time":"2022-07-05T18:35:07+00:00","og_image":[{"width":945,"height":659,"url":"https:\/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Power-BI-DAX-Date-Functions-30-3146592.png","type":"image\/png"}],"author":"R Marketing Digital","twitter_card":"summary_large_image","schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/rmarketingdigital.com\/en\/powerbi\/power-bi-dax-date-functions\/#article","isPartOf":{"@id":"https:\/\/rmarketingdigital.com\/en\/powerbi\/power-bi-dax-date-functions\/"},"author":{"name":"R Marketing Digital","@id":"https:\/\/rmarketingdigital.com\/#\/schema\/person\/7c0d9782b2977b840b3740f00c69a73e"},"headline":"Funciones de fecha de Power BI DAX","datePublished":"2022-07-05T18:35:07+00:00","mainEntityOfPage":{"@id":"https:\/\/rmarketingdigital.com\/en\/powerbi\/power-bi-dax-date-functions\/"},"wordCount":1711,"image":{"@id":"https:\/\/rmarketingdigital.com\/en\/powerbi\/power-bi-dax-date-functions\/#primaryimage"},"thumbnailUrl":"https:\/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Power-BI-DAX-Date-Functions-30-3146592.png","articleSection":["Power BI","Tutoriales PowerBI"],"inLanguage":"de"},{"@type":"WebPage","@id":"https:\/\/rmarketingdigital.com\/en\/powerbi\/power-bi-dax-date-functions\/","url":"https:\/\/rmarketingdigital.com\/en\/powerbi\/power-bi-dax-date-functions\/","name":"Power BI DAX-Datumsfunktionen \u2013 R Digital Marketing","isPartOf":{"@id":"https:\/\/rmarketingdigital.com\/#website"},"primaryImageOfPage":{"@id":"https:\/\/rmarketingdigital.com\/en\/powerbi\/power-bi-dax-date-functions\/#primaryimage"},"image":{"@id":"https:\/\/rmarketingdigital.com\/en\/powerbi\/power-bi-dax-date-functions\/#primaryimage"},"thumbnailUrl":"https:\/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Power-BI-DAX-Date-Functions-30-3146592.png","datePublished":"2022-07-05T18:35:07+00:00","author":{"@id":"https:\/\/rmarketingdigital.com\/#\/schema\/person\/7c0d9782b2977b840b3740f00c69a73e"},"description":"Wie verwende ich Power BI DAX-Datumsfunktionen mit Beispielen? Microsoft Power BI DAX bietet verschiedene Datumsfunktionen wie Jahr, Monat, Tag,","inLanguage":"de","potentialAction":[{"@type":"ReadAction","target":["https:\/\/rmarketingdigital.com\/en\/powerbi\/power-bi-dax-date-functions\/"]}]},{"@type":"ImageObject","inLanguage":"de","@id":"https:\/\/rmarketingdigital.com\/en\/powerbi\/power-bi-dax-date-functions\/#primaryimage","url":"https:\/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Power-BI-DAX-Date-Functions-30-3146592.png","contentUrl":"https:\/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Power-BI-DAX-Date-Functions-30-3146592.png","width":945,"height":659,"caption":"power-bi-dax-date-functions-30-3146592-9981010-png"},{"@type":"WebSite","@id":"https:\/\/rmarketingdigital.com\/#website","url":"https:\/\/rmarketingdigital.com\/","name":"R Digitales Marketing","description":"SEO Agentur | Werbung f\u00fcr soziale Netzwerke | Community Management","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/rmarketingdigital.com\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"de"},{"@type":"Person","@id":"https:\/\/rmarketingdigital.com\/#\/schema\/person\/7c0d9782b2977b840b3740f00c69a73e","name":"R Digitales Marketing","image":{"@type":"ImageObject","inLanguage":"de","@id":"https:\/\/secure.gravatar.com\/avatar\/c5599c203e0120b8ccbff4666af86f35f9b3dcad468a8bc6295313a3964a80be?s=96&d=mm&r=g","url":"https:\/\/secure.gravatar.com\/avatar\/c5599c203e0120b8ccbff4666af86f35f9b3dcad468a8bc6295313a3964a80be?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/c5599c203e0120b8ccbff4666af86f35f9b3dcad468a8bc6295313a3964a80be?s=96&d=mm&r=g","caption":"R Marketing Digital"}}]}},"_links":{"self":[{"href":"https:\/\/rmarketingdigital.com\/de\/wp-json\/wp\/v2\/posts\/84200","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/rmarketingdigital.com\/de\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/rmarketingdigital.com\/de\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/rmarketingdigital.com\/de\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/rmarketingdigital.com\/de\/wp-json\/wp\/v2\/comments?post=84200"}],"version-history":[{"count":0,"href":"https:\/\/rmarketingdigital.com\/de\/wp-json\/wp\/v2\/posts\/84200\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/rmarketingdigital.com\/de\/wp-json\/wp\/v2\/media\/84199"}],"wp:attachment":[{"href":"https:\/\/rmarketingdigital.com\/de\/wp-json\/wp\/v2\/media?parent=84200"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/rmarketingdigital.com\/de\/wp-json\/wp\/v2\/categories?post=84200"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/rmarketingdigital.com\/de\/wp-json\/wp\/v2\/tags?post=84200"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}