{"id":84137,"date":"2022-05-05T04:47:35","date_gmt":"2022-05-05T02:47:35","guid":{"rendered":"https:\/\/rmarketingdigital.com\/powerbi\/funciones-logicas-de-power-bi-dax\/"},"modified":"2021-07-20T18:30:35","modified_gmt":"2021-07-20T16:30:35","slug":"funciones-logicas-de-power-bi-dax","status":"publish","type":"post","link":"https:\/\/rmarketingdigital.com\/en\/powerbi\/funciones-logicas-de-power-bi-dax\/","title":{"rendered":"Logical functions of Power BI DAX"},"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-logicas-de-power-bi-dax\/#Funciones-logicas-de-Power-BI-DAX\" >Funciones l\u00f3gicas 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-logicas-de-power-bi-dax\/#Funcion-IF-de-Power-BI-DAX\" >Funci\u00f3n IF 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-3\" href=\"https:\/\/rmarketingdigital.com\/en\/powerbi\/funciones-logicas-de-power-bi-dax\/#Funcion-IF-anidada-de-Power-BI-DAX\" >Funci\u00f3n IF anidada 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-4\" href=\"https:\/\/rmarketingdigital.com\/en\/powerbi\/funciones-logicas-de-power-bi-dax\/#Funcion-DAX-AND-de-Power-BI\" >Funci\u00f3n DAX AND de Power BI<\/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-logicas-de-power-bi-dax\/#Funcion-Power-BI-DAX-OR\" >Funci\u00f3n Power BI DAX OR<\/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-logicas-de-power-bi-dax\/#Funcion-Power-BI-DAX-NOT\" >Funci\u00f3n Power BI DAX NOT<\/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-logicas-de-power-bi-dax\/#Funcion-Power-BI-DAX-IN\" >Funci\u00f3n Power BI DAX IN<\/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-logicas-de-power-bi-dax\/#Funcion-Power-BI-DAX-TRUE\" >Funci\u00f3n Power BI DAX TRUE<\/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-logicas-de-power-bi-dax\/#Funcion-FALSE-de-Power-BI-DAX\" >Funci\u00f3n FALSE 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-10\" href=\"https:\/\/rmarketingdigital.com\/en\/powerbi\/funciones-logicas-de-power-bi-dax\/#Funcion-IFERROR-de-Power-BI-DAX\" >Funci\u00f3n IFERROR 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-11\" href=\"https:\/\/rmarketingdigital.com\/en\/powerbi\/funciones-logicas-de-power-bi-dax\/#Funcion-SWITCH-de-Power-BI-DAX\" >Funci\u00f3n SWITCH de Power BI DAX<\/a><\/li><\/ul><\/li><\/ul><\/nav><\/div>\n<div>\n<p>\u00bfC\u00f3mo usar las funciones l\u00f3gicas de Power BI DAX con ejemplos? Microsoft Power BI DAX proporciona varias funciones l\u00f3gicas, como instrucci\u00f3n IF, AND, OR, NOT, IN, TRUE, FALSE, IFERROR, SWITCH, etc.<\/p>\n<p>&nbsp;<\/p>\n<p>Para demostrar estas funciones l\u00f3gicas de Power BI DAX, usamos los datos que se muestran a continuaci\u00f3n. Como puede ver, hay 15 registros en esta tabla.<\/p>\n<figure class=\"wp-block-image\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-32775\" src=\"https:\/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Power-BI-DAX-Logical-Functions-1-2902891.png\" srcset=\"\/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Power-BI-DAX-Logical-Functions-1-2902891.png 995w, \/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Power-BI-DAX-Logical-Functions-1-2902891-300x182.png 300w, \/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Power-BI-DAX-Logical-Functions-1-2902891-768x467.png 768w\" alt=\"power-bi-dax-logical-functions-1-2902891\" width=\"995\" height=\"605\" data-lazy-sizes=\"(max-width: 995px) 100vw, 995px\" \/><noscript><img alt='power-bi-dax-logical-functions-1-2902891' width='995' height='605' src='https:\/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Power-BI-DAX-Logical-Functions-1-2902891.png' alt=\"Funciones l\u00f3gicas de Power BI DAX 1\" class=\"wp-image-32775\" srcset='\/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Power-BI-DAX-Logical-Functions-1-2902891.png 995w, \/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Power-BI-DAX-Logical-Functions-1-2902891-300x182.png 300w, \/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Power-BI-DAX-Logical-Functions-1-2902891-768x467.png 768w' sizes='(max-width: 995px) 100vw, 995px'\/><\/noscript><\/figure>\n<h2><span class=\"ez-toc-section\" id=\"Funciones-logicas-de-Power-BI-DAX\"><\/span>Funciones l\u00f3gicas de Power BI DAX<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p>La siguiente serie de ejemplos muestra la lista de funciones l\u00f3gicas de DAX en Power BI.<\/p>\n<h3><span class=\"ez-toc-section\" id=\"Funcion-IF-de-Power-BI-DAX\"><\/span>Funci\u00f3n IF de Power BI DAX<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p>La funci\u00f3n de Power BI DAX If comprueba si la expresi\u00f3n dada es verdadera o falsa. La sintaxis de Power BI DAX If Function es<\/p>\n<pre class=\"wp-block-preformatted lang:tsql decode:true\">IF(Expression, True_Info, False_Info)<\/pre>\n<p>Como puede ver en la sintaxis anterior, esta funci\u00f3n de Power BI DAX IF acepta tres argumentos: el primer argumento es la expresi\u00f3n booleana (que devuelve verdadero o falso). Si el resultado de la expresi\u00f3n es VERDADERO, el segundo argumento regresa; de lo contrario, volver\u00e1 el tercer argumento.<\/p>\n<p>&nbsp;<\/p>\n<p>Para demostrar estas funciones l\u00f3gicas de DAX en Power BI, tenemos que usar Calculated. Para <a href=\"https:\/\/rmarketingdigital.com\/powerbi\/crear-columnas-calculadas-en-power-bi\/\">crear una columna<\/a>, 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<figure class=\"wp-block-image\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-32776\" src=\"https:\/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Power-BI-DAX-Logical-Functions-2-6893991.png\" srcset=\"\/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Power-BI-DAX-Logical-Functions-2-6893991.png 923w, \/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Power-BI-DAX-Logical-Functions-2-6893991-300x209.png 300w, \/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Power-BI-DAX-Logical-Functions-2-6893991-768x534.png 768w\" alt=\"power-bi-dax-logical-functions-2-6893991\" width=\"923\" height=\"642\" data-lazy-sizes=\"(max-width: 923px) 100vw, 923px\" \/><noscript><img alt='power-bi-dax-logical-functions-2-6893991' width='923' height='642' src='https:\/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Power-BI-DAX-Logical-Functions-2-6893991.png' alt=\"Funciones l\u00f3gicas de Power BI DAX 2\" class=\"wp-image-32776\" srcset='\/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Power-BI-DAX-Logical-Functions-2-6893991.png 923w, \/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Power-BI-DAX-Logical-Functions-2-6893991-300x209.png 300w, \/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Power-BI-DAX-Logical-Functions-2-6893991-768x534.png 768w' sizes='(max-width: 923px) 100vw, 923px'\/><\/noscript><\/figure>\n<p><a href=\"https:\/\/rmarketingdigital.com\/powerbi\/como-cambiar-el-nombre-de-las-columnas-en-power-bi\/\">Cambiamos el nombre de la columna<\/a> predeterminada como IfExample. Como puede ver en la captura de pantalla siguiente, mientras escrib\u00eda, Power BI IntelliSense muestra las sugerencias.<\/p>\n<p>Para el prop\u00f3sito de demostraci\u00f3n de Power BI DAX Logical Functions, usamos la columna Ventas.<\/p>\n<figure class=\"wp-block-image\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-32777\" src=\"https:\/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Power-BI-DAX-Logical-Functions-3-6032797.png\" srcset=\"\/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Power-BI-DAX-Logical-Functions-3-6032797.png 923w, \/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Power-BI-DAX-Logical-Functions-3-6032797-300x208.png 300w, \/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Power-BI-DAX-Logical-Functions-3-6032797-768x533.png 768w\" alt=\"power-bi-dax-logical-functions-3-6032797\" width=\"923\" height=\"641\" data-lazy-sizes=\"(max-width: 923px) 100vw, 923px\" \/><noscript><img alt='power-bi-dax-logical-functions-3-6032797' width='923' height='641' src='https:\/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Power-BI-DAX-Logical-Functions-3-6032797.png' alt=\"Funciones l\u00f3gicas de Power BI DAX 3\" class=\"wp-image-32777\" srcset='\/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Power-BI-DAX-Logical-Functions-3-6032797.png 923w, \/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Power-BI-DAX-Logical-Functions-3-6032797-300x208.png 300w, \/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Power-BI-DAX-Logical-Functions-3-6032797-768x533.png 768w' sizes='(max-width: 923px) 100vw, 923px'\/><\/noscript><\/figure>\n<p>Al hacer clic en Intro o en cualquier tecla, se crea una nueva columna. Y el C\u00f3digo final es<\/p>\n<pre class=\"wp-block-preformatted lang:tsql decode:true\">IfExample = IF(EmployeeSales[Sales] &gt; 3000, \"Good\", \"Bad\")<\/pre>\n<p>La funci\u00f3n IF de Power BI DAX anterior verifica si el monto de Ventas de cada columna es mayor que 3000 o no. Si es verdadero, la columna devuelve Bueno; de lo contrario, devuelve Bad.<\/p>\n<figure class=\"wp-block-image\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-32778\" src=\"https:\/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Power-BI-DAX-Logical-Functions-4-6359607.png\" srcset=\"\/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Power-BI-DAX-Logical-Functions-4-6359607.png 923w, \/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Power-BI-DAX-Logical-Functions-4-6359607-300x208.png 300w, \/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Power-BI-DAX-Logical-Functions-4-6359607-768x533.png 768w\" alt=\"power-bi-dax-logical-functions-4-6359607\" width=\"923\" height=\"641\" data-lazy-sizes=\"(max-width: 923px) 100vw, 923px\" \/><noscript><img alt='power-bi-dax-logical-functions-4-6359607' width='923' height='641' src='https:\/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Power-BI-DAX-Logical-Functions-4-6359607.png' alt=\"Funciones 1 de Power BI DAX IF\" class=\"wp-image-32778\" srcset='\/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Power-BI-DAX-Logical-Functions-4-6359607.png 923w, \/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Power-BI-DAX-Logical-Functions-4-6359607-300x208.png 300w, \/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Power-BI-DAX-Logical-Functions-4-6359607-768x533.png 768w' sizes='(max-width: 923px) 100vw, 923px'\/><\/noscript><\/figure>\n<p>Perm\u00edtanme <a href=\"https:\/\/rmarketingdigital.com\/powerbi\/agregar-columna-condicional-en-power-bi\/\">agregar esta columna<\/a> 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-32779\" src=\"https:\/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Power-BI-DAX-Logical-Functions-5-4606836.png\" srcset=\"\/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Power-BI-DAX-Logical-Functions-5-4606836.png 970w, \/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Power-BI-DAX-Logical-Functions-5-4606836-300x186.png 300w, \/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Power-BI-DAX-Logical-Functions-5-4606836-768x475.png 768w\" alt=\"power-bi-dax-logical-functions-5-4606836\" width=\"970\" height=\"600\" data-lazy-sizes=\"(max-width: 970px) 100vw, 970px\" \/><noscript><img alt='power-bi-dax-logical-functions-5-4606836' width='970' height='600' src='https:\/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Power-BI-DAX-Logical-Functions-5-4606836.png' alt=\"Funciones 5 de Power BI DAX IF\" class=\"wp-image-32779\" srcset='\/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Power-BI-DAX-Logical-Functions-5-4606836.png 970w, \/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Power-BI-DAX-Logical-Functions-5-4606836-300x186.png 300w, \/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Power-BI-DAX-Logical-Functions-5-4606836-768x475.png 768w' sizes='(max-width: 970px) 100vw, 970px'\/><\/noscript><\/figure>\n<h3><span class=\"ez-toc-section\" id=\"Funcion-IF-anidada-de-Power-BI-DAX\"><\/span>Funci\u00f3n IF anidada de Power BI DAX<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p>En Power BI, puede usar el concepto If anidado de DAX. Quiero decir, una declaraci\u00f3n If dentro de otra. La siguiente funci\u00f3n IF anidada de Power BI DAX comprueba si el importe de ventas de cada columna es inferior a 1000 o no. Si es verdadero, la columna devuelve Muy malo; de lo contrario, entra en Anidado si<\/p>\n<pre class=\"wp-block-preformatted lang:tsql decode:true\">NestedIfEx = IF(EmployeeSales[Sales] &lt; 1000, \"Very Bad\",                                           \r\n                 IF(EmployeeSales[Sales] &gt; 3000, \"Good\", \"Average\" ))<\/pre>\n<figure class=\"wp-block-image\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-32780\" src=\"https:\/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Power-BI-DAX-Logical-Functions-6-6843590.png\" srcset=\"\/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Power-BI-DAX-Logical-Functions-6-6843590.png 954w, \/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Power-BI-DAX-Logical-Functions-6-6843590-300x186.png 300w, \/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Power-BI-DAX-Logical-Functions-6-6843590-768x477.png 768w\" alt=\"power-bi-dax-logical-functions-6-6843590\" width=\"954\" height=\"593\" data-lazy-sizes=\"(max-width: 954px) 100vw, 954px\" \/><noscript><img alt='power-bi-dax-logical-functions-6-6843590' width='954' height='593' src='https:\/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Power-BI-DAX-Logical-Functions-6-6843590.png' alt=\"Funciones 6 de Power BI DAX IF\" class=\"wp-image-32780\" srcset='\/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Power-BI-DAX-Logical-Functions-6-6843590.png 954w, \/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Power-BI-DAX-Logical-Functions-6-6843590-300x186.png 300w, \/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Power-BI-DAX-Logical-Functions-6-6843590-768x477.png 768w' sizes='(max-width: 954px) 100vw, 954px'\/><\/noscript><\/figure>\n<p>Perm\u00edtanme agregar esta columna anidada a esta tabla.<\/p>\n<figure class=\"wp-block-image\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-32781\" src=\"https:\/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Power-BI-DAX-Logical-Functions-7-6135302.png\" srcset=\"\/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Power-BI-DAX-Logical-Functions-7-6135302.png 954w, \/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Power-BI-DAX-Logical-Functions-7-6135302-300x186.png 300w, \/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Power-BI-DAX-Logical-Functions-7-6135302-768x477.png 768w\" alt=\"power-bi-dax-logical-functions-7-6135302\" width=\"954\" height=\"593\" data-lazy-sizes=\"(max-width: 954px) 100vw, 954px\" \/><noscript><img alt='power-bi-dax-logical-functions-7-6135302' width='954' height='593' src='https:\/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Power-BI-DAX-Logical-Functions-7-6135302.png' alt=\"Funciones 7 de Power BI DAX IF\" class=\"wp-image-32781\" srcset='\/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Power-BI-DAX-Logical-Functions-7-6135302.png 954w, \/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Power-BI-DAX-Logical-Functions-7-6135302-300x186.png 300w, \/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Power-BI-DAX-Logical-Functions-7-6135302-768x477.png 768w' sizes='(max-width: 954px) 100vw, 954px'\/><\/noscript><\/figure>\n<h3><span class=\"ez-toc-section\" id=\"Funcion-DAX-AND-de-Power-BI\"><\/span>Funci\u00f3n DAX AND de Power BI<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p>La funci\u00f3n DAX AND de Power BI comprueba varias expresiones. La sintaxis de la funci\u00f3n AND de Power BI DAX es<\/p>\n<pre class=\"wp-block-preformatted lang:tsql decode:true\">AND(Condition 1, Condition 2)<\/pre>\n<p>Como puede ver en la sintaxis anterior, la funci\u00f3n DAX AND de Power BI acepta dos argumentos: si ambas condiciones son True, devuelve True. De lo contrario, devuelve False.<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; min-height: 250px; min-width: 300px;\"><\/span><\/p>\n<p>Perm\u00edtanme crear una columna para verificar si las ventas de cada columna son mayores que el promedio y el ingreso anual es mayor que 70000. Si ambas condiciones son verdaderas, entonces la columna devuelve un buen trabajo. De lo contrario, devuelve Bad Job en una columna<\/p>\n<pre class=\"wp-block-preformatted lang:tsql decode:true\">AndSales = IF(AND(EmployeeSales[Sales] &gt; AVERAGE(EmployeeSales[Sales]),                              \r\n               EmployeeSales[YearlyIncome] &gt;= 70000), \"Good Job\", \"Bad Job\")<\/pre>\n<figure class=\"wp-block-image\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-32782\" src=\"https:\/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Power-BI-DAX-Logical-Functions-8-4116668.png\" srcset=\"\/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Power-BI-DAX-Logical-Functions-8-4116668.png 954w, \/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Power-BI-DAX-Logical-Functions-8-4116668-300x187.png 300w, \/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Power-BI-DAX-Logical-Functions-8-4116668-768x479.png 768w\" alt=\"power-bi-dax-logical-functions-8-4116668\" width=\"954\" height=\"595\" data-lazy-sizes=\"(max-width: 954px) 100vw, 954px\" \/><noscript><img alt='power-bi-dax-logical-functions-8-4116668' width='954' height='595' src='https:\/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Power-BI-DAX-Logical-Functions-8-4116668.png' alt=\"Power BI DAX y funciones 8\" class=\"wp-image-32782\" srcset='\/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Power-BI-DAX-Logical-Functions-8-4116668.png 954w, \/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Power-BI-DAX-Logical-Functions-8-4116668-300x187.png 300w, \/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Power-BI-DAX-Logical-Functions-8-4116668-768x479.png 768w' sizes='(max-width: 954px) 100vw, 954px'\/><\/noscript><\/figure>\n<h3><span class=\"ez-toc-section\" id=\"Funcion-Power-BI-DAX-OR\"><\/span>Funci\u00f3n Power BI DAX OR<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p>La funci\u00f3n Power BI DAX OR es como una instrucci\u00f3n or en ingl\u00e9s, que es \u00fatil para comprobar varias expresiones. La sintaxis de la funci\u00f3n Power BI DAX OR es<\/p>\n<pre class=\"wp-block-preformatted lang:tsql decode:true\">OR(Condition 1, Condition 2)<\/pre>\n<p>Como puede ver en la sintaxis de la funci\u00f3n Power BI DAX OR anterior: si ambas condiciones son False, entonces devuelve False; de lo contrario, devuelve True.<\/p>\n<p>Perm\u00edtanme crear una columna para verificar si las ventas son menores que el promedio o el ingreso anual es mayor que igual a 90000. Si ambas condiciones son falsas, la funci\u00f3n devuelve Doing Good; de lo contrario, devuelve la lista de seguimiento en una columna<\/p>\n<pre class=\"wp-block-preformatted lang:tsql decode:true\">OrSales = IF(OR(EmployeeSales[Sales] &lt; AVERAGE(EmployeeSales[Sales]),                              \r\n               EmployeeSales[YearlyIncome] &gt;= 90000), \"Watchlist\", \"Doing Good\")<\/pre>\n<figure class=\"wp-block-image\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-32783\" src=\"https:\/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Power-BI-DAX-Logical-Functions-9-6713920.png\" srcset=\"\/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Power-BI-DAX-Logical-Functions-9-6713920.png 966w, \/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Power-BI-DAX-Logical-Functions-9-6713920-300x184.png 300w, \/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Power-BI-DAX-Logical-Functions-9-6713920-768x471.png 768w\" alt=\"power-bi-dax-logical-functions-9-6713920\" width=\"966\" height=\"593\" data-lazy-sizes=\"(max-width: 966px) 100vw, 966px\" \/><noscript><img alt='power-bi-dax-logical-functions-9-6713920' width='966' height='593' src='https:\/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Power-BI-DAX-Logical-Functions-9-6713920.png' alt=\"Funciones de Power BI DAX OR 9\" class=\"wp-image-32783\" srcset='\/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Power-BI-DAX-Logical-Functions-9-6713920.png 966w, \/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Power-BI-DAX-Logical-Functions-9-6713920-300x184.png 300w, \/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Power-BI-DAX-Logical-Functions-9-6713920-768x471.png 768w' sizes='(max-width: 966px) 100vw, 966px'\/><\/noscript><\/figure>\n<p>Perm\u00edtanme agregar las columnas And Function y Or Function a la tabla que se muestra a continuaci\u00f3n.<\/p>\n<figure class=\"wp-block-image\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-32784\" src=\"https:\/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Power-BI-DAX-Logical-Functions-10-7666413.png\" srcset=\"\/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Power-BI-DAX-Logical-Functions-10-7666413.png 966w, \/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Power-BI-DAX-Logical-Functions-10-7666413-300x184.png 300w, \/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Power-BI-DAX-Logical-Functions-10-7666413-768x472.png 768w\" alt=\"power-bi-dax-logical-functions-10-7666413\" width=\"966\" height=\"594\" data-lazy-sizes=\"(max-width: 966px) 100vw, 966px\" \/><noscript><img alt='power-bi-dax-logical-functions-10-7666413' width='966' height='594' src='https:\/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Power-BI-DAX-Logical-Functions-10-7666413.png' alt=\"Funciones de Power BI DAX AND OR 10\" class=\"wp-image-32784\" srcset='\/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Power-BI-DAX-Logical-Functions-10-7666413.png 966w, \/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Power-BI-DAX-Logical-Functions-10-7666413-300x184.png 300w, \/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Power-BI-DAX-Logical-Functions-10-7666413-768x472.png 768w' sizes='(max-width: 966px) 100vw, 966px'\/><\/noscript><\/figure>\n<h3><span class=\"ez-toc-section\" id=\"Funcion-Power-BI-DAX-NOT\"><\/span>Funci\u00f3n Power BI DAX NOT<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p>La funci\u00f3n NO de Power BI DAX convierte Verdadero en falso y Falso en Verdadero. Quiero decir, devuelve el resultado opuesto. La sintaxis de la funci\u00f3n Power BI DAX NOT es<\/p>\n<pre class=\"wp-block-preformatted lang:tsql decode:true\">NOT(Condition)<\/pre>\n<p>La siguiente declaraci\u00f3n devuelve False si las ventas son superiores a 2000; de lo contrario, devuelve True.<\/p>\n<pre class=\"wp-block-preformatted lang:tsql decode:true\">NotSale = NOT(IF(EmployeeSales[Sales] &gt; 2000, \"TRUE\", \"FALSE\")<\/pre>\n<figure class=\"wp-block-image\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-32785\" src=\"https:\/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Power-BI-DAX-Logical-Functions-11-6054603.png\" srcset=\"\/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Power-BI-DAX-Logical-Functions-11-6054603.png 981w, \/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Power-BI-DAX-Logical-Functions-11-6054603-300x200.png 300w, \/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Power-BI-DAX-Logical-Functions-11-6054603-768x511.png 768w, \/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Power-BI-DAX-Logical-Functions-11-6054603-900x600.png 900w\" alt=\"power-bi-dax-logical-functions-11-6054603\" width=\"981\" height=\"653\" data-lazy-sizes=\"(max-width: 981px) 100vw, 981px\" \/><noscript><img alt='power-bi-dax-logical-functions-11-6054603' width='981' height='653' src='https:\/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Power-BI-DAX-Logical-Functions-11-6054603.png' alt=\"Funciones NO de Power BI DAX 11\" class=\"wp-image-32785\" srcset='\/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Power-BI-DAX-Logical-Functions-11-6054603.png 981w, \/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Power-BI-DAX-Logical-Functions-11-6054603-300x200.png 300w, \/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Power-BI-DAX-Logical-Functions-11-6054603-768x511.png 768w, \/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Power-BI-DAX-Logical-Functions-11-6054603-900x600.png 900w' sizes='(max-width: 981px) 100vw, 981px'\/><\/noscript><\/figure>\n<p>Perm\u00edtanme agregar esta columna No funci\u00f3n a esta tabla<\/p>\n<figure class=\"wp-block-image\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-32786\" src=\"https:\/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Power-BI-DAX-Logical-Functions-12-5066218.png\" srcset=\"\/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Power-BI-DAX-Logical-Functions-12-5066218.png 979w, \/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Power-BI-DAX-Logical-Functions-12-5066218-300x183.png 300w, \/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Power-BI-DAX-Logical-Functions-12-5066218-768x468.png 768w\" alt=\"power-bi-dax-logical-functions-12-5066218\" width=\"979\" height=\"596\" data-lazy-sizes=\"(max-width: 979px) 100vw, 979px\" \/><noscript><img alt='power-bi-dax-logical-functions-12-5066218' width='979' height='596' src='https:\/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Power-BI-DAX-Logical-Functions-12-5066218.png' alt=\"Funci\u00f3n Power BI DAX NOT 12\" class=\"wp-image-32786\" srcset='\/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Power-BI-DAX-Logical-Functions-12-5066218.png 979w, \/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Power-BI-DAX-Logical-Functions-12-5066218-300x183.png 300w, \/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Power-BI-DAX-Logical-Functions-12-5066218-768x468.png 768w' sizes='(max-width: 979px) 100vw, 979px'\/><\/noscript><\/figure>\n<h3><span class=\"ez-toc-section\" id=\"Funcion-Power-BI-DAX-IN\"><\/span>Funci\u00f3n Power BI DAX IN<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p>La funci\u00f3n Power BI DAX IN restringe el c\u00e1lculo a columnas especificadas. Por ejemplo, puede calcular la suma de las ventas de los empleados temporales. La sintaxis de la funci\u00f3n Power BI DAX IN es la que se muestra a continuaci\u00f3n:<\/p>\n<pre class=\"wp-block-preformatted lang:tsql decode:true\">Column IN {field1, field2,...,fieldN}<\/pre>\n<p>La siguiente declaraci\u00f3n calcula la Suma de Ventas para los empleados cuya educaci\u00f3n es Educaci\u00f3n, Licenciatura o Maestr\u00eda. Recuerde, esta es una medida<\/p>\n<pre class=\"wp-block-preformatted lang:tsql decode:true\">SalesIN =  CALCULATE(SUM(EmployeeSales[YearlyIncome]) , \r\n        'EmployeeSales'[Education] IN {\"Education\", \"Bachelors\", \"Masters Degree\"})<\/pre>\n<figure class=\"wp-block-image\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-32787\" src=\"https:\/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Power-BI-DAX-Logical-Functions-13-8390946.png\" srcset=\"\/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Power-BI-DAX-Logical-Functions-13-8390946.png 1024w, \/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Power-BI-DAX-Logical-Functions-13-8390946-300x210.png 300w, \/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Power-BI-DAX-Logical-Functions-13-8390946-768x537.png 768w\" alt=\"power-bi-dax-logical-functions-13-8390946\" width=\"1024\" height=\"716\" data-lazy-sizes=\"(max-width: 1024px) 100vw, 1024px\" \/><noscript><img alt='power-bi-dax-logical-functions-13-8390946' width='1024' height='716' src='https:\/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Power-BI-DAX-Logical-Functions-13-8390946.png' alt=\"Funci\u00f3n 13 de Power BI DAX IN\" class=\"wp-image-32787\" srcset='\/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Power-BI-DAX-Logical-Functions-13-8390946.png 1024w, \/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Power-BI-DAX-Logical-Functions-13-8390946-300x210.png 300w, \/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Power-BI-DAX-Logical-Functions-13-8390946-768x537.png 768w' sizes='(max-width: 1024px) 100vw, 1024px'\/><\/noscript><\/figure>\n<p>Perm\u00edtanme crear una tarjeta usando esta medida. Consulte los art\u00edculos Crear una tarjeta y Formatear tarjeta para comprender los pasos necesarios para crear y formatear tarjetas.<\/p>\n<figure class=\"wp-block-image\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-32788\" src=\"https:\/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Power-BI-DAX-Logical-Functions-14-4239816.png\" srcset=\"\/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Power-BI-DAX-Logical-Functions-14-4239816.png 1026w, \/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Power-BI-DAX-Logical-Functions-14-4239816-300x187.png 300w, \/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Power-BI-DAX-Logical-Functions-14-4239816-1024x638.png 1024w, \/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Power-BI-DAX-Logical-Functions-14-4239816-768x478.png 768w\" alt=\"power-bi-dax-logical-functions-14-4239816\" width=\"1026\" height=\"639\" data-lazy-sizes=\"(max-width: 1026px) 100vw, 1026px\" \/><noscript><img alt='power-bi-dax-logical-functions-14-4239816' width='1026' height='639' src='https:\/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Power-BI-DAX-Logical-Functions-14-4239816.png' alt=\"Funci\u00f3n 14 de Power BI DAX IN\" class=\"wp-image-32788\" srcset='\/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Power-BI-DAX-Logical-Functions-14-4239816.png 1026w, \/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Power-BI-DAX-Logical-Functions-14-4239816-300x187.png 300w, \/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Power-BI-DAX-Logical-Functions-14-4239816-1024x638.png 1024w, \/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Power-BI-DAX-Logical-Functions-14-4239816-768x478.png 768w' sizes='(max-width: 1026px) 100vw, 1026px'\/><\/noscript><\/figure>\n<h3><span class=\"ez-toc-section\" id=\"Funcion-Power-BI-DAX-TRUE\"><\/span>Funci\u00f3n Power BI DAX TRUE<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p>La funci\u00f3n Power BI DAX TRUE devuelve un valor l\u00f3gico verdadero. La siguiente declaraci\u00f3n devuelve Verdadero si las ventas son mayores que la venta promedio; de lo contrario, devuelve False<\/p>\n<pre class=\"wp-block-preformatted lang:tsql decode:true\">TRUESale = IF(EmployeeSales[Sales] &gt; AVERAGE(EmployeeSales[Sales]), TRUE(), FALSE() )<\/pre>\n<figure class=\"wp-block-image\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-32789\" src=\"https:\/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Power-BI-DAX-Logical-Functions-15-2818370.png\" srcset=\"\/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Power-BI-DAX-Logical-Functions-15-2818370.png 966w, \/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Power-BI-DAX-Logical-Functions-15-2818370-300x204.png 300w, \/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Power-BI-DAX-Logical-Functions-15-2818370-768x522.png 768w\" alt=\"power-bi-dax-logical-functions-15-2818370\" width=\"966\" height=\"657\" data-lazy-sizes=\"(max-width: 966px) 100vw, 966px\" \/><noscript><img alt='power-bi-dax-logical-functions-15-2818370' width='966' height='657' src='https:\/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Power-BI-DAX-Logical-Functions-15-2818370.png' alt=\"Funci\u00f3n 15 de Power BI DAX TRUE\" class=\"wp-image-32789\" srcset='\/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Power-BI-DAX-Logical-Functions-15-2818370.png 966w, \/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Power-BI-DAX-Logical-Functions-15-2818370-300x204.png 300w, \/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Power-BI-DAX-Logical-Functions-15-2818370-768x522.png 768w' sizes='(max-width: 966px) 100vw, 966px'\/><\/noscript><\/figure>\n<h3><span class=\"ez-toc-section\" id=\"Funcion-FALSE-de-Power-BI-DAX\"><\/span>Funci\u00f3n FALSE de Power BI DAX<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p>La funci\u00f3n Power BI DAX FALSE devuelve un falso l\u00f3gico. El siguiente c\u00f3digo devuelve False si las ventas son inferiores a 2500. De lo contrario, devuelve True<\/p>\n<pre class=\"wp-block-preformatted lang:tsql decode:true\">FalseSale = IF(EmployeeSales[Sales] &lt; 2500, FALSE(), TRUE() )<\/pre>\n<figure class=\"wp-block-image\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-32790\" src=\"https:\/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Power-BI-DAX-Logical-Functions-16-6116148.png\" srcset=\"\/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Power-BI-DAX-Logical-Functions-16-6116148.png 966w, \/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Power-BI-DAX-Logical-Functions-16-6116148-300x204.png 300w, \/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Power-BI-DAX-Logical-Functions-16-6116148-768x522.png 768w\" alt=\"power-bi-dax-logical-functions-16-6116148\" width=\"966\" height=\"656\" data-lazy-sizes=\"(max-width: 966px) 100vw, 966px\" \/><noscript><img alt='power-bi-dax-logical-functions-16-6116148' width='966' height='656' src='https:\/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Power-BI-DAX-Logical-Functions-16-6116148.png' alt=\"Funci\u00f3n 16 de FALSO de DAX de Power BI\" class=\"wp-image-32790\" srcset='\/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Power-BI-DAX-Logical-Functions-16-6116148.png 966w, \/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Power-BI-DAX-Logical-Functions-16-6116148-300x204.png 300w, \/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Power-BI-DAX-Logical-Functions-16-6116148-768x522.png 768w' sizes='(max-width: 966px) 100vw, 966px'\/><\/noscript><\/figure>\n<p>Perm\u00edtanme agregar funci\u00f3n verdadera, resultado de funci\u00f3n falsa al informe de la tabla<\/p>\n<figure class=\"wp-block-image\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-32791\" src=\"https:\/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Power-BI-DAX-Logical-Functions-17-4894028.png\" srcset=\"\/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Power-BI-DAX-Logical-Functions-17-4894028.png 966w, \/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Power-BI-DAX-Logical-Functions-17-4894028-300x204.png 300w, \/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Power-BI-DAX-Logical-Functions-17-4894028-768x522.png 768w\" alt=\"power-bi-dax-logical-functions-17-4894028\" width=\"966\" height=\"657\" data-lazy-sizes=\"(max-width: 966px) 100vw, 966px\" \/><noscript><img alt='power-bi-dax-logical-functions-17-4894028' width='966' height='657' src='https:\/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Power-BI-DAX-Logical-Functions-17-4894028.png' alt=\"Funciones TRUE Y FALSE de Power BI DAX 17\" class=\"wp-image-32791\" srcset='\/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Power-BI-DAX-Logical-Functions-17-4894028.png 966w, \/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Power-BI-DAX-Logical-Functions-17-4894028-300x204.png 300w, \/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Power-BI-DAX-Logical-Functions-17-4894028-768x522.png 768w' sizes='(max-width: 966px) 100vw, 966px'\/><\/noscript><\/figure>\n<h3><span class=\"ez-toc-section\" id=\"Funcion-IFERROR-de-Power-BI-DAX\"><\/span>Funci\u00f3n IFERROR de Power BI DAX<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p>La funci\u00f3n Power BI DAX IFERROR es muy \u00fatil para controlar el desbordamiento aritm\u00e9tico o cualquier otro error. Simplemente realiza el c\u00e1lculo y devuelve el resultado, si hay un error, devuelve el valor dentro del segundo argumento.<\/p>\n<p>La sintaxis de la funci\u00f3n Power BI DAX IFERROR es<\/p>\n<pre class=\"wp-block-preformatted lang:tsql decode:true\">IFERROR(Calculation, Value_If_Error_Occurs)<\/pre>\n<p>La siguiente declaraci\u00f3n devuelve 100 si ocurre un error. De hecho, todos los registros arrojan un error porque los estamos dividiendo 0<\/p>\n<pre class=\"wp-block-preformatted lang:tsql decode:true\">ErrorSale = IFERROR(EmployeeSales[Sales]\/0, 100)<\/pre>\n<figure class=\"wp-block-image\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-32792\" src=\"https:\/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Power-BI-DAX-Logical-Functions-18-6191106.png\" srcset=\"\/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Power-BI-DAX-Logical-Functions-18-6191106.png 1018w, \/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Power-BI-DAX-Logical-Functions-18-6191106-300x193.png 300w, \/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Power-BI-DAX-Logical-Functions-18-6191106-768x494.png 768w\" alt=\"power-bi-dax-logical-functions-18-6191106\" width=\"1018\" height=\"655\" data-lazy-sizes=\"(max-width: 1018px) 100vw, 1018px\" \/><noscript><img alt='power-bi-dax-logical-functions-18-6191106' width='1018' height='655' src='https:\/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Power-BI-DAX-Logical-Functions-18-6191106.png' alt=\"Funci\u00f3n 18 de Power BI DAX IFERROR\" class=\"wp-image-32792\" srcset='\/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Power-BI-DAX-Logical-Functions-18-6191106.png 1018w, \/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Power-BI-DAX-Logical-Functions-18-6191106-300x193.png 300w, \/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Power-BI-DAX-Logical-Functions-18-6191106-768x494.png 768w' sizes='(max-width: 1018px) 100vw, 1018px'\/><\/noscript><\/figure>\n<p>Perm\u00edtanme agregar el resultado de la columna Iferror al informe de la tabla<\/p>\n<figure class=\"wp-block-image\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-32793\" src=\"https:\/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Power-BI-DAX-Logical-Functions-19-1584732.png\" srcset=\"\/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Power-BI-DAX-Logical-Functions-19-1584732.png 1015w, \/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Power-BI-DAX-Logical-Functions-19-1584732-300x189.png 300w, \/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Power-BI-DAX-Logical-Functions-19-1584732-768x483.png 768w\" alt=\"power-bi-dax-logical-functions-19-1584732\" width=\"1015\" height=\"638\" data-lazy-sizes=\"(max-width: 1015px) 100vw, 1015px\" \/><noscript><img alt='power-bi-dax-logical-functions-19-1584732' width='1015' height='638' src='https:\/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Power-BI-DAX-Logical-Functions-19-1584732.png' alt=\"Funci\u00f3n IFERROR de Power BI DAX 19\" class=\"wp-image-32793\" srcset='\/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Power-BI-DAX-Logical-Functions-19-1584732.png 1015w, \/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Power-BI-DAX-Logical-Functions-19-1584732-300x189.png 300w, \/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Power-BI-DAX-Logical-Functions-19-1584732-768x483.png 768w' sizes='(max-width: 1015px) 100vw, 1015px'\/><\/noscript><\/figure>\n<h3><span class=\"ez-toc-section\" id=\"Funcion-SWITCH-de-Power-BI-DAX\"><\/span>Funci\u00f3n SWITCH de Power BI DAX<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p>La funci\u00f3n SWITCH de Power BI DAX le ayuda a devolver m\u00faltiples opciones. Por ejemplo, la funci\u00f3n Power BI DAX IF devuelve True o false. Sin embargo, puede utilizar este caso de cambio para obtener varios resultados.<\/p>\n<p>La sintaxis de la funci\u00f3n de cambio de Power BI DAX es como se muestra a continuaci\u00f3n:<\/p>\n<pre class=\"wp-block-preformatted lang:tsql decode:true\">SWITCH(Expression, Option 1, Result 1, Option 2, Result 2, ....., ElseResult)<\/pre>\n<p>Si la fecha del mes de contrataci\u00f3n es 1, la declaraci\u00f3n de abajo devuelve enero, 2 significa febrero, 3 significa marzo, 4 significa abril, 5 significa mayo, 12 significa diciembre de lo contrario, desconocido.<\/p>\n<pre class=\"wp-block-preformatted lang:tsql decode:true\">SwitchMonth = SWITCH(MONTH(EmployeeSales[HireDate]), 1, \"January\", 2, \"February\", 3, \"March\", 4, \"April\", 5, \"May\", \r\n                 12, \"December\", \"Unknown\")<\/pre>\n<figure class=\"wp-block-image\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-32794\" src=\"https:\/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Power-BI-DAX-Logical-Functions-20-7357702.png\" srcset=\"\/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Power-BI-DAX-Logical-Functions-20-7357702.png 1053w, \/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Power-BI-DAX-Logical-Functions-20-7357702-300x190.png 300w, \/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Power-BI-DAX-Logical-Functions-20-7357702-1024x650.png 1024w, \/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Power-BI-DAX-Logical-Functions-20-7357702-768x487.png 768w\" alt=\"power-bi-dax-logical-functions-20-7357702\" width=\"1053\" height=\"668\" data-lazy-sizes=\"(max-width: 1053px) 100vw, 1053px\" \/><noscript><img alt='power-bi-dax-logical-functions-20-7357702' width='1053' height='668' src='https:\/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Power-BI-DAX-Logical-Functions-20-7357702.png' alt=\"Funci\u00f3n SWITCH de Power BI DAX 20\" class=\"wp-image-32794\" srcset='\/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Power-BI-DAX-Logical-Functions-20-7357702.png 1053w, \/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Power-BI-DAX-Logical-Functions-20-7357702-300x190.png 300w, \/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Power-BI-DAX-Logical-Functions-20-7357702-1024x650.png 1024w, \/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Power-BI-DAX-Logical-Functions-20-7357702-768x487.png 768w' sizes='(max-width: 1053px) 100vw, 1053px'\/><\/noscript><\/figure>\n<p>Perm\u00edtanme agregar esta columna de resultado de la funci\u00f3n Power BI DAX Switch a este informe de tabla<\/p>\n<figure class=\"wp-block-image\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-32795\" src=\"https:\/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Power-BI-DAX-Logical-Functions-21-9019250.png\" srcset=\"\/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Power-BI-DAX-Logical-Functions-21-9019250.png 1053w, \/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Power-BI-DAX-Logical-Functions-21-9019250-300x190.png 300w, \/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Power-BI-DAX-Logical-Functions-21-9019250-1024x650.png 1024w, \/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Power-BI-DAX-Logical-Functions-21-9019250-768x487.png 768w\" alt=\"power-bi-dax-logical-functions-21-9019250\" width=\"1053\" height=\"668\" data-lazy-sizes=\"(max-width: 1053px) 100vw, 1053px\" \/><noscript><img alt='power-bi-dax-logical-functions-21-5769477' width='1053' height='668' src='https:\/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Power-BI-DAX-Logical-Functions-21-5769477.png' alt=\"Funci\u00f3n SWITCH de Power BI DAX 21\" class=\"wp-image-32795\" srcset='\/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Power-BI-DAX-Logical-Functions-21-5769477.png 1053w, \/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Power-BI-DAX-Logical-Functions-21-5769477-300x190.png 300w, \/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Power-BI-DAX-Logical-Functions-21-5769477-1024x650.png 1024w, \/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Power-BI-DAX-Logical-Functions-21-5769477-768x487.png 768w' sizes='(max-width: 1053px) 100vw, 1053px'\/><\/noscript><\/figure>\n<\/div>\n","protected":false},"excerpt":{"rendered":"<p>How to use Power BI DAX logic functions with examples? Microsoft Power BI DAX provides several logical functions, such as IF, AND, OR, NOT, IN, TRUE, FALSE, IFERROR, SWITCH,\u2026<\/p>","protected":false},"author":1,"featured_media":84134,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[1359,1360],"tags":[],"class_list":["post-84137","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 l\u00f3gicas de Power BI DAX - R Marketing Digital<\/title>\n<meta name=\"description\" content=\"\u00bfC\u00f3mo usar las funciones l\u00f3gicas de Power BI DAX con ejemplos? Microsoft Power BI DAX proporciona varias funciones l\u00f3gicas, como instrucci\u00f3n IF, AND, OR,\" \/>\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-logicas-de-power-bi-dax\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Funciones l\u00f3gicas de Power BI DAX\" \/>\n<meta property=\"og:description\" content=\"\u00bfC\u00f3mo usar las funciones l\u00f3gicas de Power BI DAX con ejemplos? Microsoft Power BI DAX proporciona varias funciones l\u00f3gicas, como instrucci\u00f3n IF, AND, OR,\" \/>\n<meta property=\"og:url\" content=\"https:\/\/rmarketingdigital.com\/en\/powerbi\/funciones-logicas-de-power-bi-dax\/\" \/>\n<meta property=\"og:site_name\" content=\"R Marketing Digital\" \/>\n<meta property=\"article:published_time\" content=\"2022-05-05T02:47:35+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Power-BI-DAX-Logical-Functions-20-3353902.png\" \/>\n\t<meta property=\"og:image:width\" content=\"1053\" \/>\n\t<meta property=\"og:image:height\" content=\"668\" \/>\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-logicas-de-power-bi-dax\\\/#article\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/rmarketingdigital.com\\\/powerbi\\\/funciones-logicas-de-power-bi-dax\\\/\"},\"author\":{\"name\":\"R Marketing Digital\",\"@id\":\"https:\\\/\\\/rmarketingdigital.com\\\/#\\\/schema\\\/person\\\/7c0d9782b2977b840b3740f00c69a73e\"},\"headline\":\"Funciones l\u00f3gicas de Power BI DAX\",\"datePublished\":\"2022-05-05T02:47:35+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\\\/\\\/rmarketingdigital.com\\\/powerbi\\\/funciones-logicas-de-power-bi-dax\\\/\"},\"wordCount\":1131,\"image\":{\"@id\":\"https:\\\/\\\/rmarketingdigital.com\\\/powerbi\\\/funciones-logicas-de-power-bi-dax\\\/#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/rmarketingdigital.com\\\/wp-content\\\/uploads\\\/2020\\\/09\\\/Power-BI-DAX-Logical-Functions-20-3353902.png\",\"articleSection\":[\"Power BI\",\"Tutoriales PowerBI\"],\"inLanguage\":\"en-US\"},{\"@type\":\"WebPage\",\"@id\":\"https:\\\/\\\/rmarketingdigital.com\\\/powerbi\\\/funciones-logicas-de-power-bi-dax\\\/\",\"url\":\"https:\\\/\\\/rmarketingdigital.com\\\/powerbi\\\/funciones-logicas-de-power-bi-dax\\\/\",\"name\":\"Funciones l\u00f3gicas de Power BI DAX - R Marketing Digital\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/rmarketingdigital.com\\\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\\\/\\\/rmarketingdigital.com\\\/powerbi\\\/funciones-logicas-de-power-bi-dax\\\/#primaryimage\"},\"image\":{\"@id\":\"https:\\\/\\\/rmarketingdigital.com\\\/powerbi\\\/funciones-logicas-de-power-bi-dax\\\/#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/rmarketingdigital.com\\\/wp-content\\\/uploads\\\/2020\\\/09\\\/Power-BI-DAX-Logical-Functions-20-3353902.png\",\"datePublished\":\"2022-05-05T02:47:35+00:00\",\"author\":{\"@id\":\"https:\\\/\\\/rmarketingdigital.com\\\/#\\\/schema\\\/person\\\/7c0d9782b2977b840b3740f00c69a73e\"},\"description\":\"\u00bfC\u00f3mo usar las funciones l\u00f3gicas de Power BI DAX con ejemplos? Microsoft Power BI DAX proporciona varias funciones l\u00f3gicas, como instrucci\u00f3n IF, AND, OR,\",\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\\\/\\\/rmarketingdigital.com\\\/powerbi\\\/funciones-logicas-de-power-bi-dax\\\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\\\/\\\/rmarketingdigital.com\\\/powerbi\\\/funciones-logicas-de-power-bi-dax\\\/#primaryimage\",\"url\":\"https:\\\/\\\/rmarketingdigital.com\\\/wp-content\\\/uploads\\\/2020\\\/09\\\/Power-BI-DAX-Logical-Functions-20-3353902.png\",\"contentUrl\":\"https:\\\/\\\/rmarketingdigital.com\\\/wp-content\\\/uploads\\\/2020\\\/09\\\/Power-BI-DAX-Logical-Functions-20-3353902.png\",\"width\":1053,\"height\":668,\"caption\":\"power-bi-dax-logical-functions-20-3353902-5445268-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":"Logical functions of Power BI DAX - R Marketing Digital","description":"How to use Power BI DAX logical functions with examples? Microsoft Power BI DAX provides several logical functions, such as IF, AND, OR,","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-logicas-de-power-bi-dax\/","og_locale":"en_US","og_type":"article","og_title":"Funciones l\u00f3gicas de Power BI DAX","og_description":"\u00bfC\u00f3mo usar las funciones l\u00f3gicas de Power BI DAX con ejemplos? Microsoft Power BI DAX proporciona varias funciones l\u00f3gicas, como instrucci\u00f3n IF, AND, OR,","og_url":"https:\/\/rmarketingdigital.com\/en\/powerbi\/funciones-logicas-de-power-bi-dax\/","og_site_name":"R Marketing Digital","article_published_time":"2022-05-05T02:47:35+00:00","og_image":[{"width":1053,"height":668,"url":"https:\/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Power-BI-DAX-Logical-Functions-20-3353902.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-logicas-de-power-bi-dax\/#article","isPartOf":{"@id":"https:\/\/rmarketingdigital.com\/powerbi\/funciones-logicas-de-power-bi-dax\/"},"author":{"name":"R Marketing Digital","@id":"https:\/\/rmarketingdigital.com\/#\/schema\/person\/7c0d9782b2977b840b3740f00c69a73e"},"headline":"Funciones l\u00f3gicas de Power BI DAX","datePublished":"2022-05-05T02:47:35+00:00","mainEntityOfPage":{"@id":"https:\/\/rmarketingdigital.com\/powerbi\/funciones-logicas-de-power-bi-dax\/"},"wordCount":1131,"image":{"@id":"https:\/\/rmarketingdigital.com\/powerbi\/funciones-logicas-de-power-bi-dax\/#primaryimage"},"thumbnailUrl":"https:\/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Power-BI-DAX-Logical-Functions-20-3353902.png","articleSection":["Power BI","Tutoriales PowerBI"],"inLanguage":"en-US"},{"@type":"WebPage","@id":"https:\/\/rmarketingdigital.com\/powerbi\/funciones-logicas-de-power-bi-dax\/","url":"https:\/\/rmarketingdigital.com\/powerbi\/funciones-logicas-de-power-bi-dax\/","name":"Logical functions of Power BI DAX - R Marketing Digital","isPartOf":{"@id":"https:\/\/rmarketingdigital.com\/#website"},"primaryImageOfPage":{"@id":"https:\/\/rmarketingdigital.com\/powerbi\/funciones-logicas-de-power-bi-dax\/#primaryimage"},"image":{"@id":"https:\/\/rmarketingdigital.com\/powerbi\/funciones-logicas-de-power-bi-dax\/#primaryimage"},"thumbnailUrl":"https:\/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Power-BI-DAX-Logical-Functions-20-3353902.png","datePublished":"2022-05-05T02:47:35+00:00","author":{"@id":"https:\/\/rmarketingdigital.com\/#\/schema\/person\/7c0d9782b2977b840b3740f00c69a73e"},"description":"How to use Power BI DAX logical functions with examples? Microsoft Power BI DAX provides several logical functions, such as IF, AND, OR,","inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/rmarketingdigital.com\/powerbi\/funciones-logicas-de-power-bi-dax\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/rmarketingdigital.com\/powerbi\/funciones-logicas-de-power-bi-dax\/#primaryimage","url":"https:\/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Power-BI-DAX-Logical-Functions-20-3353902.png","contentUrl":"https:\/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Power-BI-DAX-Logical-Functions-20-3353902.png","width":1053,"height":668,"caption":"power-bi-dax-logical-functions-20-3353902-5445268-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\/84137","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=84137"}],"version-history":[{"count":0,"href":"https:\/\/rmarketingdigital.com\/en\/wp-json\/wp\/v2\/posts\/84137\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/rmarketingdigital.com\/en\/wp-json\/wp\/v2\/media\/84134"}],"wp:attachment":[{"href":"https:\/\/rmarketingdigital.com\/en\/wp-json\/wp\/v2\/media?parent=84137"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/rmarketingdigital.com\/en\/wp-json\/wp\/v2\/categories?post=84137"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/rmarketingdigital.com\/en\/wp-json\/wp\/v2\/tags?post=84137"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}