{"id":83110,"date":"2022-08-07T06:31:15","date_gmt":"2022-08-07T04:31:15","guid":{"rendered":"https:\/\/rmarketingdigital.com\/powerbi\/agregar-columna-condicional-en-power-bi\/"},"modified":"2020-09-16T18:25:19","modified_gmt":"2020-09-16T21:25:19","slug":"agregar-columna-condicional-en-power-bi","status":"publish","type":"post","link":"https:\/\/rmarketingdigital.com\/en\/powerbi\/agregar-columna-condicional-en-power-bi\/","title":{"rendered":"Add conditional column in Power BI"},"content":{"rendered":"<div>\n<p>The Power BI Conditional column generates a new column based on the condition we specify, for example, creating an evaluation column based on employee performance, etc. Let me show you how to add a conditional column in Power BI with an example.<\/p>\n<p><span id=\"ezoic-pub-ad-placeholder-104\"\/><span style=\"display:block !important;float:none !important;margin-bottom:15px !important;margin-left:0px !important;margin-right:0px !important;margin-top:15px !important;min-height:90px;min-width:728px;text-align:center !important;\" class=\"ezoic-ad medrectangle-3 adtester-container adtester-container-104\" data-ez-name=\"tutorialgateway_org-medrectangle-3\"><span id=\"div-gpt-ad-tutorialgateway_org-medrectangle-3-0\" ezaw=\"728\" ezah=\"90\" style=\"position:relative;z-index:0;display:inline-block;width:100%;max-width:1200px;margin-left:auto !important;margin-right:auto !important;min-height:90px;min-width:728px;\" class=\"ezoic-ad\"\/><\/span><\/p>\n<h2>How to add a conditional column in Power BI<\/h2>\n<p>To demonstrate this conditional column from Power BI, we will use the SQL table that we imported in the Enter data article.<\/p>\n<p>To add a conditional column, click the <strong>Edit queries<\/strong> option under the <strong>Home<\/strong> tongue.<span id=\"ezoic-pub-ad-placeholder-132\" class=\"ezoic-adpicker-ad\"\/><span style=\"display:block !important;float:none !important;margin-bottom:15px !important;margin-left:0px !important;margin-right:0px !important;margin-top:15px !important;min-height:250px;min-width:300px;text-align:center !important;\" class=\"ezoic-ad box-3 adtester-container adtester-container-132\" data-ez-name=\"tutorialgateway_org-box-3\"><span id=\"div-gpt-ad-tutorialgateway_org-box-3-0\" ezaw=\"300\" ezah=\"250\" style=\"position:relative;z-index:0;display:inline-block;min-height:250px;min-width:300px;\" class=\"ezoic-ad\"\/><\/span><\/p>\n<figure class=\"wp-block-image\"><img alt='add-conditional-column-in-power-bi-1-9942885' width='1093' height='582' class=\"wp-image-30909\" srcset='\/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Add-Conditional-Column-in-Power-BI-1-9942885.png 1093w, \/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Add-Conditional-Column-in-Power-BI-1-9942885-300x160.png 300w, \/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Add-Conditional-Column-in-Power-BI-1-9942885-1024x545.png 1024w, \/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Add-Conditional-Column-in-Power-BI-1-9942885-768x409.png 768w' data-lazy-sizes='(max-width: 1093px) 100vw, 1093px' src='https:\/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Add-Conditional-Column-in-Power-BI-1-9942885.png'\/><noscript><img alt='add-conditional-column-in-power-bi-1-9942885' width='1093' height='582' src='https:\/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Add-Conditional-Column-in-Power-BI-1-9942885.png' class=\"wp-image-30909\" srcset='\/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Add-Conditional-Column-in-Power-BI-1-9942885.png 1093w, \/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Add-Conditional-Column-in-Power-BI-1-9942885-300x160.png 300w, \/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Add-Conditional-Column-in-Power-BI-1-9942885-1024x545.png 1024w, \/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Add-Conditional-Column-in-Power-BI-1-9942885-768x409.png 768w' sizes='(max-width: 1093px) 100vw, 1093px'\/><\/noscript><\/figure>\n<p>By clicking on the <strong>Edit queries<\/strong> The option opens a new window called Power BI <strong>Power Query Editor<\/strong>. In this example, we will use the Sales column.<\/p>\n<figure class=\"wp-block-image\"><img alt='add-conditional-column-in-power-bi-2-1899707' width='1196' height='581' class=\"wp-image-30910\" srcset='\/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Add-Conditional-Column-in-Power-BI-2-1899707.png 1196w, \/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Add-Conditional-Column-in-Power-BI-2-1899707-300x146.png 300w, \/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Add-Conditional-Column-in-Power-BI-2-1899707-1024x497.png 1024w, \/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Add-Conditional-Column-in-Power-BI-2-1899707-768x373.png 768w' data-lazy-sizes='(max-width: 1196px) 100vw, 1196px' src='https:\/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Add-Conditional-Column-in-Power-BI-2-1899707.png'\/><noscript><img alt='add-conditional-column-in-power-bi-2-1899707' width='1196' height='581' src='https:\/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Add-Conditional-Column-in-Power-BI-2-1899707.png' class=\"wp-image-30910\" srcset='\/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Add-Conditional-Column-in-Power-BI-2-1899707.png 1196w, \/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Add-Conditional-Column-in-Power-BI-2-1899707-300x146.png 300w, \/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Add-Conditional-Column-in-Power-BI-2-1899707-1024x497.png 1024w, \/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Add-Conditional-Column-in-Power-BI-2-1899707-768x373.png 768w' sizes='(max-width: 1196px) 100vw, 1196px'\/><\/noscript><\/figure>\n<p>First, go to <strong>Add column<\/strong> Tongue. Under this tab, you can see the Conditional Column button. You can use this button to add the conditional column to this table.<\/p>\n<p><span id=\"ezoic-pub-ad-placeholder-105\"\/><span style=\"display:block !important;float:none !important;margin-bottom:15px !important;margin-left:0px !important;margin-right:0px !important;margin-top:15px !important;min-height:400px;min-width:580px;text-align:center !important;\" class=\"ezoic-ad box-4 adtester-container adtester-container-105\" data-ez-name=\"tutorialgateway_org-box-4\"><span id=\"div-gpt-ad-tutorialgateway_org-box-4-0\" ezaw=\"580\" ezah=\"400\" style=\"position:relative;z-index:0;display:inline-block;width:100%;max-width:1200px;margin-left:auto !important;margin-right:auto !important;min-height:400px;min-width:580px;\" class=\"ezoic-ad ezoic-adl\"\/><\/span><\/p>\n<figure class=\"wp-block-image\"><img alt='add-conditional-column-in-power-bi-3-1337500' width='1196' height='586' class=\"wp-image-30911\" srcset='\/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Add-Conditional-Column-in-Power-BI-3-1337500.png 1196w, \/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Add-Conditional-Column-in-Power-BI-3-1337500-300x147.png 300w, \/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Add-Conditional-Column-in-Power-BI-3-1337500-1024x502.png 1024w, \/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Add-Conditional-Column-in-Power-BI-3-1337500-768x376.png 768w' data-lazy-sizes='(max-width: 1196px) 100vw, 1196px' src='https:\/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Add-Conditional-Column-in-Power-BI-3-1337500.png'\/><noscript><img alt='add-conditional-column-in-power-bi-3-1337500' width='1196' height='586' src='https:\/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Add-Conditional-Column-in-Power-BI-3-1337500.png' class=\"wp-image-30911\" srcset='\/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Add-Conditional-Column-in-Power-BI-3-1337500.png 1196w, \/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Add-Conditional-Column-in-Power-BI-3-1337500-300x147.png 300w, \/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Add-Conditional-Column-in-Power-BI-3-1337500-1024x502.png 1024w, \/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Add-Conditional-Column-in-Power-BI-3-1337500-768x376.png 768w' sizes='(max-width: 1196px) 100vw, 1196px'\/><\/noscript><\/figure>\n<p>Clicking the Conditional Column button in Power BI opens the following window.<\/p>\n<figure class=\"wp-block-image\"><img alt='add-conditional-column-in-power-bi-4-1315453' width='924' height='390' class=\"wp-image-30912\" srcset='\/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Add-Conditional-Column-in-Power-BI-4-1315453.png 924w, \/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Add-Conditional-Column-in-Power-BI-4-1315453-300x127.png 300w, \/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Add-Conditional-Column-in-Power-BI-4-1315453-768x324.png 768w' data-lazy-sizes='(max-width: 924px) 100vw, 924px' src='https:\/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Add-Conditional-Column-in-Power-BI-4-1315453.png'\/><noscript><img alt='add-conditional-column-in-power-bi-4-1315453' width='924' height='390' src='https:\/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Add-Conditional-Column-in-Power-BI-4-1315453.png' class=\"wp-image-30912\" srcset='\/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Add-Conditional-Column-in-Power-BI-4-1315453.png 924w, \/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Add-Conditional-Column-in-Power-BI-4-1315453-300x127.png 300w, \/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Add-Conditional-Column-in-Power-BI-4-1315453-768x324.png 768w' sizes='(max-width: 924px) 100vw, 924px'\/><\/noscript><\/figure>\n<p>We change the name of the column to Classification. Next, we select the column name as Sales<\/p>\n<figure class=\"wp-block-image\"><img alt='add-conditional-column-in-power-bi-5-1237711' width='925' height='390' class=\"wp-image-30913\" srcset='\/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Add-Conditional-Column-in-Power-BI-5-1237711.png 925w, \/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Add-Conditional-Column-in-Power-BI-5-1237711-300x126.png 300w, \/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Add-Conditional-Column-in-Power-BI-5-1237711-768x324.png 768w' data-lazy-sizes='(max-width: 925px) 100vw, 925px' src='https:\/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Add-Conditional-Column-in-Power-BI-5-1237711.png'\/><noscript><img alt='add-conditional-column-in-power-bi-5-1237711' width='925' height='390' src='https:\/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Add-Conditional-Column-in-Power-BI-5-1237711.png' class=\"wp-image-30913\" srcset='\/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Add-Conditional-Column-in-Power-BI-5-1237711.png 925w, \/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Add-Conditional-Column-in-Power-BI-5-1237711-300x126.png 300w, \/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Add-Conditional-Column-in-Power-BI-5-1237711-768x324.png 768w' sizes='(max-width: 925px) 100vw, 925px'\/><\/noscript><\/figure>\n<p>Next, we select the Operator as greater than and the value as 3000. Within the Values or Output text box, you can give the static values or you can select the column.<\/p>\n<figure class=\"wp-block-image\"><img alt='add-conditional-column-in-power-bi-6-9320038' width='925' height='390' class=\"wp-image-30914\" srcset='\/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Add-Conditional-Column-in-Power-BI-6-9320038.png 925w, \/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Add-Conditional-Column-in-Power-BI-6-9320038-300x126.png 300w, \/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Add-Conditional-Column-in-Power-BI-6-9320038-768x324.png 768w' data-lazy-sizes='(max-width: 925px) 100vw, 925px' src='https:\/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Add-Conditional-Column-in-Power-BI-6-9320038.png'\/><noscript><img alt='add-conditional-column-in-power-bi-6-9320038' width='925' height='390' src='https:\/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Add-Conditional-Column-in-Power-BI-6-9320038.png' class=\"wp-image-30914\" srcset='\/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Add-Conditional-Column-in-Power-BI-6-9320038.png 925w, \/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Add-Conditional-Column-in-Power-BI-6-9320038-300x126.png 300w, \/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Add-Conditional-Column-in-Power-BI-6-9320038-768x324.png 768w' sizes='(max-width: 925px) 100vw, 925px'\/><\/noscript><\/figure>\n<p>We added the first rule: if sales are over 3000, return Excellent within the grade column. Then click the Add Rule button to add a new rule.<\/p>\n<figure class=\"wp-block-image\"><img alt='add-conditional-column-in-power-bi-7-7183949' width='925' height='390' class=\"wp-image-30915\" srcset='\/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Add-Conditional-Column-in-Power-BI-7-7183949.png 925w, \/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Add-Conditional-Column-in-Power-BI-7-7183949-300x126.png 300w, \/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Add-Conditional-Column-in-Power-BI-7-7183949-768x324.png 768w' data-lazy-sizes='(max-width: 925px) 100vw, 925px' src='https:\/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Add-Conditional-Column-in-Power-BI-7-7183949.png'\/><noscript><img alt='add-conditional-column-in-power-bi-7-7183949' width='925' height='390' src='https:\/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Add-Conditional-Column-in-Power-BI-7-7183949.png' class=\"wp-image-30915\" srcset='\/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Add-Conditional-Column-in-Power-BI-7-7183949.png 925w, \/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Add-Conditional-Column-in-Power-BI-7-7183949-300x126.png 300w, \/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Add-Conditional-Column-in-Power-BI-7-7183949-768x324.png 768w' sizes='(max-width: 925px) 100vw, 925px'\/><\/noscript><\/figure>\n<p>As you can see in the screenshot below, we added two more rules. Remember, this is the same as the Else If statement in SQL.<\/p>\n<figure class=\"wp-block-image\"><img alt='add-conditional-column-in-power-bi-8-9502455' width='925' height='454' class=\"wp-image-30916\" srcset='\/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Add-Conditional-Column-in-Power-BI-8-9502455.png 925w, \/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Add-Conditional-Column-in-Power-BI-8-9502455-300x147.png 300w, \/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Add-Conditional-Column-in-Power-BI-8-9502455-768x377.png 768w' data-lazy-sizes='(max-width: 925px) 100vw, 925px' src='https:\/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Add-Conditional-Column-in-Power-BI-8-9502455.png'\/><noscript><img alt='add-conditional-column-in-power-bi-8-9502455' width='925' height='454' src='https:\/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Add-Conditional-Column-in-Power-BI-8-9502455.png' class=\"wp-image-30916\" srcset='\/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Add-Conditional-Column-in-Power-BI-8-9502455.png 925w, \/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Add-Conditional-Column-in-Power-BI-8-9502455-300x147.png 300w, \/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Add-Conditional-Column-in-Power-BI-8-9502455-768x377.png 768w' sizes='(max-width: 925px) 100vw, 925px'\/><\/noscript><\/figure>\n<p>You can use the\u2026 .. button to move the selected rule up and down, or you can also delete it. For now, we leave it as is and click the OK button<\/p>\n<figure class=\"wp-block-image\"><img alt='add-conditional-column-in-power-bi-9-8726213' width='924' height='454' class=\"wp-image-30917\" srcset='\/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Add-Conditional-Column-in-Power-BI-9-8726213.png 924w, \/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Add-Conditional-Column-in-Power-BI-9-8726213-300x147.png 300w, \/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Add-Conditional-Column-in-Power-BI-9-8726213-768x377.png 768w' data-lazy-sizes='(max-width: 924px) 100vw, 924px' src='https:\/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Add-Conditional-Column-in-Power-BI-9-8726213.png'\/><noscript><img alt='add-conditional-column-in-power-bi-9-8726213' width='924' height='454' src='https:\/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Add-Conditional-Column-in-Power-BI-9-8726213.png' class=\"wp-image-30917\" srcset='\/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Add-Conditional-Column-in-Power-BI-9-8726213.png 924w, \/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Add-Conditional-Column-in-Power-BI-9-8726213-300x147.png 300w, \/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Add-Conditional-Column-in-Power-BI-9-8726213-768x377.png 768w' sizes='(max-width: 924px) 100vw, 924px'\/><\/noscript><\/figure>\n<p>From the screenshot below, you can see the new column with the information we specified in the conditional column. Then press the <b>Close and apply <\/b>option under the <b>Home<\/b> tab to apply these changes.<\/p>\n<figure class=\"wp-block-image\"><img alt='add-conditional-column-in-power-bi-10-2184906' width='1196' height='584' class=\"wp-image-30918\" srcset='\/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Add-Conditional-Column-in-Power-BI-10-2184906.png 1196w, \/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Add-Conditional-Column-in-Power-BI-10-2184906-300x146.png 300w, \/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Add-Conditional-Column-in-Power-BI-10-2184906-1024x500.png 1024w, \/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Add-Conditional-Column-in-Power-BI-10-2184906-768x375.png 768w' data-lazy-sizes='(max-width: 1196px) 100vw, 1196px' src='https:\/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Add-Conditional-Column-in-Power-BI-10-2184906.png'\/><noscript><img alt='add-conditional-column-in-power-bi-10-2184906' width='1196' height='584' src='https:\/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Add-Conditional-Column-in-Power-BI-10-2184906.png' class=\"wp-image-30918\" srcset='\/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Add-Conditional-Column-in-Power-BI-10-2184906.png 1196w, \/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Add-Conditional-Column-in-Power-BI-10-2184906-300x146.png 300w, \/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Add-Conditional-Column-in-Power-BI-10-2184906-1024x500.png 1024w, \/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Add-Conditional-Column-in-Power-BI-10-2184906-768x375.png 768w' sizes='(max-width: 1196px) 100vw, 1196px'\/><\/noscript><\/figure>\n<p>You can now see the new Power BI conditional column named Grade in the SQL Employees table.<\/p>\n<figure class=\"wp-block-image\"><img alt='add-conditional-column-in-power-bi-11-6254136' width='1091' height='581' class=\"wp-image-30919\" srcset='\/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Add-Conditional-Column-in-Power-BI-11-6254136.png 1091w, \/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Add-Conditional-Column-in-Power-BI-11-6254136-300x160.png 300w, \/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Add-Conditional-Column-in-Power-BI-11-6254136-1024x545.png 1024w, \/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Add-Conditional-Column-in-Power-BI-11-6254136-768x409.png 768w' data-lazy-sizes='(max-width: 1091px) 100vw, 1091px' src='https:\/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Add-Conditional-Column-in-Power-BI-11-6254136.png'\/><noscript><img alt='add-conditional-column-in-power-bi-11-6254136' width='1091' height='581' src='https:\/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Add-Conditional-Column-in-Power-BI-11-6254136.png' class=\"wp-image-30919\" srcset='\/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Add-Conditional-Column-in-Power-BI-11-6254136.png 1091w, \/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Add-Conditional-Column-in-Power-BI-11-6254136-300x160.png 300w, \/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Add-Conditional-Column-in-Power-BI-11-6254136-1024x545.png 1024w, \/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Add-Conditional-Column-in-Power-BI-11-6254136-768x409.png 768w' sizes='(max-width: 1091px) 100vw, 1091px'\/><\/noscript><\/figure>\n<\/div>","protected":false},"excerpt":{"rendered":"<p>La columna Condicional de Power BI genera una nueva columna basada en la condici\u00f3n que especificamos, por ejemplo, creando una columna de evaluaci\u00f3n basada en el desempe\u00f1o de los empleados,&#8230;<\/p>","protected":false},"author":1,"featured_media":83111,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[1359,1360],"tags":[],"class_list":["post-83110","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>Agregar columna condicional en Power BI - R Marketing Digital<\/title>\n<meta name=\"description\" content=\"La columna Condicional de Power BI genera una nueva columna basada en la condici\u00f3n que especificamos, por ejemplo, creando una columna de evaluaci\u00f3n\" \/>\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\/agregar-columna-condicional-en-power-bi\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Agregar columna condicional en Power BI\" \/>\n<meta property=\"og:description\" content=\"La columna Condicional de Power BI genera una nueva columna basada en la condici\u00f3n que especificamos, por ejemplo, creando una columna de evaluaci\u00f3n\" \/>\n<meta property=\"og:url\" content=\"https:\/\/rmarketingdigital.com\/en\/powerbi\/agregar-columna-condicional-en-power-bi\/\" \/>\n<meta property=\"og:site_name\" content=\"R Marketing Digital\" \/>\n<meta property=\"article:published_time\" content=\"2022-08-07T04:31:15+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Add-Conditional-Column-in-Power-BI-8-2028583.png\" \/>\n\t<meta property=\"og:image:width\" content=\"925\" \/>\n\t<meta property=\"og:image:height\" content=\"454\" \/>\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\\\/agregar-columna-condicional-en-power-bi\\\/#article\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/rmarketingdigital.com\\\/powerbi\\\/agregar-columna-condicional-en-power-bi\\\/\"},\"author\":{\"name\":\"R Marketing Digital\",\"@id\":\"https:\\\/\\\/rmarketingdigital.com\\\/#\\\/schema\\\/person\\\/7c0d9782b2977b840b3740f00c69a73e\"},\"headline\":\"Agregar columna condicional en Power BI\",\"datePublished\":\"2022-08-07T04:31:15+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\\\/\\\/rmarketingdigital.com\\\/powerbi\\\/agregar-columna-condicional-en-power-bi\\\/\"},\"wordCount\":389,\"image\":{\"@id\":\"https:\\\/\\\/rmarketingdigital.com\\\/powerbi\\\/agregar-columna-condicional-en-power-bi\\\/#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/rmarketingdigital.com\\\/wp-content\\\/uploads\\\/2020\\\/09\\\/Add-Conditional-Column-in-Power-BI-8-2028583.png\",\"articleSection\":[\"Power BI\",\"Tutoriales PowerBI\"],\"inLanguage\":\"en-US\"},{\"@type\":\"WebPage\",\"@id\":\"https:\\\/\\\/rmarketingdigital.com\\\/powerbi\\\/agregar-columna-condicional-en-power-bi\\\/\",\"url\":\"https:\\\/\\\/rmarketingdigital.com\\\/powerbi\\\/agregar-columna-condicional-en-power-bi\\\/\",\"name\":\"Agregar columna condicional en Power BI - R Marketing Digital\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/rmarketingdigital.com\\\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\\\/\\\/rmarketingdigital.com\\\/powerbi\\\/agregar-columna-condicional-en-power-bi\\\/#primaryimage\"},\"image\":{\"@id\":\"https:\\\/\\\/rmarketingdigital.com\\\/powerbi\\\/agregar-columna-condicional-en-power-bi\\\/#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/rmarketingdigital.com\\\/wp-content\\\/uploads\\\/2020\\\/09\\\/Add-Conditional-Column-in-Power-BI-8-2028583.png\",\"datePublished\":\"2022-08-07T04:31:15+00:00\",\"author\":{\"@id\":\"https:\\\/\\\/rmarketingdigital.com\\\/#\\\/schema\\\/person\\\/7c0d9782b2977b840b3740f00c69a73e\"},\"description\":\"La columna Condicional de Power BI genera una nueva columna basada en la condici\u00f3n que especificamos, por ejemplo, creando una columna de evaluaci\u00f3n\",\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\\\/\\\/rmarketingdigital.com\\\/powerbi\\\/agregar-columna-condicional-en-power-bi\\\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\\\/\\\/rmarketingdigital.com\\\/powerbi\\\/agregar-columna-condicional-en-power-bi\\\/#primaryimage\",\"url\":\"https:\\\/\\\/rmarketingdigital.com\\\/wp-content\\\/uploads\\\/2020\\\/09\\\/Add-Conditional-Column-in-Power-BI-8-2028583.png\",\"contentUrl\":\"https:\\\/\\\/rmarketingdigital.com\\\/wp-content\\\/uploads\\\/2020\\\/09\\\/Add-Conditional-Column-in-Power-BI-8-2028583.png\",\"width\":925,\"height\":454,\"caption\":\"add-conditional-column-in-power-bi-8-2028583-1408231-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":"Agregar columna condicional en Power BI - R Marketing Digital","description":"The Power BI Conditional column generates a new column based on the condition we specify, for example, by creating an evaluation column","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\/agregar-columna-condicional-en-power-bi\/","og_locale":"en_US","og_type":"article","og_title":"Agregar columna condicional en Power BI","og_description":"La columna Condicional de Power BI genera una nueva columna basada en la condici\u00f3n que especificamos, por ejemplo, creando una columna de evaluaci\u00f3n","og_url":"https:\/\/rmarketingdigital.com\/en\/powerbi\/agregar-columna-condicional-en-power-bi\/","og_site_name":"R Marketing Digital","article_published_time":"2022-08-07T04:31:15+00:00","og_image":[{"width":925,"height":454,"url":"https:\/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Add-Conditional-Column-in-Power-BI-8-2028583.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\/agregar-columna-condicional-en-power-bi\/#article","isPartOf":{"@id":"https:\/\/rmarketingdigital.com\/powerbi\/agregar-columna-condicional-en-power-bi\/"},"author":{"name":"R Marketing Digital","@id":"https:\/\/rmarketingdigital.com\/#\/schema\/person\/7c0d9782b2977b840b3740f00c69a73e"},"headline":"Agregar columna condicional en Power BI","datePublished":"2022-08-07T04:31:15+00:00","mainEntityOfPage":{"@id":"https:\/\/rmarketingdigital.com\/powerbi\/agregar-columna-condicional-en-power-bi\/"},"wordCount":389,"image":{"@id":"https:\/\/rmarketingdigital.com\/powerbi\/agregar-columna-condicional-en-power-bi\/#primaryimage"},"thumbnailUrl":"https:\/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Add-Conditional-Column-in-Power-BI-8-2028583.png","articleSection":["Power BI","Tutoriales PowerBI"],"inLanguage":"en-US"},{"@type":"WebPage","@id":"https:\/\/rmarketingdigital.com\/powerbi\/agregar-columna-condicional-en-power-bi\/","url":"https:\/\/rmarketingdigital.com\/powerbi\/agregar-columna-condicional-en-power-bi\/","name":"Agregar columna condicional en Power BI - R Marketing Digital","isPartOf":{"@id":"https:\/\/rmarketingdigital.com\/#website"},"primaryImageOfPage":{"@id":"https:\/\/rmarketingdigital.com\/powerbi\/agregar-columna-condicional-en-power-bi\/#primaryimage"},"image":{"@id":"https:\/\/rmarketingdigital.com\/powerbi\/agregar-columna-condicional-en-power-bi\/#primaryimage"},"thumbnailUrl":"https:\/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Add-Conditional-Column-in-Power-BI-8-2028583.png","datePublished":"2022-08-07T04:31:15+00:00","author":{"@id":"https:\/\/rmarketingdigital.com\/#\/schema\/person\/7c0d9782b2977b840b3740f00c69a73e"},"description":"The Power BI Conditional column generates a new column based on the condition we specify, for example, by creating an evaluation column","inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/rmarketingdigital.com\/powerbi\/agregar-columna-condicional-en-power-bi\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/rmarketingdigital.com\/powerbi\/agregar-columna-condicional-en-power-bi\/#primaryimage","url":"https:\/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Add-Conditional-Column-in-Power-BI-8-2028583.png","contentUrl":"https:\/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Add-Conditional-Column-in-Power-BI-8-2028583.png","width":925,"height":454,"caption":"add-conditional-column-in-power-bi-8-2028583-1408231-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\/83110","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=83110"}],"version-history":[{"count":0,"href":"https:\/\/rmarketingdigital.com\/en\/wp-json\/wp\/v2\/posts\/83110\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/rmarketingdigital.com\/en\/wp-json\/wp\/v2\/media\/83111"}],"wp:attachment":[{"href":"https:\/\/rmarketingdigital.com\/en\/wp-json\/wp\/v2\/media?parent=83110"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/rmarketingdigital.com\/en\/wp-json\/wp\/v2\/categories?post=83110"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/rmarketingdigital.com\/en\/wp-json\/wp\/v2\/tags?post=83110"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}