{"id":84876,"date":"2022-07-30T14:24:43","date_gmt":"2022-07-30T12:24:43","guid":{"rendered":"https:\/\/rmarketingdigital.com\/powerbi\/como-dividir-columnas-en-power-bi\/"},"modified":"2021-07-20T18:53:29","modified_gmt":"2021-07-20T16:53:29","slug":"como-dividir-columnas-en-power-bi","status":"publish","type":"post","link":"https:\/\/rmarketingdigital.com\/en\/powerbi\/como-dividir-columnas-en-power-bi\/","title":{"rendered":"How to split columns in Power BI"},"content":{"rendered":"<div>\n<p>En tiempo real, es posible que obtenga los datos que tienen columnas fusionadas (una columna con demasiada informaci\u00f3n). En esa situaci\u00f3n, puede usar la opci\u00f3n Dividir columnas de Power BI para dividir esa columna en varias columnas. Este art\u00edculo le muestra c\u00f3mo dividir columnas en Power BI con un ejemplo.<\/p>\n<p>&nbsp;<\/p>\n<h2>How to split columns in Power BI<\/h2>\n<p>Para demostrar esta opci\u00f3n de <a href=\"https:\/\/rmarketingdigital.com\/en\/powerbi\/como-dividir-columnas-en-power-bi\/\">columnas divididas de PowerBI<\/a>, usaremos la tabla Text Employee que importamos en el art\u00edculo Enter Data.<\/p>\n<p>To split columns in an existing table, click the <b>Edit queries<\/b> option under the <b>Home<\/b> tongue.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-30788\" src=\"https:\/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/How-to-Split-Columns-in-Power-BI-1-4429281.png\" srcset=\"\/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/How-to-Split-Columns-in-Power-BI-1-4429281.png 1084w, \/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/How-to-Split-Columns-in-Power-BI-1-4429281-300x165.png 300w, \/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/How-to-Split-Columns-in-Power-BI-1-4429281-1024x564.png 1024w, \/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/How-to-Split-Columns-in-Power-BI-1-4429281-768x423.png 768w\" alt=\"how-to-split-columns-in-power-bi-1-4429281\" width=\"1084\" height=\"597\" data-lazy-sizes=\"(max-width: 1084px) 100vw, 1084px\" \/><noscript><img alt='how-to-split-columns-in-power-bi-1-4429281' width='1084' height='597' src='https:\/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/How-to-Split-Columns-in-Power-BI-1-4429281.png' class=\"wp-image-30788\" srcset='\/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/How-to-Split-Columns-in-Power-BI-1-4429281.png 1084w, \/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/How-to-Split-Columns-in-Power-BI-1-4429281-300x165.png 300w, \/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/How-to-Split-Columns-in-Power-BI-1-4429281-1024x564.png 1024w, \/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/How-to-Split-Columns-in-Power-BI-1-4429281-768x423.png 768w' sizes='(max-width: 1084px) 100vw, 1084px'\/><\/noscript><\/p>\n<p>Clicking <b>Edit queries<\/b> The option opens a new window called <b>Power Query Editor<\/b>. En la captura de pantalla siguiente, puede ver que la tabla de Power BI tiene solo una columna.<\/p>\n<figure class=\"wp-block-image\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-30789\" src=\"https:\/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/How-to-Split-Columns-in-Power-BI-2-8293125.png\" srcset=\"\/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/How-to-Split-Columns-in-Power-BI-2-8293125.png 980w, \/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/How-to-Split-Columns-in-Power-BI-2-8293125-300x203.png 300w, \/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/How-to-Split-Columns-in-Power-BI-2-8293125-768x520.png 768w\" alt=\"how-to-split-columns-in-power-bi-2-8293125\" width=\"980\" height=\"664\" data-lazy-sizes=\"(max-width: 980px) 100vw, 980px\" \/><noscript><img alt='how-to-split-columns-in-power-bi-2-8293125' width='980' height='664' src='https:\/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/How-to-Split-Columns-in-Power-BI-2-8293125.png' class=\"wp-image-30789\" srcset='\/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/How-to-Split-Columns-in-Power-BI-2-8293125.png 980w, \/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/How-to-Split-Columns-in-Power-BI-2-8293125-300x203.png 300w, \/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/How-to-Split-Columns-in-Power-BI-2-8293125-768x520.png 768w' sizes='(max-width: 980px) 100vw, 980px'\/><\/noscript><\/figure>\n<p>Antes de comenzar a dividir las columnas en Power BI, perm\u00edtanme duplicar esta columna. Para hacerlo, haga clic derecho en el nombre de la columna y seleccione <strong>Duplicate column<\/strong> context menu option.<\/p>\n<p>&nbsp;<\/p>\n<figure class=\"wp-block-image\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-30790\" src=\"https:\/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/How-to-Split-Columns-in-Power-BI-3-5556644.png\" srcset=\"\/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/How-to-Split-Columns-in-Power-BI-3-5556644.png 981w, \/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/How-to-Split-Columns-in-Power-BI-3-5556644-300x203.png 300w, \/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/How-to-Split-Columns-in-Power-BI-3-5556644-768x520.png 768w\" alt=\"how-to-split-columns-in-power-bi-3-5556644\" width=\"981\" height=\"664\" data-lazy-sizes=\"(max-width: 981px) 100vw, 981px\" \/><noscript><img alt='how-to-split-columns-in-power-bi-3-5556644' width='981' height='664' src='https:\/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/How-to-Split-Columns-in-Power-BI-3-5556644.png' class=\"wp-image-30790\" srcset='\/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/How-to-Split-Columns-in-Power-BI-3-5556644.png 981w, \/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/How-to-Split-Columns-in-Power-BI-3-5556644-300x203.png 300w, \/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/How-to-Split-Columns-in-Power-BI-3-5556644-768x520.png 768w' sizes='(max-width: 981px) 100vw, 981px'\/><\/noscript><\/figure>\n<p>Now you can see the Duplicate column<\/p>\n<figure class=\"wp-block-image\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-30791\" src=\"https:\/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/How-to-Split-Columns-in-Power-BI-4-9331982.png\" srcset=\"\/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/How-to-Split-Columns-in-Power-BI-4-9331982.png 999w, \/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/How-to-Split-Columns-in-Power-BI-4-9331982-300x199.png 300w, \/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/How-to-Split-Columns-in-Power-BI-4-9331982-768x510.png 768w\" alt=\"how-to-split-columns-in-power-bi-4-9331982\" width=\"999\" height=\"664\" data-lazy-sizes=\"(max-width: 999px) 100vw, 999px\" \/><noscript><img alt='how-to-split-columns-in-power-bi-4-9331982' width='999' height='664' src='https:\/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/How-to-Split-Columns-in-Power-BI-4-9331982.png' class=\"wp-image-30791\" srcset='\/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/How-to-Split-Columns-in-Power-BI-4-9331982.png 999w, \/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/How-to-Split-Columns-in-Power-BI-4-9331982-300x199.png 300w, \/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/How-to-Split-Columns-in-Power-BI-4-9331982-768x510.png 768w' sizes='(max-width: 999px) 100vw, 999px'\/><\/noscript><\/figure>\n<p>Para dividir las columnas en una tabla de Power BI, haga clic con el bot\u00f3n derecho en la columna que desea dividir para abrir el men\u00fa contextual. Por favor seleccione el <b>Split columns<\/b> and then select By <b>Delimiter<\/b> option.<\/p>\n<figure class=\"wp-block-image\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-30792\" src=\"https:\/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/How-to-Split-Columns-in-Power-BI-5-1983423.png\" srcset=\"\/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/How-to-Split-Columns-in-Power-BI-5-1983423.png 978w, \/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/How-to-Split-Columns-in-Power-BI-5-1983423-300x211.png 300w, \/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/How-to-Split-Columns-in-Power-BI-5-1983423-768x541.png 768w\" alt=\"how-to-split-columns-in-power-bi-5-1983423\" width=\"978\" height=\"689\" data-lazy-sizes=\"(max-width: 978px) 100vw, 978px\" \/><noscript><img alt='how-to-split-columns-in-power-bi-5-1983423' width='978' height='689' src='https:\/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/How-to-Split-Columns-in-Power-BI-5-1983423.png' class=\"wp-image-30792\" srcset='\/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/How-to-Split-Columns-in-Power-BI-5-1983423.png 978w, \/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/How-to-Split-Columns-in-Power-BI-5-1983423-300x211.png 300w, \/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/How-to-Split-Columns-in-Power-BI-5-1983423-768x541.png 768w' sizes='(max-width: 978px) 100vw, 978px'\/><\/noscript><\/figure>\n<p>Select the <b>By delimiter<\/b> The option opens the following window.<\/p>\n<ul>\n<li><b>Select or enter delimiter:<\/b> En la lista desplegable, seleccione el delimitador que desea utilizar como car\u00e1cter dividido. Si no est\u00e1 en la lista, seleccione la opci\u00f3n Personalizado y especifique ese car\u00e1cter personalizado.<\/li>\n<li><b>Leftmost delimiter:<\/b> This option splits the leftmost string before the first delimiter.<\/li>\n<li><b>Rightmost delimiter:<\/b> This option splits the rightmost string after the last delimiter.<\/li>\n<li><b>Each occurrence of the delimiter: <\/b>The text is split at each occurrence of a delimiter.<\/li>\n<\/ul>\n<figure class=\"wp-block-image\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-30793\" src=\"https:\/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/How-to-Split-Columns-in-Power-BI-6-4248304.png\" srcset=\"\/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/How-to-Split-Columns-in-Power-BI-6-4248304.png 699w, \/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/How-to-Split-Columns-in-Power-BI-6-4248304-300x144.png 300w\" alt=\"how-to-split-columns-in-power-bi-6-4248304\" width=\"699\" height=\"335\" data-lazy-sizes=\"(max-width: 699px) 100vw, 699px\" \/><noscript><img alt='how-to-split-columns-in-power-bi-6-4248304' width='699' height='335' src='https:\/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/How-to-Split-Columns-in-Power-BI-6-4248304.png' class=\"wp-image-30793\" srcset='\/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/How-to-Split-Columns-in-Power-BI-6-4248304.png 699w, \/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/How-to-Split-Columns-in-Power-BI-6-4248304-300x144.png 300w' sizes='(max-width: 699px) 100vw, 699px'\/><\/noscript><\/figure>\n<p>Estamos seleccionando Coma como delimitador. Recuerde, en la secci\u00f3n Avanzado, puede especificar el n\u00famero de columnas o filas.<\/p>\n<figure class=\"wp-block-image\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-30794\" src=\"https:\/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/How-to-Split-Columns-in-Power-BI-7-1881092.png\" srcset=\"\/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/How-to-Split-Columns-in-Power-BI-7-1881092.png 699w, \/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/How-to-Split-Columns-in-Power-BI-7-1881092-300x238.png 300w\" alt=\"how-to-split-columns-in-power-bi-7-1881092\" width=\"699\" height=\"555\" data-lazy-sizes=\"(max-width: 699px) 100vw, 699px\" \/><noscript><img alt='how-to-split-columns-in-power-bi-7-1881092' width='699' height='555' src='https:\/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/How-to-Split-Columns-in-Power-BI-7-1881092.png' class=\"wp-image-30794\" srcset='\/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/How-to-Split-Columns-in-Power-BI-7-1881092.png 699w, \/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/How-to-Split-Columns-in-Power-BI-7-1881092-300x238.png 300w' sizes='(max-width: 699px) 100vw, 699px'\/><\/noscript><\/figure>\n<p>Let me select the leftmost delimiter option and click OK<\/p>\n<figure class=\"wp-block-image\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-30795\" src=\"https:\/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/How-to-Split-Columns-in-Power-BI-8-1752031.png\" srcset=\"\/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/How-to-Split-Columns-in-Power-BI-8-1752031.png 699w, \/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/How-to-Split-Columns-in-Power-BI-8-1752031-300x144.png 300w\" alt=\"how-to-split-columns-in-power-bi-8-1752031\" width=\"699\" height=\"335\" data-lazy-sizes=\"(max-width: 699px) 100vw, 699px\" \/><noscript><img alt='how-to-split-columns-in-power-bi-8-1752031' width='699' height='335' src='https:\/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/How-to-Split-Columns-in-Power-BI-8-1752031.png' class=\"wp-image-30795\" srcset='\/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/How-to-Split-Columns-in-Power-BI-8-1752031.png 699w, \/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/How-to-Split-Columns-in-Power-BI-8-1752031-300x144.png 300w' sizes='(max-width: 699px) 100vw, 699px'\/><\/noscript><\/figure>\n<p>Now you can see that the employee IDs are separated from the original column and placed in the new column.<\/p>\n<figure class=\"wp-block-image\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-30796\" src=\"https:\/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/How-to-Split-Columns-in-Power-BI-9-5371514.png\" srcset=\"\/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/How-to-Split-Columns-in-Power-BI-9-5371514.png 969w, \/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/How-to-Split-Columns-in-Power-BI-9-5371514-300x205.png 300w, \/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/How-to-Split-Columns-in-Power-BI-9-5371514-768x525.png 768w\" alt=\"how-to-split-columns-in-power-bi-9-5371514\" width=\"969\" height=\"663\" data-lazy-sizes=\"(max-width: 969px) 100vw, 969px\" \/><noscript><img alt='how-to-split-columns-in-power-bi-9-5371514' width='969' height='663' src='https:\/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/How-to-Split-Columns-in-Power-BI-9-5371514.png' class=\"wp-image-30796\" srcset='\/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/How-to-Split-Columns-in-Power-BI-9-5371514.png 969w, \/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/How-to-Split-Columns-in-Power-BI-9-5371514-300x205.png 300w, \/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/How-to-Split-Columns-in-Power-BI-9-5371514-768x525.png 768w' sizes='(max-width: 969px) 100vw, 969px'\/><\/noscript><\/figure>\n<p>This time we select the Divide option at each occurrence of the delimiter option.<\/p>\n<figure class=\"wp-block-image\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-30797\" src=\"https:\/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/How-to-Split-Columns-in-Power-BI-10-2869092.png\" srcset=\"\/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/How-to-Split-Columns-in-Power-BI-10-2869092.png 969w, \/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/How-to-Split-Columns-in-Power-BI-10-2869092-300x206.png 300w, \/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/How-to-Split-Columns-in-Power-BI-10-2869092-768x526.png 768w\" alt=\"how-to-split-columns-in-power-bi-10-2869092\" width=\"969\" height=\"664\" data-lazy-sizes=\"(max-width: 969px) 100vw, 969px\" \/><noscript><img alt='how-to-split-columns-in-power-bi-10-2869092' width='969' height='664' src='https:\/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/How-to-Split-Columns-in-Power-BI-10-2869092.png' class=\"wp-image-30797\" srcset='\/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/How-to-Split-Columns-in-Power-BI-10-2869092.png 969w, \/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/How-to-Split-Columns-in-Power-BI-10-2869092-300x206.png 300w, \/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/How-to-Split-Columns-in-Power-BI-10-2869092-768x526.png 768w' sizes='(max-width: 969px) 100vw, 969px'\/><\/noscript><\/figure>\n<p>Now you can see that the text at each occurrence of the comma is separated from the original column and placed in a new column.<\/p>\n<figure class=\"wp-block-image\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-30798\" src=\"https:\/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/How-to-Split-Columns-in-Power-BI-11-8850787.png\" srcset=\"\/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/How-to-Split-Columns-in-Power-BI-11-8850787.png 1133w, \/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/How-to-Split-Columns-in-Power-BI-11-8850787-300x176.png 300w, \/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/How-to-Split-Columns-in-Power-BI-11-8850787-1024x600.png 1024w, \/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/How-to-Split-Columns-in-Power-BI-11-8850787-768x450.png 768w\" alt=\"how-to-split-columns-in-power-bi-11-8850787\" width=\"1133\" height=\"664\" data-lazy-sizes=\"(max-width: 1133px) 100vw, 1133px\" \/><noscript><img alt='how-to-split-columns-in-power-bi-11-8850787' width='1133' height='664' src='https:\/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/How-to-Split-Columns-in-Power-BI-11-8850787.png' class=\"wp-image-30798\" srcset='\/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/How-to-Split-Columns-in-Power-BI-11-8850787.png 1133w, \/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/How-to-Split-Columns-in-Power-BI-11-8850787-300x176.png 300w, \/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/How-to-Split-Columns-in-Power-BI-11-8850787-1024x600.png 1024w, \/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/How-to-Split-Columns-in-Power-BI-11-8850787-768x450.png 768w' sizes='(max-width: 1133px) 100vw, 1133px'\/><\/noscript><\/figure>\n<p>D\u00e9jame probar con otro delimitador. Para la demostraci\u00f3n de Power BI Split Columns, seleccionamos la siguiente columna y dividimos esa columna usando el delimitador de espacio.<\/p>\n<figure class=\"wp-block-image\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-30799\" src=\"https:\/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/How-to-Split-Columns-in-Power-BI-12-9254293.png\" srcset=\"\/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/How-to-Split-Columns-in-Power-BI-12-9254293.png 1131w, \/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/How-to-Split-Columns-in-Power-BI-12-9254293-300x176.png 300w, \/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/How-to-Split-Columns-in-Power-BI-12-9254293-1024x601.png 1024w, \/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/How-to-Split-Columns-in-Power-BI-12-9254293-768x451.png 768w\" alt=\"how-to-split-columns-in-power-bi-12-9254293\" width=\"1131\" height=\"664\" data-lazy-sizes=\"(max-width: 1131px) 100vw, 1131px\" \/><noscript><img alt='how-to-split-columns-in-power-bi-12-9254293' width='1131' height='664' src='https:\/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/How-to-Split-Columns-in-Power-BI-12-9254293.png' class=\"wp-image-30799\" srcset='\/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/How-to-Split-Columns-in-Power-BI-12-9254293.png 1131w, \/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/How-to-Split-Columns-in-Power-BI-12-9254293-300x176.png 300w, \/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/How-to-Split-Columns-in-Power-BI-12-9254293-1024x601.png 1024w, \/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/How-to-Split-Columns-in-Power-BI-12-9254293-768x451.png 768w' sizes='(max-width: 1131px) 100vw, 1131px'\/><\/noscript><\/figure>\n<p>Now you can see the different columns that stored the split text at each occurrence of space.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-30800\" src=\"https:\/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/How-to-Split-Columns-in-Power-BI-13-3163758.png\" srcset=\"\/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/How-to-Split-Columns-in-Power-BI-13-3163758.png 1132w, \/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/How-to-Split-Columns-in-Power-BI-13-3163758-300x176.png 300w, \/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/How-to-Split-Columns-in-Power-BI-13-3163758-1024x601.png 1024w, \/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/How-to-Split-Columns-in-Power-BI-13-3163758-768x450.png 768w\" alt=\"how-to-split-columns-in-power-bi-13-3163758\" width=\"1132\" height=\"664\" data-lazy-sizes=\"(max-width: 1132px) 100vw, 1132px\" \/><noscript><img alt='how-to-split-columns-in-power-bi-13-3163758' width='1132' height='664' src='https:\/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/How-to-Split-Columns-in-Power-BI-13-3163758.png' class=\"wp-image-30800\" srcset='\/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/How-to-Split-Columns-in-Power-BI-13-3163758.png 1132w, \/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/How-to-Split-Columns-in-Power-BI-13-3163758-300x176.png 300w, \/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/How-to-Split-Columns-in-Power-BI-13-3163758-1024x601.png 1024w, \/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/How-to-Split-Columns-in-Power-BI-13-3163758-768x450.png 768w' sizes='(max-width: 1132px) 100vw, 1132px'\/><\/noscript><\/p>\n<h3>Power BI split columns by number of characters<\/h3>\n<p>Haga clic con el bot\u00f3n derecho en la columna que desea dividir para abrir el men\u00fa contextual. Por favor seleccione el <b>Split columns<\/b> and then select the <b>By number of characters<\/b> option.<\/p>\n<figure class=\"wp-block-image\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-30801\" src=\"https:\/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/How-to-Split-Columns-in-Power-BI-14-6472044.png\" srcset=\"\/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/How-to-Split-Columns-in-Power-BI-14-6472044.png 1232w, \/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/How-to-Split-Columns-in-Power-BI-14-6472044-300x167.png 300w, \/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/How-to-Split-Columns-in-Power-BI-14-6472044-1024x570.png 1024w, \/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/How-to-Split-Columns-in-Power-BI-14-6472044-768x428.png 768w\" alt=\"how-to-split-columns-in-power-bi-14-6472044\" width=\"1232\" height=\"686\" data-lazy-sizes=\"(max-width: 1232px) 100vw, 1232px\" \/><noscript><img alt='how-to-split-columns-in-power-bi-14-3813065' width='1232' height='686' src='https:\/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/How-to-Split-Columns-in-Power-BI-14-3813065.png' class=\"wp-image-30801\" srcset='\/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/How-to-Split-Columns-in-Power-BI-14-3813065.png 1232w, \/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/How-to-Split-Columns-in-Power-BI-14-3813065-300x167.png 300w, \/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/How-to-Split-Columns-in-Power-BI-14-3813065-1024x570.png 1024w, \/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/How-to-Split-Columns-in-Power-BI-14-3813065-768x428.png 768w' sizes='(max-width: 1232px) 100vw, 1232px'\/><\/noscript><\/figure>\n<p>Select the <b>By number of characters<\/b> opens the Split column by number of characters window.<\/p>\n<ul>\n<li><b>Number of characters:<\/b> Specify the number of characters used to divide the column.<\/li>\n<li><b>Once, as far to the left as possible:<\/b> This option splits the leftmost string before the number of characters.<\/li>\n<li><b>Once, as far to the right as possible:<\/b> This option splits the rightmost string after the number of characters.<\/li>\n<li><b>Repeatedly:<\/b> The text is divided by every 5 characters.<\/li>\n<\/ul>\n<figure class=\"wp-block-image\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-30802\" src=\"https:\/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/How-to-Split-Columns-in-Power-BI-15-5469775.png\" srcset=\"\/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/How-to-Split-Columns-in-Power-BI-15-5469775.png 700w, \/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/How-to-Split-Columns-in-Power-BI-15-5469775-300x147.png 300w\" alt=\"how-to-split-columns-in-power-bi-15-5469775\" width=\"700\" height=\"342\" data-lazy-sizes=\"(max-width: 700px) 100vw, 700px\" \/><noscript><img alt='how-to-split-columns-in-power-bi-15-5469775' width='700' height='342' src='https:\/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/How-to-Split-Columns-in-Power-BI-15-5469775.png' class=\"wp-image-30802\" srcset='\/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/How-to-Split-Columns-in-Power-BI-15-5469775.png 700w, \/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/How-to-Split-Columns-in-Power-BI-15-5469775-300x147.png 300w' sizes='(max-width: 700px) 100vw, 700px'\/><\/noscript><\/figure>\n<p>You can now see the split columns in the Power BI query editor<\/p>\n<figure class=\"wp-block-image\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-30803\" src=\"https:\/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/How-to-Split-Columns-in-Power-BI-16-7474796.png\" srcset=\"\/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/How-to-Split-Columns-in-Power-BI-16-7474796.png 1232w, \/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/How-to-Split-Columns-in-Power-BI-16-7474796-300x168.png 300w, \/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/How-to-Split-Columns-in-Power-BI-16-7474796-1024x574.png 1024w, \/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/How-to-Split-Columns-in-Power-BI-16-7474796-768x430.png 768w\" alt=\"how-to-split-columns-in-power-bi-16-7474796\" width=\"1232\" height=\"690\" data-lazy-sizes=\"(max-width: 1232px) 100vw, 1232px\" \/><noscript><img alt='how-to-split-columns-in-power-bi-16-7474796' width='1232' height='690' src='https:\/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/How-to-Split-Columns-in-Power-BI-16-7474796.png' class=\"wp-image-30803\" srcset='\/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/How-to-Split-Columns-in-Power-BI-16-7474796.png 1232w, \/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/How-to-Split-Columns-in-Power-BI-16-7474796-300x168.png 300w, \/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/How-to-Split-Columns-in-Power-BI-16-7474796-1024x574.png 1024w, \/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/How-to-Split-Columns-in-Power-BI-16-7474796-768x430.png 768w' sizes='(max-width: 1232px) 100vw, 1232px'\/><\/noscript><\/figure>\n<p>Independientemente de los cambios que haya realizado (columnas divididas en Power BI), no afectar\u00e1n hasta que presione Aplicar. D\u00e9jame golpear el <b>Close and apply <\/b>option under the <b>Home<\/b> tongue.<\/p>\n<figure class=\"wp-block-image\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-30804\" src=\"https:\/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/How-to-Split-Columns-in-Power-BI-17-7411387.png\" srcset=\"\/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/How-to-Split-Columns-in-Power-BI-17-7411387.png 1093w, \/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/How-to-Split-Columns-in-Power-BI-17-7411387-300x187.png 300w, \/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/How-to-Split-Columns-in-Power-BI-17-7411387-1024x638.png 1024w, \/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/How-to-Split-Columns-in-Power-BI-17-7411387-768x479.png 768w\" alt=\"how-to-split-columns-in-power-bi-17-7411387\" width=\"1093\" height=\"681\" data-lazy-sizes=\"(max-width: 1093px) 100vw, 1093px\" \/><noscript><img alt='how-to-split-columns-in-power-bi-17-7411387' width='1093' height='681' src='https:\/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/How-to-Split-Columns-in-Power-BI-17-7411387.png' class=\"wp-image-30804\" srcset='\/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/How-to-Split-Columns-in-Power-BI-17-7411387.png 1093w, \/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/How-to-Split-Columns-in-Power-BI-17-7411387-300x187.png 300w, \/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/How-to-Split-Columns-in-Power-BI-17-7411387-1024x638.png 1024w, \/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/How-to-Split-Columns-in-Power-BI-17-7411387-768x479.png 768w' sizes='(max-width: 1093px) 100vw, 1093px'\/><\/noscript><\/figure>\n<p>You can now see 11 columns within the Text Employees table.<\/p>\n<figure class=\"wp-block-image\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-30805\" src=\"https:\/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/How-to-Split-Columns-in-Power-BI-18-2408815.png\" srcset=\"\/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/How-to-Split-Columns-in-Power-BI-18-2408815.png 1085w, \/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/How-to-Split-Columns-in-Power-BI-18-2408815-300x165.png 300w, \/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/How-to-Split-Columns-in-Power-BI-18-2408815-1024x563.png 1024w, \/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/How-to-Split-Columns-in-Power-BI-18-2408815-768x423.png 768w\" alt=\"how-to-split-columns-in-power-bi-18-2408815\" width=\"1085\" height=\"597\" data-lazy-sizes=\"(max-width: 1085px) 100vw, 1085px\" \/><noscript><img alt='how-to-split-columns-in-power-bi-18-2408815' width='1085' height='597' src='https:\/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/How-to-Split-Columns-in-Power-BI-18-2408815.png' class=\"wp-image-30805\" srcset='\/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/How-to-Split-Columns-in-Power-BI-18-2408815.png 1085w, \/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/How-to-Split-Columns-in-Power-BI-18-2408815-300x165.png 300w, \/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/How-to-Split-Columns-in-Power-BI-18-2408815-1024x563.png 1024w, \/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/How-to-Split-Columns-in-Power-BI-18-2408815-768x423.png 768w' sizes='(max-width: 1085px) 100vw, 1085px'\/><\/noscript><\/figure>\n<\/div>","protected":false},"excerpt":{"rendered":"<p>En tiempo real, es posible que obtenga los datos que tienen columnas fusionadas (una columna con demasiada informaci\u00f3n). En esa situaci\u00f3n, puede usar la opci\u00f3n Dividir columnas de Power BI&#8230;<\/p>","protected":false},"author":1,"featured_media":84877,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[1359,1360],"tags":[],"class_list":["post-84876","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>C\u00f3mo dividir columnas en Power BI - R Marketing Digital<\/title>\n<meta name=\"description\" content=\"En tiempo real, es posible que obtenga los datos que tienen columnas fusionadas (una columna con demasiada informaci\u00f3n). En esa situaci\u00f3n, puede usar la\" \/>\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\/how-to-divide-columns-in-power-bi\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"C\u00f3mo dividir columnas en Power BI\" \/>\n<meta property=\"og:description\" content=\"En tiempo real, es posible que obtenga los datos que tienen columnas fusionadas (una columna con demasiada informaci\u00f3n). En esa situaci\u00f3n, puede usar la\" \/>\n<meta property=\"og:url\" content=\"https:\/\/rmarketingdigital.com\/en\/powerbi\/how-to-divide-columns-in-power-bi\/\" \/>\n<meta property=\"og:site_name\" content=\"R Marketing Digital\" \/>\n<meta property=\"article:published_time\" content=\"2022-07-30T12:24:43+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/How-to-Split-Columns-in-Power-BI-5-7031837.png\" \/>\n\t<meta property=\"og:image:width\" content=\"978\" \/>\n\t<meta property=\"og:image:height\" content=\"689\" \/>\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\\\/how-to-divide-columns-in-power-bi\\\/#article\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/rmarketingdigital.com\\\/en\\\/powerbi\\\/how-to-divide-columns-in-power-bi\\\/\"},\"author\":{\"name\":\"R Marketing Digital\",\"@id\":\"https:\\\/\\\/rmarketingdigital.com\\\/#\\\/schema\\\/person\\\/7c0d9782b2977b840b3740f00c69a73e\"},\"headline\":\"C\u00f3mo dividir columnas en Power BI\",\"datePublished\":\"2022-07-30T12:24:43+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\\\/\\\/rmarketingdigital.com\\\/en\\\/powerbi\\\/how-to-divide-columns-in-power-bi\\\/\"},\"wordCount\":674,\"image\":{\"@id\":\"https:\\\/\\\/rmarketingdigital.com\\\/en\\\/powerbi\\\/how-to-divide-columns-in-power-bi\\\/#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/rmarketingdigital.com\\\/wp-content\\\/uploads\\\/2020\\\/09\\\/How-to-Split-Columns-in-Power-BI-5-7031837.png\",\"articleSection\":[\"Power BI\",\"Tutoriales PowerBI\"],\"inLanguage\":\"en-US\"},{\"@type\":\"WebPage\",\"@id\":\"https:\\\/\\\/rmarketingdigital.com\\\/en\\\/powerbi\\\/how-to-divide-columns-in-power-bi\\\/\",\"url\":\"https:\\\/\\\/rmarketingdigital.com\\\/en\\\/powerbi\\\/how-to-divide-columns-in-power-bi\\\/\",\"name\":\"C\u00f3mo dividir columnas en Power BI - R Marketing Digital\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/rmarketingdigital.com\\\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\\\/\\\/rmarketingdigital.com\\\/en\\\/powerbi\\\/how-to-divide-columns-in-power-bi\\\/#primaryimage\"},\"image\":{\"@id\":\"https:\\\/\\\/rmarketingdigital.com\\\/en\\\/powerbi\\\/how-to-divide-columns-in-power-bi\\\/#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/rmarketingdigital.com\\\/wp-content\\\/uploads\\\/2020\\\/09\\\/How-to-Split-Columns-in-Power-BI-5-7031837.png\",\"datePublished\":\"2022-07-30T12:24:43+00:00\",\"author\":{\"@id\":\"https:\\\/\\\/rmarketingdigital.com\\\/#\\\/schema\\\/person\\\/7c0d9782b2977b840b3740f00c69a73e\"},\"description\":\"En tiempo real, es posible que obtenga los datos que tienen columnas fusionadas (una columna con demasiada informaci\u00f3n). En esa situaci\u00f3n, puede usar la\",\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\\\/\\\/rmarketingdigital.com\\\/en\\\/powerbi\\\/how-to-divide-columns-in-power-bi\\\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\\\/\\\/rmarketingdigital.com\\\/en\\\/powerbi\\\/how-to-divide-columns-in-power-bi\\\/#primaryimage\",\"url\":\"https:\\\/\\\/rmarketingdigital.com\\\/wp-content\\\/uploads\\\/2020\\\/09\\\/How-to-Split-Columns-in-Power-BI-5-7031837.png\",\"contentUrl\":\"https:\\\/\\\/rmarketingdigital.com\\\/wp-content\\\/uploads\\\/2020\\\/09\\\/How-to-Split-Columns-in-Power-BI-5-7031837.png\",\"width\":978,\"height\":689,\"caption\":\"how-to-split-columns-in-power-bi-5-7031837-8127703-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":"C\u00f3mo dividir columnas en Power BI - R Marketing Digital","description":"In real time, you might get the data that has merged columns (a column with too much information). In that situation, you can use the","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\/how-to-divide-columns-in-power-bi\/","og_locale":"en_US","og_type":"article","og_title":"C\u00f3mo dividir columnas en Power BI","og_description":"En tiempo real, es posible que obtenga los datos que tienen columnas fusionadas (una columna con demasiada informaci\u00f3n). En esa situaci\u00f3n, puede usar la","og_url":"https:\/\/rmarketingdigital.com\/en\/powerbi\/how-to-divide-columns-in-power-bi\/","og_site_name":"R Marketing Digital","article_published_time":"2022-07-30T12:24:43+00:00","og_image":[{"width":978,"height":689,"url":"https:\/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/How-to-Split-Columns-in-Power-BI-5-7031837.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\/how-to-divide-columns-in-power-bi\/#article","isPartOf":{"@id":"https:\/\/rmarketingdigital.com\/en\/powerbi\/how-to-divide-columns-in-power-bi\/"},"author":{"name":"R Marketing Digital","@id":"https:\/\/rmarketingdigital.com\/#\/schema\/person\/7c0d9782b2977b840b3740f00c69a73e"},"headline":"C\u00f3mo dividir columnas en Power BI","datePublished":"2022-07-30T12:24:43+00:00","mainEntityOfPage":{"@id":"https:\/\/rmarketingdigital.com\/en\/powerbi\/how-to-divide-columns-in-power-bi\/"},"wordCount":674,"image":{"@id":"https:\/\/rmarketingdigital.com\/en\/powerbi\/how-to-divide-columns-in-power-bi\/#primaryimage"},"thumbnailUrl":"https:\/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/How-to-Split-Columns-in-Power-BI-5-7031837.png","articleSection":["Power BI","Tutoriales PowerBI"],"inLanguage":"en-US"},{"@type":"WebPage","@id":"https:\/\/rmarketingdigital.com\/en\/powerbi\/how-to-divide-columns-in-power-bi\/","url":"https:\/\/rmarketingdigital.com\/en\/powerbi\/how-to-divide-columns-in-power-bi\/","name":"C\u00f3mo dividir columnas en Power BI - R Marketing Digital","isPartOf":{"@id":"https:\/\/rmarketingdigital.com\/#website"},"primaryImageOfPage":{"@id":"https:\/\/rmarketingdigital.com\/en\/powerbi\/how-to-divide-columns-in-power-bi\/#primaryimage"},"image":{"@id":"https:\/\/rmarketingdigital.com\/en\/powerbi\/how-to-divide-columns-in-power-bi\/#primaryimage"},"thumbnailUrl":"https:\/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/How-to-Split-Columns-in-Power-BI-5-7031837.png","datePublished":"2022-07-30T12:24:43+00:00","author":{"@id":"https:\/\/rmarketingdigital.com\/#\/schema\/person\/7c0d9782b2977b840b3740f00c69a73e"},"description":"In real time, you might get the data that has merged columns (a column with too much information). In that situation, you can use the","inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/rmarketingdigital.com\/en\/powerbi\/how-to-divide-columns-in-power-bi\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/rmarketingdigital.com\/en\/powerbi\/how-to-divide-columns-in-power-bi\/#primaryimage","url":"https:\/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/How-to-Split-Columns-in-Power-BI-5-7031837.png","contentUrl":"https:\/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/How-to-Split-Columns-in-Power-BI-5-7031837.png","width":978,"height":689,"caption":"how-to-split-columns-in-power-bi-5-7031837-8127703-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\/84876","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=84876"}],"version-history":[{"count":0,"href":"https:\/\/rmarketingdigital.com\/en\/wp-json\/wp\/v2\/posts\/84876\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/rmarketingdigital.com\/en\/wp-json\/wp\/v2\/media\/84877"}],"wp:attachment":[{"href":"https:\/\/rmarketingdigital.com\/en\/wp-json\/wp\/v2\/media?parent=84876"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/rmarketingdigital.com\/en\/wp-json\/wp\/v2\/categories?post=84876"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/rmarketingdigital.com\/en\/wp-json\/wp\/v2\/tags?post=84876"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}