{"id":84003,"date":"2022-07-06T04:41:46","date_gmt":"2022-07-06T02:41:46","guid":{"rendered":"https:\/\/rmarketingdigital.com\/funciones-de-cadena-de-power-bi-dax\/"},"modified":"2020-11-07T15:32:06","modified_gmt":"2020-11-07T18:32:06","slug":"funciones-de-cadena-de-power-bi-dax-2","status":"publish","type":"post","link":"https:\/\/rmarketingdigital.com\/en\/powerbi\/funciones-de-cadena-de-power-bi-dax-2\/","title":{"rendered":"Power BI DAX string functions"},"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\/en\/powerbi\/funciones-de-cadena-de-power-bi-dax-2\/#Funciones-de-cadena-de-Power-BI-DAX\" >Funciones de cadena 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\/en\/powerbi\/funciones-de-cadena-de-power-bi-dax-2\/#Funcion-Power-BI-DAX-LEN\" >Funci\u00f3n Power BI DAX LEN<\/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\/en\/powerbi\/funciones-de-cadena-de-power-bi-dax-2\/#Funcion-Power-BI-DAX-LEFT\" >Funci\u00f3n Power BI DAX LEFT<\/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\/en\/powerbi\/funciones-de-cadena-de-power-bi-dax-2\/#Funcion-Power-BI-DAX-RIGHT\" >Funci\u00f3n Power BI DAX RIGHT<\/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\/en\/powerbi\/funciones-de-cadena-de-power-bi-dax-2\/#Funcion-Power-BI-DAX-LOWER\" >Funci\u00f3n Power BI DAX LOWER<\/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\/en\/powerbi\/funciones-de-cadena-de-power-bi-dax-2\/#Funcion-SUPERIOR-de-Power-BI-DAX\" >Funci\u00f3n SUPERIOR 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-7\" href=\"https:\/\/rmarketingdigital.com\/en\/powerbi\/funciones-de-cadena-de-power-bi-dax-2\/#Funcion-de-Power-BI-DAX-MID\" >Funci\u00f3n de Power BI DAX MID<\/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\/en\/powerbi\/funciones-de-cadena-de-power-bi-dax-2\/#Funcion-REPT-de-Power-BI-DAX\" >Funci\u00f3n REPT 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\/en\/powerbi\/funciones-de-cadena-de-power-bi-dax-2\/#Funcion-SUSTITUTO-DE-DAX-de-Power-BI\" >Funci\u00f3n SUSTITUTO DE DAX de Power BI<\/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\/en\/powerbi\/funciones-de-cadena-de-power-bi-dax-2\/#Funcion-Power-BI-DAX-UNICHAR\" >Funci\u00f3n Power BI DAX UNICHAR<\/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\/en\/powerbi\/funciones-de-cadena-de-power-bi-dax-2\/#Funcion-Power-BI-DAX-EXACT\" >Funci\u00f3n Power BI DAX EXACT<\/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\/en\/powerbi\/funciones-de-cadena-de-power-bi-dax-2\/#Funcion-CONCATENAR-de-Power-BI-DAX\" >Funci\u00f3n CONCATENAR 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\/en\/powerbi\/funciones-de-cadena-de-power-bi-dax-2\/#Funcion-Power-BI-DAX-CONCATENATEX\" >Funci\u00f3n Power BI DAX CONCATENATEX<\/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\/en\/powerbi\/funciones-de-cadena-de-power-bi-dax-2\/#Funcion-Power-BI-DAX-FIXED\" >Funci\u00f3n Power BI DAX FIXED<\/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\/en\/powerbi\/funciones-de-cadena-de-power-bi-dax-2\/#Funcion-Power-BI-DAX-BLANK\" >Funci\u00f3n Power BI DAX BLANK<\/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\/en\/powerbi\/funciones-de-cadena-de-power-bi-dax-2\/#Funcion-Power-BI-DAX-UNICODE\" >Funci\u00f3n Power BI DAX UNICODE<\/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\/en\/powerbi\/funciones-de-cadena-de-power-bi-dax-2\/#Funcion-Power-BI-DAX-COMBINEVALUES\" >Funci\u00f3n Power BI DAX COMBINEVALUES<\/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\/en\/powerbi\/funciones-de-cadena-de-power-bi-dax-2\/#Funcion-Power-BI-DAX-FORMAT\" >Funci\u00f3n Power BI DAX FORMAT<\/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\/en\/powerbi\/funciones-de-cadena-de-power-bi-dax-2\/#Funcion-Power-BI-DAX-VALUE\" >Funci\u00f3n Power BI DAX VALUE<\/a><\/li><\/ul><\/li><\/ul><\/nav><\/div>\n<div>\n<p>Perm\u00edtame mostrarle c\u00f3mo usar las funciones de cadena de Power BI DAX con ejemplos. Microsoft Power BI DAX proporciona varias funciones de cadena como LEN, LEFT, RIGHT, LOWER, UPPER, MID, SUBSTITUTE, FORMAT, CONCATENATE, CONCATENATEX, REPT, UNICHAR, VALUES, etc.<\/p>\n<p>&nbsp;<\/p>\n<p>Para demostrar estas funciones de cadena de Power BI DAX, vamos a utilizar los datos que se muestran a continuaci\u00f3n. Como puede ver, hay 15 registros en esta tabla de Power BI.<\/p>\n<figure class=\"wp-block-image\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-33359\" src=\"https:\/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Power-BI-DAX-String-Functions-1-8303209.png\" srcset=\"\/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Power-BI-DAX-String-Functions-1-8303209.png 1211w, \/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Power-BI-DAX-String-Functions-1-8303209-300x165.png 300w, \/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Power-BI-DAX-String-Functions-1-8303209-1024x564.png 1024w, \/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Power-BI-DAX-String-Functions-1-8303209-768x423.png 768w\" alt=\"power-bi-dax-string-functions-1-8303209\" width=\"1211\" height=\"667\" data-lazy-sizes=\"(max-width: 1211px) 100vw, 1211px\" \/><noscript><img alt='power-bi-dax-string-functions-1-8303209' width='1211' height='667' src='https:\/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Power-BI-DAX-String-Functions-1-8303209.png' alt=\"Funciones de cadena de Power BI DAX 1\" class=\"wp-image-33359\" srcset='\/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Power-BI-DAX-String-Functions-1-8303209.png 1211w, \/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Power-BI-DAX-String-Functions-1-8303209-300x165.png 300w, \/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Power-BI-DAX-String-Functions-1-8303209-1024x564.png 1024w, \/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Power-BI-DAX-String-Functions-1-8303209-768x423.png 768w' sizes='(max-width: 1211px) 100vw, 1211px'\/><\/noscript><\/figure>\n<h2><span class=\"ez-toc-section\" id=\"Funciones-de-cadena-de-Power-BI-DAX\"><\/span>Funciones de cadena 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 cadena DAX en Power BI<\/p>\n<h3><span class=\"ez-toc-section\" id=\"Funcion-Power-BI-DAX-LEN\"><\/span>Funci\u00f3n Power BI DAX LEN<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p>La funci\u00f3n DAX Now devuelve la longitud de una cadena determinada. La sintaxis de este Power BI DAX LEN es<\/p>\n<pre class=\"wp-block-preformatted lang:tsql decode:true\">LEN(string)<\/pre>\n<p>Para demostrar estas funciones de cadena DAX en Power BI, tenemos que usar la columna calculada. 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>&nbsp;<\/p>\n<figure class=\"wp-block-image\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-33360\" src=\"https:\/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Power-BI-DAX-String-Functions-2-6444336.png\" srcset=\"\/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Power-BI-DAX-String-Functions-2-6444336.png 1113w, \/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Power-BI-DAX-String-Functions-2-6444336-300x175.png 300w, \/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Power-BI-DAX-String-Functions-2-6444336-1024x597.png 1024w, \/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Power-BI-DAX-String-Functions-2-6444336-768x448.png 768w\" alt=\"power-bi-dax-string-functions-2-6444336\" width=\"1113\" height=\"649\" data-lazy-sizes=\"(max-width: 1113px) 100vw, 1113px\" \/><noscript><img alt='power-bi-dax-string-functions-2-6444336' width='1113' height='649' src='https:\/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Power-BI-DAX-String-Functions-2-6444336.png' alt=\"Funciones de cadena de Power BI DAX 2\" class=\"wp-image-33360\" srcset='\/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Power-BI-DAX-String-Functions-2-6444336.png 1113w, \/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Power-BI-DAX-String-Functions-2-6444336-300x175.png 300w, \/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Power-BI-DAX-String-Functions-2-6444336-1024x597.png 1024w, \/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Power-BI-DAX-String-Functions-2-6444336-768x448.png 768w' sizes='(max-width: 1113px) 100vw, 1113px'\/><\/noscript><\/figure>\n<p>Como puede ver en la captura de pantalla a continuaci\u00f3n, cambiamos el nombre de la columna predeterminada a LEN. La siguiente declaraci\u00f3n encuentra la longitud de una cadena de caracteres en la columna Nombre del departamento.<\/p>\n<pre class=\"wp-block-preformatted lang:tsql decode:true\">LEN = LEN(EmployeeSales[Department Name])<\/pre>\n<p>Perm\u00edtanme agregar esta columna Power BI DAX LEN 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 loading=\"lazy\" decoding=\"async\" class=\"wp-image-33361\" src=\"https:\/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Power-BI-DAX-String-Functions-3-1200282.png\" srcset=\"\/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Power-BI-DAX-String-Functions-3-1200282.png 1113w, \/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Power-BI-DAX-String-Functions-3-1200282-300x175.png 300w, \/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Power-BI-DAX-String-Functions-3-1200282-1024x596.png 1024w, \/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Power-BI-DAX-String-Functions-3-1200282-768x447.png 768w\" alt=\"power-bi-dax-string-functions-3-1200282\" width=\"1113\" height=\"648\" data-lazy-sizes=\"(max-width: 1113px) 100vw, 1113px\" \/><noscript><img alt='power-bi-dax-string-functions-3-1200282' width='1113' height='648' src='https:\/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Power-BI-DAX-String-Functions-3-1200282.png' alt=\"Funci\u00f3n 3 de Power BI DAX LEN\" class=\"wp-image-33361\" srcset='\/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Power-BI-DAX-String-Functions-3-1200282.png 1113w, \/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Power-BI-DAX-String-Functions-3-1200282-300x175.png 300w, \/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Power-BI-DAX-String-Functions-3-1200282-1024x596.png 1024w, \/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Power-BI-DAX-String-Functions-3-1200282-768x447.png 768w' sizes='(max-width: 1113px) 100vw, 1113px'\/><\/noscript><\/figure>\n<h3><span class=\"ez-toc-section\" id=\"Funcion-Power-BI-DAX-LEFT\"><\/span>Funci\u00f3n Power BI DAX LEFT<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p>La funci\u00f3n Power BI DAX LEFT devuelve los caracteres situados m\u00e1s a la izquierda desde una cadena hasta una posici\u00f3n de \u00edndice especificada. La sintaxis de la funci\u00f3n Power BI DAX LEFT es<\/p>\n<pre class=\"wp-block-preformatted lang:tsql decode:true\">LEFT(string, position)<\/pre>\n<p>La siguiente declaraci\u00f3n devuelve los 8 caracteres m\u00e1s a la izquierda de la columna Nombre del departamento<\/p>\n<pre class=\"wp-block-preformatted lang:tsql decode:true\">LEFT = LEFT(EmployeeSales[Department Name], 8)<\/pre>\n<figure class=\"wp-block-image\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-33362\" src=\"https:\/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Power-BI-DAX-String-Functions-4-2043937.png\" srcset=\"\/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Power-BI-DAX-String-Functions-4-2043937.png 1113w, \/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Power-BI-DAX-String-Functions-4-2043937-300x175.png 300w, \/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Power-BI-DAX-String-Functions-4-2043937-1024x596.png 1024w, \/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Power-BI-DAX-String-Functions-4-2043937-768x447.png 768w\" alt=\"power-bi-dax-string-functions-4-2043937\" width=\"1113\" height=\"648\" data-lazy-sizes=\"(max-width: 1113px) 100vw, 1113px\" \/><noscript><img alt='power-bi-dax-string-functions-4-2043937' width='1113' height='648' src='https:\/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Power-BI-DAX-String-Functions-4-2043937.png' alt=\"Funci\u00f3n 4 de Power BI DAX LEFT\" class=\"wp-image-33362\" srcset='\/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Power-BI-DAX-String-Functions-4-2043937.png 1113w, \/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Power-BI-DAX-String-Functions-4-2043937-300x175.png 300w, \/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Power-BI-DAX-String-Functions-4-2043937-1024x596.png 1024w, \/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Power-BI-DAX-String-Functions-4-2043937-768x447.png 768w' sizes='(max-width: 1113px) 100vw, 1113px'\/><\/noscript><\/figure>\n<h3><span class=\"ez-toc-section\" id=\"Funcion-Power-BI-DAX-RIGHT\"><\/span>Funci\u00f3n Power BI DAX RIGHT<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p>La funci\u00f3n Power BI DAX RIGHT devuelve los caracteres situados m\u00e1s a la derecha desde una cadena hasta una posici\u00f3n de \u00edndice especificada. La sintaxis de la funci\u00f3n Power BI DAX RIGHT es<\/p>\n<pre class=\"wp-block-preformatted lang:tsql decode:true\">RIGHT(string, position)<\/pre>\n<p>Devuelve los 6 caracteres m\u00e1s a la derecha de la columna Nombre del departamento<\/p>\n<pre class=\"wp-block-preformatted lang:tsql decode:true\">RIGHT = RIGHT(EmployeeSales[Department Name], 6)<\/pre>\n<figure class=\"wp-block-image\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-33363\" src=\"https:\/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Power-BI-DAX-String-Functions-5-5567036.png\" srcset=\"\/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Power-BI-DAX-String-Functions-5-5567036.png 1113w, \/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Power-BI-DAX-String-Functions-5-5567036-300x175.png 300w, \/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Power-BI-DAX-String-Functions-5-5567036-1024x599.png 1024w, \/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Power-BI-DAX-String-Functions-5-5567036-768x449.png 768w\" alt=\"power-bi-dax-string-functions-5-5567036\" width=\"1113\" height=\"651\" data-lazy-sizes=\"(max-width: 1113px) 100vw, 1113px\" \/><noscript><img alt='power-bi-dax-string-functions-5-5567036' width='1113' height='651' src='https:\/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Power-BI-DAX-String-Functions-5-5567036.png' alt=\"Funci\u00f3n 5 de Power BI DAX RIGHT\" class=\"wp-image-33363\" srcset='\/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Power-BI-DAX-String-Functions-5-5567036.png 1113w, \/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Power-BI-DAX-String-Functions-5-5567036-300x175.png 300w, \/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Power-BI-DAX-String-Functions-5-5567036-1024x599.png 1024w, \/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Power-BI-DAX-String-Functions-5-5567036-768x449.png 768w' sizes='(max-width: 1113px) 100vw, 1113px'\/><\/noscript><\/figure>\n<h3><span class=\"ez-toc-section\" id=\"Funcion-Power-BI-DAX-LOWER\"><\/span>Funci\u00f3n Power BI DAX LOWER<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p>La funci\u00f3n Power BI DAX LOWER convierte la cadena de caracteres dada a min\u00fasculas. La sintaxis de la funci\u00f3n Power BI DAX LOWER es<\/p>\n<pre class=\"wp-block-preformatted lang:tsql decode:true\">LOWER(string)<\/pre>\n<p>La siguiente funci\u00f3n inferior de Power BI DAX convierte la columna del nombre del departamento en min\u00fasculas<\/p>\n<pre class=\"wp-block-preformatted lang:tsql decode:true\">LOWER = LOWER(EmployeeSales[Department Name])<\/pre>\n<figure class=\"wp-block-image\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-33364\" src=\"https:\/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Power-BI-DAX-String-Functions-6-4184160.png\" srcset=\"\/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Power-BI-DAX-String-Functions-6-4184160.png 1113w, \/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Power-BI-DAX-String-Functions-6-4184160-300x176.png 300w, \/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Power-BI-DAX-String-Functions-6-4184160-1024x600.png 1024w, \/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Power-BI-DAX-String-Functions-6-4184160-768x450.png 768w\" alt=\"power-bi-dax-string-functions-6-4184160\" width=\"1113\" height=\"652\" data-lazy-sizes=\"(max-width: 1113px) 100vw, 1113px\" \/><noscript><img alt='power-bi-dax-string-functions-6-4184160' width='1113' height='652' src='https:\/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Power-BI-DAX-String-Functions-6-4184160.png' alt=\"Funci\u00f3n 6 de Power BI DAX LOWER\" class=\"wp-image-33364\" srcset='\/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Power-BI-DAX-String-Functions-6-4184160.png 1113w, \/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Power-BI-DAX-String-Functions-6-4184160-300x176.png 300w, \/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Power-BI-DAX-String-Functions-6-4184160-1024x600.png 1024w, \/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Power-BI-DAX-String-Functions-6-4184160-768x450.png 768w' sizes='(max-width: 1113px) 100vw, 1113px'\/><\/noscript><\/figure>\n<h3><span class=\"ez-toc-section\" id=\"Funcion-SUPERIOR-de-Power-BI-DAX\"><\/span>Funci\u00f3n SUPERIOR de Power BI DAX<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p>La funci\u00f3n Power BI DAX UPPER convierte la cadena dada en may\u00fasculas. La sintaxis de la funci\u00f3n UPPER de Power BI DAX es<\/p>\n<pre class=\"wp-block-preformatted lang:tsql decode:true\">UPPER(string)<\/pre>\n<p>La siguiente funci\u00f3n superior de Power BI DAX convierte la cadena de la columna del nombre del departamento en may\u00fasculas<span id=\"ezoic-pub-ad-placeholder-106\" class=\"ezoic-adpicker-ad\"><\/span><span id=\"div-gpt-ad-tutorialgateway_org-banner-1-0\" class=\"ezoic-ad ezoic-adl\" style=\"position: relative; z-index: 0; display: inline-block; width: 100%; max-width: 1200px; margin-left: auto !important; margin-right: auto !important; min-height: 250px; min-width: 300px;\"><\/span><\/p>\n<pre class=\"wp-block-preformatted lang:tsql decode:true\">UPPER = UPPER(EmployeeSales[Department Name])<\/pre>\n<figure class=\"wp-block-image\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-33365\" src=\"https:\/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Power-BI-DAX-String-Functions-7-1505409.png\" srcset=\"\/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Power-BI-DAX-String-Functions-7-1505409.png 1113w, \/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Power-BI-DAX-String-Functions-7-1505409-300x175.png 300w, \/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Power-BI-DAX-String-Functions-7-1505409-1024x598.png 1024w, \/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Power-BI-DAX-String-Functions-7-1505409-768x449.png 768w\" alt=\"power-bi-dax-string-functions-7-1505409\" width=\"1113\" height=\"650\" data-lazy-sizes=\"(max-width: 1113px) 100vw, 1113px\" \/><noscript><img alt='power-bi-dax-string-functions-7-1505409' width='1113' height='650' src='https:\/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Power-BI-DAX-String-Functions-7-1505409.png' alt=\"Funci\u00f3n 7 de Power BI DAX UPPER\" class=\"wp-image-33365\" srcset='\/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Power-BI-DAX-String-Functions-7-1505409.png 1113w, \/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Power-BI-DAX-String-Functions-7-1505409-300x175.png 300w, \/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Power-BI-DAX-String-Functions-7-1505409-1024x598.png 1024w, \/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Power-BI-DAX-String-Functions-7-1505409-768x449.png 768w' sizes='(max-width: 1113px) 100vw, 1113px'\/><\/noscript><\/figure>\n<h3><span class=\"ez-toc-section\" id=\"Funcion-de-Power-BI-DAX-MID\"><\/span>Funci\u00f3n de Power BI DAX MID<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p>La funci\u00f3n Power BI DAX MID devuelve una subcadena de la cadena original. La sintaxis de la funci\u00f3n Power BI DAX MID es<\/p>\n<pre class=\"wp-block-preformatted lang:tsql decode:true\">MID(string, starting_position, length)<\/pre>\n<p>Esta funci\u00f3n de Power BI DAX MID acepta tres argumentos:<\/p>\n<ul>\n<li>Posici\u00f3n inicial: la subcadena comienza desde esta posici\u00f3n<\/li>\n<li>Longitud: longitud total de una subcadena.<\/li>\n<\/ul>\n<p>Devuelve una subcadena de la columna Nombre del departamento. La subcadena comienza en la posici\u00f3n 4 y termina cuando la longitud de la cuerda llega a 7.<\/p>\n<pre class=\"wp-block-preformatted lang:tsql decode:true\">MID = MID(EmployeeSales[Department Name], 4, 7)<\/pre>\n<figure class=\"wp-block-image\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-33366\" src=\"https:\/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Power-BI-DAX-String-Functions-8-7999819.png\" srcset=\"\/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Power-BI-DAX-String-Functions-8-7999819.png 1113w, \/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Power-BI-DAX-String-Functions-8-7999819-300x175.png 300w, \/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Power-BI-DAX-String-Functions-8-7999819-1024x599.png 1024w, \/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Power-BI-DAX-String-Functions-8-7999819-768x449.png 768w\" alt=\"power-bi-dax-string-functions-8-7999819\" width=\"1113\" height=\"651\" data-lazy-sizes=\"(max-width: 1113px) 100vw, 1113px\" \/><noscript><img alt='power-bi-dax-string-functions-8-7999819' width='1113' height='651' src='https:\/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Power-BI-DAX-String-Functions-8-7999819.png' alt=\"Funci\u00f3n 8 de Power BI DAX MID\" class=\"wp-image-33366\" srcset='\/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Power-BI-DAX-String-Functions-8-7999819.png 1113w, \/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Power-BI-DAX-String-Functions-8-7999819-300x175.png 300w, \/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Power-BI-DAX-String-Functions-8-7999819-1024x599.png 1024w, \/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Power-BI-DAX-String-Functions-8-7999819-768x449.png 768w' sizes='(max-width: 1113px) 100vw, 1113px'\/><\/noscript><\/figure>\n<h3><span class=\"ez-toc-section\" id=\"Funcion-REPT-de-Power-BI-DAX\"><\/span>Funci\u00f3n REPT de Power BI DAX<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p>La funci\u00f3n REPT de Power BI DAX repite una cadena el n\u00famero de veces especificado por el usuario. La sintaxis de la funci\u00f3n REPT de Power BI DAX es:<\/p>\n<pre class=\"wp-block-preformatted lang:tsql decode:true\">REPT(string, no_of_times)<\/pre>\n<p>Repite los datos de la columna Apellido 2 veces.<\/p>\n<pre class=\"wp-block-preformatted lang:tsql decode:true\">REPT = REPT(EmployeeSales[LastName], 2)<\/pre>\n<figure class=\"wp-block-image\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-33367\" src=\"https:\/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Power-BI-DAX-String-Functions-9-4378560.png\" srcset=\"\/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Power-BI-DAX-String-Functions-9-4378560.png 1092w, \/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Power-BI-DAX-String-Functions-9-4378560-300x176.png 300w, \/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Power-BI-DAX-String-Functions-9-4378560-1024x602.png 1024w, \/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Power-BI-DAX-String-Functions-9-4378560-768x452.png 768w\" alt=\"power-bi-dax-string-functions-9-4378560\" width=\"1092\" height=\"642\" data-lazy-sizes=\"(max-width: 1092px) 100vw, 1092px\" \/><noscript><img alt='power-bi-dax-string-functions-9-4378560' width='1092' height='642' src='https:\/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Power-BI-DAX-String-Functions-9-4378560.png' alt=\"Funci\u00f3n 9 de Power BI DAX REPT\" class=\"wp-image-33367\" srcset='\/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Power-BI-DAX-String-Functions-9-4378560.png 1092w, \/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Power-BI-DAX-String-Functions-9-4378560-300x176.png 300w, \/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Power-BI-DAX-String-Functions-9-4378560-1024x602.png 1024w, \/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Power-BI-DAX-String-Functions-9-4378560-768x452.png 768w' sizes='(max-width: 1092px) 100vw, 1092px'\/><\/noscript><\/figure>\n<h3><span class=\"ez-toc-section\" id=\"Funcion-SUSTITUTO-DE-DAX-de-Power-BI\"><\/span>Funci\u00f3n SUSTITUTO DE DAX de Power BI<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p>La funci\u00f3n SUBSTITUTO de Power BI DAX repite una cadena el n\u00famero de veces especificado por el usuario. La sintaxis de esta funci\u00f3n SUBSTITUTO de Power BI DAX es:<\/p>\n<pre class=\"wp-block-preformatted lang:tsql decode:true\">SUBSTITUTE(string, old_string, new_string)<\/pre>\n<p>Reemplaza la palabra Software con Web dentro de los valores de la columna Nombre del departamento<\/p>\n<pre class=\"wp-block-preformatted lang:tsql decode:true\">SUBSTITUTE = SUBSTITUTE(EmployeeSales[Department Name], \"Software\", \"Web\")<\/pre>\n<figure class=\"wp-block-image\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-33368\" src=\"https:\/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Power-BI-DAX-String-Functions-10-1283889.png\" srcset=\"\/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Power-BI-DAX-String-Functions-10-1283889.png 1093w, \/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Power-BI-DAX-String-Functions-10-1283889-300x183.png 300w, \/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Power-BI-DAX-String-Functions-10-1283889-1024x623.png 1024w, \/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Power-BI-DAX-String-Functions-10-1283889-768x467.png 768w\" alt=\"power-bi-dax-string-functions-10-1283889\" width=\"1093\" height=\"665\" data-lazy-sizes=\"(max-width: 1093px) 100vw, 1093px\" \/><noscript><img alt='power-bi-dax-string-functions-10-1283889' width='1093' height='665' src='https:\/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Power-BI-DAX-String-Functions-10-1283889.png' alt=\"Funci\u00f3n de SUSTITUCI\u00d3N de DAX de Power BI 10\" class=\"wp-image-33368\" srcset='\/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Power-BI-DAX-String-Functions-10-1283889.png 1093w, \/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Power-BI-DAX-String-Functions-10-1283889-300x183.png 300w, \/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Power-BI-DAX-String-Functions-10-1283889-1024x623.png 1024w, \/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Power-BI-DAX-String-Functions-10-1283889-768x467.png 768w' sizes='(max-width: 1093px) 100vw, 1093px'\/><\/noscript><\/figure>\n<h3><span class=\"ez-toc-section\" id=\"Funcion-Power-BI-DAX-UNICHAR\"><\/span>Funci\u00f3n Power BI DAX UNICHAR<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p>La funci\u00f3n Power BI DAX UNICHAR devuelve el car\u00e1cter Unicode para el valor ASCII dado. La sintaxis de la funci\u00f3n Power BI DAX UNICHAR es:<\/p>\n<pre class=\"wp-block-preformatted lang:tsql decode:true\">UNICHAR(number)<\/pre>\n<p>Devuelve los caracteres Unicode del ingreso anual dividido por 2<\/p>\n<pre class=\"wp-block-preformatted lang:tsql decode:true\">UNICHAR = UNICHAR(EmployeeSales[Yearly Income] \/ 2)<\/pre>\n<figure class=\"wp-block-image\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-33369\" src=\"https:\/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Power-BI-DAX-String-Functions-11-4451983.png\" srcset=\"\/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Power-BI-DAX-String-Functions-11-4451983.png 1093w, \/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Power-BI-DAX-String-Functions-11-4451983-300x188.png 300w, \/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Power-BI-DAX-String-Functions-11-4451983-1024x641.png 1024w, \/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Power-BI-DAX-String-Functions-11-4451983-768x481.png 768w\" alt=\"power-bi-dax-string-functions-11-4451983\" width=\"1093\" height=\"684\" data-lazy-sizes=\"(max-width: 1093px) 100vw, 1093px\" \/><noscript><img alt='power-bi-dax-string-functions-11-4451983' width='1093' height='684' src='https:\/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Power-BI-DAX-String-Functions-11-4451983.png' alt=\"Funci\u00f3n 11 de Power BI DAX UNICHAR\" class=\"wp-image-33369\" srcset='\/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Power-BI-DAX-String-Functions-11-4451983.png 1093w, \/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Power-BI-DAX-String-Functions-11-4451983-300x188.png 300w, \/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Power-BI-DAX-String-Functions-11-4451983-1024x641.png 1024w, \/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Power-BI-DAX-String-Functions-11-4451983-768x481.png 768w' sizes='(max-width: 1093px) 100vw, 1093px'\/><\/noscript><\/figure>\n<h3><span class=\"ez-toc-section\" id=\"Funcion-Power-BI-DAX-EXACT\"><\/span>Funci\u00f3n Power BI DAX EXACT<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p>La funci\u00f3n DAX EXACT compara dos cadenas y devuelve verdadero si son exactamente iguales; de lo contrario, devuelve falso. La sintaxis de esta funci\u00f3n Power BI DAX EXACT es:<\/p>\n<pre class=\"wp-block-preformatted lang:tsql decode:true\">EXACT(string1, string2)<\/pre>\n<p>Debajo de Power Bi DAX Enunciado exacto compare el nombre del departamento con los 18 caracteres m\u00e1s a la izquierda del nombre del departamento<\/p>\n<pre class=\"wp-block-preformatted lang:tsql decode:true\">EXACT = EXACT(EmployeeSales[Department Name], LEFT(EmployeeSales[Department Name], 18))<\/pre>\n<figure class=\"wp-block-image\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-33370\" src=\"https:\/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Power-BI-DAX-String-Functions-12-4690494.png\" srcset=\"\/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Power-BI-DAX-String-Functions-12-4690494.png 1093w, \/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Power-BI-DAX-String-Functions-12-4690494-300x176.png 300w, \/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Power-BI-DAX-String-Functions-12-4690494-1024x601.png 1024w, \/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Power-BI-DAX-String-Functions-12-4690494-768x451.png 768w\" alt=\"power-bi-dax-string-functions-12-4690494\" width=\"1093\" height=\"642\" data-lazy-sizes=\"(max-width: 1093px) 100vw, 1093px\" \/><noscript><img alt='power-bi-dax-string-functions-12-4690494' width='1093' height='642' src='https:\/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Power-BI-DAX-String-Functions-12-4690494.png' alt=\"Funci\u00f3n Power BI DAX EXACT 12\" class=\"wp-image-33370\" srcset='\/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Power-BI-DAX-String-Functions-12-4690494.png 1093w, \/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Power-BI-DAX-String-Functions-12-4690494-300x176.png 300w, \/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Power-BI-DAX-String-Functions-12-4690494-1024x601.png 1024w, \/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Power-BI-DAX-String-Functions-12-4690494-768x451.png 768w' sizes='(max-width: 1093px) 100vw, 1093px'\/><\/noscript><\/figure>\n<h3><span class=\"ez-toc-section\" id=\"Funcion-CONCATENAR-de-Power-BI-DAX\"><\/span>Funci\u00f3n CONCATENAR de Power BI DAX<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p>La funci\u00f3n CONCATENAR de Power BI DAX es \u00fatil para concatenar dos cadenas. La sintaxis de esta funci\u00f3n CONCATENAR de Power BI DAX es:<\/p>\n<pre class=\"wp-block-preformatted lang:tsql decode:true\">CONCATENATE(string1, string2)<\/pre>\n<p>La siguiente funci\u00f3n CONCATENAR de Power BI DAX concatena el nombre y el apellido<\/p>\n<pre class=\"wp-block-preformatted lang:tsql decode:true\">CONCAT = CONCATENATE(EmployeeSales[FirstName], EmployeeSales[LastName])<\/pre>\n<figure class=\"wp-block-image\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-33371\" src=\"https:\/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Power-BI-DAX-String-Functions-13-4753351.png\" srcset=\"\/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Power-BI-DAX-String-Functions-13-4753351.png 1093w, \/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Power-BI-DAX-String-Functions-13-4753351-300x176.png 300w, \/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Power-BI-DAX-String-Functions-13-4753351-1024x601.png 1024w, \/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Power-BI-DAX-String-Functions-13-4753351-768x451.png 768w\" alt=\"power-bi-dax-string-functions-13-4753351\" width=\"1093\" height=\"642\" data-lazy-sizes=\"(max-width: 1093px) 100vw, 1093px\" \/><noscript><img alt='power-bi-dax-string-functions-13-4753351' width='1093' height='642' src='https:\/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Power-BI-DAX-String-Functions-13-4753351.png' alt=\"Funci\u00f3n CONCATENAR de Power BI DAX 13\" class=\"wp-image-33371\" srcset='\/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Power-BI-DAX-String-Functions-13-4753351.png 1093w, \/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Power-BI-DAX-String-Functions-13-4753351-300x176.png 300w, \/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Power-BI-DAX-String-Functions-13-4753351-1024x601.png 1024w, \/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Power-BI-DAX-String-Functions-13-4753351-768x451.png 768w' sizes='(max-width: 1093px) 100vw, 1093px'\/><\/noscript><\/figure>\n<h3><span class=\"ez-toc-section\" id=\"Funcion-Power-BI-DAX-CONCATENATEX\"><\/span>Funci\u00f3n Power BI DAX CONCATENATEX<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p>La funci\u00f3n DAX CONCATENATEX es concatenar todas las filas en una columna usando el delimitador especificado. La sintaxis de esta funci\u00f3n CONCATENATEX de Power BI DAX es:<\/p>\n<pre class=\"wp-block-preformatted lang:tsql decode:true\">CONCATENATEX(tableName, ColumnName, Delimiter)<\/pre>\n<p>La siguiente instrucci\u00f3n de Power BI DAX concatena todas las filas de la columna de apellido mediante un delimitador de coma.<\/p>\n<pre class=\"wp-block-preformatted lang:tsql decode:true\">CONCATENATEX = CONCATENATEX(EmployeeSales, EmployeeSales[LastName], \",\")<\/pre>\n<figure class=\"wp-block-image\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-33372\" src=\"https:\/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Power-BI-DAX-String-Functions-14-7183967.png\" srcset=\"\/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Power-BI-DAX-String-Functions-14-7183967.png 1093w, \/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Power-BI-DAX-String-Functions-14-7183967-300x184.png 300w, \/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Power-BI-DAX-String-Functions-14-7183967-1024x627.png 1024w, \/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Power-BI-DAX-String-Functions-14-7183967-768x470.png 768w\" alt=\"power-bi-dax-string-functions-14-7183967\" width=\"1093\" height=\"669\" data-lazy-sizes=\"(max-width: 1093px) 100vw, 1093px\" \/><noscript><img alt='power-bi-dax-string-functions-14-7183967' width='1093' height='669' src='https:\/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Power-BI-DAX-String-Functions-14-7183967.png' alt=\"Funci\u00f3n 14 de Power BI DAX CONCATENATEX\" class=\"wp-image-33372\" srcset='\/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Power-BI-DAX-String-Functions-14-7183967.png 1093w, \/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Power-BI-DAX-String-Functions-14-7183967-300x184.png 300w, \/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Power-BI-DAX-String-Functions-14-7183967-1024x627.png 1024w, \/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Power-BI-DAX-String-Functions-14-7183967-768x470.png 768w' sizes='(max-width: 1093px) 100vw, 1093px'\/><\/noscript><\/figure>\n<h3><span class=\"ez-toc-section\" id=\"Funcion-Power-BI-DAX-FIXED\"><\/span>Funci\u00f3n Power BI DAX FIXED<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p>La funci\u00f3n Power BI DAX FIXED es \u00fatil para redondear el n\u00famero dado a un n\u00famero espec\u00edfico de d\u00edgitos y devuelve el tipo de datos de texto. La sintaxis de la funci\u00f3n Power BI DAX FIXED es:<\/p>\n<pre class=\"wp-block-preformatted lang:tsql decode:true\">FIXED(number, decimals, comma)<\/pre>\n<p>La siguiente funci\u00f3n Power BI DAX FIXED redondea los decimales de ventas a un solo d\u00edgito, y no permitir\u00e1 comas<\/p>\n<pre class=\"wp-block-preformatted lang:tsql decode:true\">FIXED = FIXED(EmployeeSales[Sales], 1, 1)<\/pre>\n<figure class=\"wp-block-image\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-33373\" src=\"https:\/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Power-BI-DAX-String-Functions-15-8257628.png\" srcset=\"\/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Power-BI-DAX-String-Functions-15-8257628.png 1093w, \/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Power-BI-DAX-String-Functions-15-8257628-300x176.png 300w, \/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Power-BI-DAX-String-Functions-15-8257628-1024x600.png 1024w, \/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Power-BI-DAX-String-Functions-15-8257628-768x450.png 768w\" alt=\"power-bi-dax-string-functions-15-8257628\" width=\"1093\" height=\"640\" data-lazy-sizes=\"(max-width: 1093px) 100vw, 1093px\" \/><noscript><img alt='power-bi-dax-string-functions-15-8257628' width='1093' height='640' src='https:\/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Power-BI-DAX-String-Functions-15-8257628.png' alt=\"Funci\u00f3n 15 de Power BI DAX FIXED\" class=\"wp-image-33373\" srcset='\/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Power-BI-DAX-String-Functions-15-8257628.png 1093w, \/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Power-BI-DAX-String-Functions-15-8257628-300x176.png 300w, \/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Power-BI-DAX-String-Functions-15-8257628-1024x600.png 1024w, \/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Power-BI-DAX-String-Functions-15-8257628-768x450.png 768w' sizes='(max-width: 1093px) 100vw, 1093px'\/><\/noscript><\/figure>\n<h3><span class=\"ez-toc-section\" id=\"Funcion-Power-BI-DAX-BLANK\"><\/span>Funci\u00f3n Power BI DAX BLANK<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p>La funci\u00f3n Power BI DAX BLANK es \u00fatil para devolver un espacio en blanco. Tambi\u00e9n puede usar esto para verificar si los cuervos tienen espacios en blanco o no. La sintaxis de esta funci\u00f3n en BLANCO de Power BI DAX es:<\/p>\n<pre class=\"wp-block-preformatted lang:tsql decode:true\">BLANK()<\/pre>\n<p>A continuaci\u00f3n, la declaraci\u00f3n If comprueba si hay espacios en blanco al dividir Ventas por Grado de servicio; si es verdadero, el espacio en blanco se reemplaza por 100. De lo contrario, devuelve el resultado.<\/p>\n<pre class=\"wp-block-preformatted lang:tsql decode:true\">BLACNK = IF(DIVIDE(EmployeeSales[Sales], EmployeeSales[Service Grade]) = BLANK(), \r\n                100, DIVIDE(EmployeeSales[Sales], EmployeeSales[Service Grade]))<\/pre>\n<figure class=\"wp-block-image\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-33374\" src=\"https:\/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Power-BI-DAX-String-Functions-16-9576699.png\" srcset=\"\/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Power-BI-DAX-String-Functions-16-9576699.png 1081w, \/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Power-BI-DAX-String-Functions-16-9576699-300x182.png 300w, \/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Power-BI-DAX-String-Functions-16-9576699-1024x621.png 1024w, \/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Power-BI-DAX-String-Functions-16-9576699-768x466.png 768w\" alt=\"power-bi-dax-string-functions-16-9576699\" width=\"1081\" height=\"656\" data-lazy-sizes=\"(max-width: 1081px) 100vw, 1081px\" \/><noscript><img alt='power-bi-dax-string-functions-16-9576699' width='1081' height='656' src='https:\/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Power-BI-DAX-String-Functions-16-9576699.png' alt=\"Funci\u00f3n 16 de Power BI DAX BLANK\" class=\"wp-image-33374\" srcset='\/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Power-BI-DAX-String-Functions-16-9576699.png 1081w, \/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Power-BI-DAX-String-Functions-16-9576699-300x182.png 300w, \/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Power-BI-DAX-String-Functions-16-9576699-1024x621.png 1024w, \/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Power-BI-DAX-String-Functions-16-9576699-768x466.png 768w' sizes='(max-width: 1081px) 100vw, 1081px'\/><\/noscript><\/figure>\n<p>En la captura de pantalla a continuaci\u00f3n, puede ver el resultado.<\/p>\n<figure class=\"wp-block-image\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-33375\" src=\"https:\/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Power-BI-DAX-String-Functions-17-7445400.png\" srcset=\"\/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Power-BI-DAX-String-Functions-17-7445400.png 1084w, \/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Power-BI-DAX-String-Functions-17-7445400-300x196.png 300w, \/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Power-BI-DAX-String-Functions-17-7445400-1024x670.png 1024w, \/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Power-BI-DAX-String-Functions-17-7445400-768x502.png 768w\" alt=\"power-bi-dax-string-functions-17-7445400\" width=\"1084\" height=\"709\" data-lazy-sizes=\"(max-width: 1084px) 100vw, 1084px\" \/><noscript><img alt='power-bi-dax-string-functions-17-7445400' width='1084' height='709' src='https:\/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Power-BI-DAX-String-Functions-17-7445400.png' alt=\"Funci\u00f3n 17 de Power BI DAX BLANK\" class=\"wp-image-33375\" srcset='\/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Power-BI-DAX-String-Functions-17-7445400.png 1084w, \/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Power-BI-DAX-String-Functions-17-7445400-300x196.png 300w, \/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Power-BI-DAX-String-Functions-17-7445400-1024x670.png 1024w, \/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Power-BI-DAX-String-Functions-17-7445400-768x502.png 768w' sizes='(max-width: 1084px) 100vw, 1084px'\/><\/noscript><\/figure>\n<h3><span class=\"ez-toc-section\" id=\"Funcion-Power-BI-DAX-UNICODE\"><\/span>Funci\u00f3n Power BI DAX UNICODE<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p>La funci\u00f3n DAX UNICODE devuelve el valor ASCII del primer car\u00e1cter de una cadena. La sintaxis de esta funci\u00f3n UNICODE de Power BI DAX es:<\/p>\n<pre class=\"wp-block-preformatted lang:tsql decode:true\">UNICODE(string)<\/pre>\n<p>Devuelve el valor ASCII del primer car\u00e1cter en la columna de apellido<\/p>\n<pre class=\"wp-block-preformatted lang:tsql decode:true\">CODE = UNICODE(EmployeeSales[LastName])<\/pre>\n<figure class=\"wp-block-image\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-33376\" src=\"https:\/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Power-BI-DAX-String-Functions-18-4627620.png\" srcset=\"\/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Power-BI-DAX-String-Functions-18-4627620.png 1068w, \/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Power-BI-DAX-String-Functions-18-4627620-300x177.png 300w, \/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Power-BI-DAX-String-Functions-18-4627620-1024x604.png 1024w, \/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Power-BI-DAX-String-Functions-18-4627620-768x453.png 768w\" alt=\"power-bi-dax-string-functions-18-4627620\" width=\"1068\" height=\"630\" data-lazy-sizes=\"(max-width: 1068px) 100vw, 1068px\" \/><noscript><img alt='power-bi-dax-string-functions-18-4627620' width='1068' height='630' src='https:\/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Power-BI-DAX-String-Functions-18-4627620.png' alt=\"Funci\u00f3n UNICODE de Power BI DAX 18\" class=\"wp-image-33376\" srcset='\/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Power-BI-DAX-String-Functions-18-4627620.png 1068w, \/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Power-BI-DAX-String-Functions-18-4627620-300x177.png 300w, \/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Power-BI-DAX-String-Functions-18-4627620-1024x604.png 1024w, \/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Power-BI-DAX-String-Functions-18-4627620-768x453.png 768w' sizes='(max-width: 1068px) 100vw, 1068px'\/><\/noscript><\/figure>\n<h3><span class=\"ez-toc-section\" id=\"Funcion-Power-BI-DAX-COMBINEVALUES\"><\/span>Funci\u00f3n Power BI DAX COMBINEVALUES<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p>La funci\u00f3n DAX COMBINEVALUES combina dos o m\u00e1s cadenas con el delimitador especificado. La sintaxis de esta funci\u00f3n de Power BI DAX COMBINEVALUES es:<\/p>\n<pre class=\"wp-block-preformatted lang:tsql decode:true\">COMBINEVALUES(Delimiter, string1, string2,..)<\/pre>\n<p>La siguiente declaraci\u00f3n combina las columnas Nombre, Apellido, Educaci\u00f3n mediante un delimitador de coma.<\/p>\n<pre class=\"wp-block-preformatted lang:tsql decode:true\">CONCATENATEX = CONCATENATEX(EmployeeSales, EmployeeSales[LastName], \",\")<\/pre>\n<figure class=\"wp-block-image\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-33377\" src=\"https:\/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Power-BI-DAX-String-Functions-19-9209162.png\" srcset=\"\/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Power-BI-DAX-String-Functions-19-9209162.png 1090w, \/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Power-BI-DAX-String-Functions-19-9209162-300x184.png 300w, \/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Power-BI-DAX-String-Functions-19-9209162-1024x628.png 1024w, \/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Power-BI-DAX-String-Functions-19-9209162-768x471.png 768w\" alt=\"power-bi-dax-string-functions-19-9209162\" width=\"1090\" height=\"668\" data-lazy-sizes=\"(max-width: 1090px) 100vw, 1090px\" \/><noscript><img alt='power-bi-dax-string-functions-19-9209162' width='1090' height='668' src='https:\/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Power-BI-DAX-String-Functions-19-9209162.png' alt=\"Funci\u00f3n Power BI DAX COMBINEVALUES 19\" class=\"wp-image-33377\" srcset='\/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Power-BI-DAX-String-Functions-19-9209162.png 1090w, \/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Power-BI-DAX-String-Functions-19-9209162-300x184.png 300w, \/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Power-BI-DAX-String-Functions-19-9209162-1024x628.png 1024w, \/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Power-BI-DAX-String-Functions-19-9209162-768x471.png 768w' sizes='(max-width: 1090px) 100vw, 1090px'\/><\/noscript><\/figure>\n<h3><span class=\"ez-toc-section\" id=\"Funcion-Power-BI-DAX-FORMAT\"><\/span>Funci\u00f3n Power BI DAX FORMAT<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p>La funci\u00f3n Power BI DAX FORMAT da formato a n\u00fameros y fechas a formatos predefinidos. La sintaxis de la funci\u00f3n FORMAT de Power BI DAX es:<\/p>\n<pre class=\"wp-block-preformatted lang:tsql decode:true\">FORMAT(expression, format_type)<\/pre>\n<p>La siguiente funci\u00f3n de FORMATO de Power BI DAX formatea el monto de ventas en tipo de moneda<\/p>\n<pre class=\"wp-block-preformatted lang:tsql decode:true\">FORMAT = FORMAT(EmployeeSales[Sales], \"Currency\")<\/pre>\n<figure class=\"wp-block-image\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-33378\" src=\"https:\/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Power-BI-DAX-String-Functions-20-1149231.png\" srcset=\"\/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Power-BI-DAX-String-Functions-20-1149231.png 1084w, \/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Power-BI-DAX-String-Functions-20-1149231-300x176.png 300w, \/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Power-BI-DAX-String-Functions-20-1149231-1024x602.png 1024w, \/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Power-BI-DAX-String-Functions-20-1149231-768x451.png 768w\" alt=\"power-bi-dax-string-functions-20-1149231\" width=\"1084\" height=\"637\" data-lazy-sizes=\"(max-width: 1084px) 100vw, 1084px\" \/><noscript><img alt='power-bi-dax-string-functions-20-1149231' width='1084' height='637' src='https:\/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Power-BI-DAX-String-Functions-20-1149231.png' alt=\"Funci\u00f3n de FORMATO de Power BI DAX 20\" class=\"wp-image-33378\" srcset='\/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Power-BI-DAX-String-Functions-20-1149231.png 1084w, \/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Power-BI-DAX-String-Functions-20-1149231-300x176.png 300w, \/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Power-BI-DAX-String-Functions-20-1149231-1024x602.png 1024w, \/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Power-BI-DAX-String-Functions-20-1149231-768x451.png 768w' sizes='(max-width: 1084px) 100vw, 1084px'\/><\/noscript><\/figure>\n<h3><span class=\"ez-toc-section\" id=\"Funcion-Power-BI-DAX-VALUE\"><\/span>Funci\u00f3n Power BI DAX VALUE<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p>La funci\u00f3n DAX VALUE convierte los n\u00fameros de cadena en un n\u00famero. La sintaxis de la funci\u00f3n DAX VALUE de Power BI es:<\/p>\n<pre class=\"wp-block-preformatted lang:tsql decode:true\">VALUE(string)<\/pre>\n<p>La siguiente declaraci\u00f3n convierte los n\u00fameros de cadena en el resultado de la funci\u00f3n fija en un n\u00famero<\/p>\n<pre class=\"wp-block-preformatted lang:tsql decode:true\">VALUE = VALUE(EmployeeSales[FIXED])<\/pre>\n<figure class=\"wp-block-image\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-33379\" src=\"https:\/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Power-BI-DAX-String-Functions-21-7347841.png\" srcset=\"\/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Power-BI-DAX-String-Functions-21-7347841.png 1049w, \/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Power-BI-DAX-String-Functions-21-7347841-300x204.png 300w, \/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Power-BI-DAX-String-Functions-21-7347841-1024x697.png 1024w, \/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Power-BI-DAX-String-Functions-21-7347841-768x523.png 768w\" alt=\"power-bi-dax-string-functions-21-7347841\" width=\"1049\" height=\"714\" data-lazy-sizes=\"(max-width: 1049px) 100vw, 1049px\" \/><noscript><img alt='power-bi-dax-string-functions-21-4865399' width='1049' height='714' src='https:\/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Power-BI-DAX-String-Functions-21-4865399.png' alt=\"Funci\u00f3n de valor de DAX de Power BI 21\" class=\"wp-image-33379\" srcset='\/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Power-BI-DAX-String-Functions-21-4865399.png 1049w, \/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Power-BI-DAX-String-Functions-21-4865399-300x204.png 300w, \/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Power-BI-DAX-String-Functions-21-4865399-1024x697.png 1024w, \/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Power-BI-DAX-String-Functions-21-4865399-768x523.png 768w' sizes='(max-width: 1049px) 100vw, 1049px'\/><\/noscript><\/figure>\n<\/div>\n","protected":false},"excerpt":{"rendered":"<p>Let me show you how to use Power BI DAX string functions with examples. Microsoft Power BI DAX provides various string functions like LEN, LEFT, RIGHT, LOWER, UPPER, MID,\u2026<\/p>","protected":false},"author":1,"featured_media":83999,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[1359,1360],"tags":[],"class_list":["post-84003","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 cadena de Power BI DAX - R Marketing Digital<\/title>\n<meta name=\"description\" content=\"Perm\u00edtame mostrarle c\u00f3mo usar las funciones de cadena de Power BI DAX con ejemplos. Microsoft Power BI DAX proporciona varias funciones de cadena como\" \/>\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\/en\/powerbi\/funciones-de-cadena-de-power-bi-dax-2\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Funciones de cadena de Power BI DAX\" \/>\n<meta property=\"og:description\" content=\"Perm\u00edtame mostrarle c\u00f3mo usar las funciones de cadena de Power BI DAX con ejemplos. Microsoft Power BI DAX proporciona varias funciones de cadena como\" \/>\n<meta property=\"og:url\" content=\"https:\/\/rmarketingdigital.com\/en\/powerbi\/funciones-de-cadena-de-power-bi-dax-2\/\" \/>\n<meta property=\"og:site_name\" content=\"R Marketing Digital\" \/>\n<meta property=\"article:published_time\" content=\"2022-07-06T02:41:46+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Power-BI-DAX-String-Functions-10-7633127.png\" \/>\n\t<meta property=\"og:image:width\" content=\"1093\" \/>\n\t<meta property=\"og:image:height\" content=\"665\" \/>\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\\\/powerbi\\\/funciones-de-cadena-de-power-bi-dax-2\\\/#article\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/rmarketingdigital.com\\\/powerbi\\\/funciones-de-cadena-de-power-bi-dax-2\\\/\"},\"author\":{\"name\":\"R Marketing Digital\",\"@id\":\"https:\\\/\\\/rmarketingdigital.com\\\/#\\\/schema\\\/person\\\/7c0d9782b2977b840b3740f00c69a73e\"},\"headline\":\"Funciones de cadena de Power BI DAX\",\"datePublished\":\"2022-07-06T02:41:46+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\\\/\\\/rmarketingdigital.com\\\/powerbi\\\/funciones-de-cadena-de-power-bi-dax-2\\\/\"},\"wordCount\":1234,\"image\":{\"@id\":\"https:\\\/\\\/rmarketingdigital.com\\\/powerbi\\\/funciones-de-cadena-de-power-bi-dax-2\\\/#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/rmarketingdigital.com\\\/wp-content\\\/uploads\\\/2020\\\/09\\\/Power-BI-DAX-String-Functions-10-7633127.png\",\"articleSection\":[\"Power BI\",\"Tutoriales PowerBI\"],\"inLanguage\":\"en-US\"},{\"@type\":\"WebPage\",\"@id\":\"https:\\\/\\\/rmarketingdigital.com\\\/powerbi\\\/funciones-de-cadena-de-power-bi-dax-2\\\/\",\"url\":\"https:\\\/\\\/rmarketingdigital.com\\\/powerbi\\\/funciones-de-cadena-de-power-bi-dax-2\\\/\",\"name\":\"Funciones de cadena de Power BI DAX - R Marketing Digital\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/rmarketingdigital.com\\\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\\\/\\\/rmarketingdigital.com\\\/powerbi\\\/funciones-de-cadena-de-power-bi-dax-2\\\/#primaryimage\"},\"image\":{\"@id\":\"https:\\\/\\\/rmarketingdigital.com\\\/powerbi\\\/funciones-de-cadena-de-power-bi-dax-2\\\/#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/rmarketingdigital.com\\\/wp-content\\\/uploads\\\/2020\\\/09\\\/Power-BI-DAX-String-Functions-10-7633127.png\",\"datePublished\":\"2022-07-06T02:41:46+00:00\",\"author\":{\"@id\":\"https:\\\/\\\/rmarketingdigital.com\\\/#\\\/schema\\\/person\\\/7c0d9782b2977b840b3740f00c69a73e\"},\"description\":\"Perm\u00edtame mostrarle c\u00f3mo usar las funciones de cadena de Power BI DAX con ejemplos. Microsoft Power BI DAX proporciona varias funciones de cadena como\",\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\\\/\\\/rmarketingdigital.com\\\/powerbi\\\/funciones-de-cadena-de-power-bi-dax-2\\\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\\\/\\\/rmarketingdigital.com\\\/powerbi\\\/funciones-de-cadena-de-power-bi-dax-2\\\/#primaryimage\",\"url\":\"https:\\\/\\\/rmarketingdigital.com\\\/wp-content\\\/uploads\\\/2020\\\/09\\\/Power-BI-DAX-String-Functions-10-7633127.png\",\"contentUrl\":\"https:\\\/\\\/rmarketingdigital.com\\\/wp-content\\\/uploads\\\/2020\\\/09\\\/Power-BI-DAX-String-Functions-10-7633127.png\",\"width\":1093,\"height\":665,\"caption\":\"power-bi-dax-string-functions-10-7633127-1062395-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\":\"en-US\"},{\"@type\":\"Person\",\"@id\":\"https:\\\/\\\/rmarketingdigital.com\\\/#\\\/schema\\\/person\\\/7c0d9782b2977b840b3740f00c69a73e\",\"name\":\"R Marketing Digital\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@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 String Functions - R Marketing Digital","description":"Let me show you how to use Power BI DAX string functions with examples. Microsoft Power BI DAX provides various string functions like","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\/en\/powerbi\/funciones-de-cadena-de-power-bi-dax-2\/","og_locale":"en_US","og_type":"article","og_title":"Funciones de cadena de Power BI DAX","og_description":"Perm\u00edtame mostrarle c\u00f3mo usar las funciones de cadena de Power BI DAX con ejemplos. Microsoft Power BI DAX proporciona varias funciones de cadena como","og_url":"https:\/\/rmarketingdigital.com\/en\/powerbi\/funciones-de-cadena-de-power-bi-dax-2\/","og_site_name":"R Marketing Digital","article_published_time":"2022-07-06T02:41:46+00:00","og_image":[{"width":1093,"height":665,"url":"https:\/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Power-BI-DAX-String-Functions-10-7633127.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\/powerbi\/funciones-de-cadena-de-power-bi-dax-2\/#article","isPartOf":{"@id":"https:\/\/rmarketingdigital.com\/powerbi\/funciones-de-cadena-de-power-bi-dax-2\/"},"author":{"name":"R Marketing Digital","@id":"https:\/\/rmarketingdigital.com\/#\/schema\/person\/7c0d9782b2977b840b3740f00c69a73e"},"headline":"Funciones de cadena de Power BI DAX","datePublished":"2022-07-06T02:41:46+00:00","mainEntityOfPage":{"@id":"https:\/\/rmarketingdigital.com\/powerbi\/funciones-de-cadena-de-power-bi-dax-2\/"},"wordCount":1234,"image":{"@id":"https:\/\/rmarketingdigital.com\/powerbi\/funciones-de-cadena-de-power-bi-dax-2\/#primaryimage"},"thumbnailUrl":"https:\/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Power-BI-DAX-String-Functions-10-7633127.png","articleSection":["Power BI","Tutoriales PowerBI"],"inLanguage":"en-US"},{"@type":"WebPage","@id":"https:\/\/rmarketingdigital.com\/powerbi\/funciones-de-cadena-de-power-bi-dax-2\/","url":"https:\/\/rmarketingdigital.com\/powerbi\/funciones-de-cadena-de-power-bi-dax-2\/","name":"Power BI DAX String Functions - R Marketing Digital","isPartOf":{"@id":"https:\/\/rmarketingdigital.com\/#website"},"primaryImageOfPage":{"@id":"https:\/\/rmarketingdigital.com\/powerbi\/funciones-de-cadena-de-power-bi-dax-2\/#primaryimage"},"image":{"@id":"https:\/\/rmarketingdigital.com\/powerbi\/funciones-de-cadena-de-power-bi-dax-2\/#primaryimage"},"thumbnailUrl":"https:\/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Power-BI-DAX-String-Functions-10-7633127.png","datePublished":"2022-07-06T02:41:46+00:00","author":{"@id":"https:\/\/rmarketingdigital.com\/#\/schema\/person\/7c0d9782b2977b840b3740f00c69a73e"},"description":"Let me show you how to use Power BI DAX string functions with examples. Microsoft Power BI DAX provides various string functions like","inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/rmarketingdigital.com\/powerbi\/funciones-de-cadena-de-power-bi-dax-2\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/rmarketingdigital.com\/powerbi\/funciones-de-cadena-de-power-bi-dax-2\/#primaryimage","url":"https:\/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Power-BI-DAX-String-Functions-10-7633127.png","contentUrl":"https:\/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Power-BI-DAX-String-Functions-10-7633127.png","width":1093,"height":665,"caption":"power-bi-dax-string-functions-10-7633127-1062395-png"},{"@type":"WebSite","@id":"https:\/\/rmarketingdigital.com\/#website","url":"https:\/\/rmarketingdigital.com\/","name":"R Digital Marketing","description":"SEO Agency | Advertising social networks | 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":"en-US"},{"@type":"Person","@id":"https:\/\/rmarketingdigital.com\/#\/schema\/person\/7c0d9782b2977b840b3740f00c69a73e","name":"R Digital Marketing","image":{"@type":"ImageObject","inLanguage":"en-US","@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\/en\/wp-json\/wp\/v2\/posts\/84003","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/rmarketingdigital.com\/en\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/rmarketingdigital.com\/en\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/rmarketingdigital.com\/en\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/rmarketingdigital.com\/en\/wp-json\/wp\/v2\/comments?post=84003"}],"version-history":[{"count":0,"href":"https:\/\/rmarketingdigital.com\/en\/wp-json\/wp\/v2\/posts\/84003\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/rmarketingdigital.com\/en\/wp-json\/wp\/v2\/media\/83999"}],"wp:attachment":[{"href":"https:\/\/rmarketingdigital.com\/en\/wp-json\/wp\/v2\/media?parent=84003"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/rmarketingdigital.com\/en\/wp-json\/wp\/v2\/categories?post=84003"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/rmarketingdigital.com\/en\/wp-json\/wp\/v2\/tags?post=84003"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}