{"id":84073,"date":"2022-08-20T02:50:51","date_gmt":"2022-08-20T00:50:51","guid":{"rendered":"https:\/\/rmarketingdigital.com\/powerbi\/funciones-matematicas-de-power-bi-dax\/"},"modified":"2020-09-17T05:48:00","modified_gmt":"2020-09-17T08:48:00","slug":"funciones-matematicas-de-power-bi-dax","status":"publish","type":"post","link":"https:\/\/rmarketingdigital.com\/en\/powerbi\/funciones-matematicas-de-power-bi-dax\/","title":{"rendered":"Power BI DAX math functions"},"content":{"rendered":"<div id=\"ez-toc-container\" class=\"ez-toc-v2_0_86 counter-hierarchy ez-toc-counter ez-toc-grey ez-toc-container-direction\">\n<div class=\"ez-toc-title-container\">\n<p class=\"ez-toc-title\" style=\"cursor:inherit\">Contenidos<\/p>\n<span class=\"ez-toc-title-toggle\"><a href=\"#\" class=\"ez-toc-pull-right ez-toc-btn ez-toc-btn-xs ez-toc-btn-default ez-toc-toggle\" aria-label=\"Toggle Table of Content\"><span class=\"ez-toc-js-icon-con\"><span class=\"\"><span class=\"eztoc-hide\" style=\"display:none;\">Toggle<\/span><span class=\"ez-toc-icon-toggle-span\"><svg style=\"fill: #999;color:#999\" xmlns=\"http:\/\/www.w3.org\/2000\/svg\" class=\"list-377408\" width=\"20px\" height=\"20px\" viewBox=\"0 0 24 24\" fill=\"none\"><path d=\"M6 6H4v2h2V6zm14 0H8v2h12V6zM4 11h2v2H4v-2zm16 0H8v2h12v-2zM4 16h2v2H4v-2zm16 0H8v2h12v-2z\" fill=\"currentColor\"><\/path><\/svg><svg style=\"fill: #999;color:#999\" class=\"arrow-unsorted-368013\" xmlns=\"http:\/\/www.w3.org\/2000\/svg\" width=\"10px\" height=\"10px\" viewBox=\"0 0 24 24\" version=\"1.2\" baseProfile=\"tiny\"><path d=\"M18.2 9.3l-6.2-6.3-6.2 6.3c-.2.2-.3.4-.3.7s.1.5.3.7c.2.2.4.3.7.3h11c.3 0 .5-.1.7-.3.2-.2.3-.5.3-.7s-.1-.5-.3-.7zM5.8 14.7l6.2 6.3 6.2-6.3c.2-.2.3-.5.3-.7s-.1-.5-.3-.7c-.2-.2-.4-.3-.7-.3h-11c-.3 0-.5.1-.7.3-.2.2-.3.5-.3.7s.1.5.3.7z\"\/><\/svg><\/span><\/span><\/span><\/a><\/span><\/div>\n<nav><ul class='ez-toc-list ez-toc-list-level-1 ' ><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-1\" href=\"https:\/\/rmarketingdigital.com\/en\/powerbi\/funciones-matematicas-de-power-bi-dax\/#Funciones-matematicas-de-Power-BI-DAX\" >Funciones matem\u00e1ticas 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-matematicas-de-power-bi-dax\/#Funcion-de-techo-de-Power-BI-DAX\" >Funci\u00f3n de techo 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-matematicas-de-power-bi-dax\/#Funcion-Power-BI-DAX-FLOOR\" >Funci\u00f3n Power BI DAX FLOOR<\/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-matematicas-de-power-bi-dax\/#Funcion-ROUND-de-Power-BI-DAX\" >Funci\u00f3n ROUND de Power BI DAX<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-5\" href=\"https:\/\/rmarketingdigital.com\/en\/powerbi\/funciones-matematicas-de-power-bi-dax\/#Funcion-Power-BI-DAX-CURRENCY\" >Funci\u00f3n Power BI DAX CURRENCY<\/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-matematicas-de-power-bi-dax\/#Funcion-Power-BI-DAX-INT\" >Funci\u00f3n Power BI DAX INT<\/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-matematicas-de-power-bi-dax\/#Funcion-Power-BI-DAX-SQRT\" >Funci\u00f3n Power BI DAX SQRT<\/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-matematicas-de-power-bi-dax\/#Funcion-Power-BI-DAX-SIGN\" >Funci\u00f3n Power BI DAX SIGN<\/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-matematicas-de-power-bi-dax\/#Funcion-Power-BI-DAX-EVEN\" >Funci\u00f3n Power BI DAX EVEN<\/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-matematicas-de-power-bi-dax\/#Funcion-ODD-de-Power-BI-DAX\" >Funci\u00f3n ODD 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-matematicas-de-power-bi-dax\/#Funcion-Power-BI-DAX-FACT\" >Funci\u00f3n Power BI DAX FACT<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-12\" href=\"https:\/\/rmarketingdigital.com\/en\/powerbi\/funciones-matematicas-de-power-bi-dax\/#Funcion-Power-BI-DAX-POWER\" >Funci\u00f3n Power BI DAX POWER<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-13\" href=\"https:\/\/rmarketingdigital.com\/en\/powerbi\/funciones-matematicas-de-power-bi-dax\/#Funcion-Power-BI-DAX-DIVIDE\" >Funci\u00f3n Power BI DAX DIVIDE<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-14\" href=\"https:\/\/rmarketingdigital.com\/en\/powerbi\/funciones-matematicas-de-power-bi-dax\/#Funcion-ABS-de-Power-BI-DAX\" >Funci\u00f3n ABS de Power BI DAX<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-15\" href=\"https:\/\/rmarketingdigital.com\/en\/powerbi\/funciones-matematicas-de-power-bi-dax\/#Funcion-Power-BI-DAX-MOD\" >Funci\u00f3n Power BI DAX MOD<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-16\" href=\"https:\/\/rmarketingdigital.com\/en\/powerbi\/funciones-matematicas-de-power-bi-dax\/#Funcion-Power-BI-DAX-MROUND\" >Funci\u00f3n Power BI DAX MROUND<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-17\" href=\"https:\/\/rmarketingdigital.com\/en\/powerbi\/funciones-matematicas-de-power-bi-dax\/#Funcion-de-cociente-de-Power-BI-DAX\" >Funci\u00f3n de cociente de Power BI DAX<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-18\" href=\"https:\/\/rmarketingdigital.com\/en\/powerbi\/funciones-matematicas-de-power-bi-dax\/#Funcion-Power-BI-DAX-RAND\" >Funci\u00f3n Power BI DAX RAND<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-19\" href=\"https:\/\/rmarketingdigital.com\/en\/powerbi\/funciones-matematicas-de-power-bi-dax\/#Funcion-Power-BI-DAX-RANDBETWEEN\" >Funci\u00f3n Power BI DAX RANDBETWEEN<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-20\" href=\"https:\/\/rmarketingdigital.com\/en\/powerbi\/funciones-matematicas-de-power-bi-dax\/#Funcion-Power-BI-DAX-TRUNC\" >Funci\u00f3n Power BI DAX TRUNC<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-21\" href=\"https:\/\/rmarketingdigital.com\/en\/powerbi\/funciones-matematicas-de-power-bi-dax\/#Funcion-ROUNDDOWN-de-Power-BI-DAX\" >Funci\u00f3n ROUNDDOWN 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-22\" href=\"https:\/\/rmarketingdigital.com\/en\/powerbi\/funciones-matematicas-de-power-bi-dax\/#Funcion-ROUNDUP-de-Power-BI-DAX\" >Funci\u00f3n ROUNDUP de Power BI DAX<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-23\" href=\"https:\/\/rmarketingdigital.com\/en\/powerbi\/funciones-matematicas-de-power-bi-dax\/#Funcion-Power-BI-DAX-LCM\" >Funci\u00f3n Power BI DAX LCM<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-24\" href=\"https:\/\/rmarketingdigital.com\/en\/powerbi\/funciones-matematicas-de-power-bi-dax\/#Funcion-Power-BI-DAX-GCD\" >Funci\u00f3n Power BI DAX GCD<\/a><\/li><\/ul><\/li><\/ul><\/nav><\/div>\n<div>\n<p>\u00bfC\u00f3mo usar las funciones matem\u00e1ticas de Power BI DAX con ejemplos?  Microsoft Power BI DAX proporciona varias funciones matem\u00e1ticas o matem\u00e1ticas como TECHO, PISO, MONEDA, INT, SQRT, POTENCIA, MOD, DIVIDE, ROUND, ROUNDUP, ROUNDDOWN, LCM, GCD, etc.<\/p>\n<p><span id=\"ezoic-pub-ad-placeholder-104\"\/><span style=\"display:block !important;float:none !important;margin-bottom:15px !important;margin-left:0px !important;margin-right:0px !important;margin-top:15px !important;min-height:90px;min-width:728px;text-align:center !important;\" class=\"ezoic-ad medrectangle-3 adtester-container adtester-container-104\" data-ez-name=\"tutorialgateway_org-medrectangle-3\"><span id=\"div-gpt-ad-tutorialgateway_org-medrectangle-3-0\" ezaw=\"728\" ezah=\"90\" style=\"position:relative;z-index:0;display:inline-block;width:100%;max-width:1200px;margin-left:auto !important;margin-right:auto !important;min-height:90px;min-width:728px;\" class=\"ezoic-ad ezoic-adl\"\/><\/span><\/p>\n<p>Para demostrar las funciones matem\u00e1ticas de Power BI DAX, vamos a utilizar los datos que se muestran a continuaci\u00f3n.  Como puede ver, hay 15 registros en esta tabla.<\/p>\n<figure class=\"wp-block-image\"><img alt='power-bi-dax-math-functions-1-5192291' width='1177' height='655' alt=\"Funciones matem\u00e1ticas de Power BI DAX 1\" class=\"wp-image-33306\" srcset='\/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Power-BI-DAX-Math-Functions-1-5192291.png 1177w, \/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Power-BI-DAX-Math-Functions-1-5192291-300x167.png 300w, \/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Power-BI-DAX-Math-Functions-1-5192291-1024x570.png 1024w, \/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Power-BI-DAX-Math-Functions-1-5192291-768x427.png 768w' data-lazy-sizes='(max-width: 1177px) 100vw, 1177px' src='https:\/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Power-BI-DAX-Math-Functions-1-5192291.png'\/><noscript><img alt='power-bi-dax-math-functions-1-5192291' width='1177' height='655' src='https:\/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Power-BI-DAX-Math-Functions-1-5192291.png' alt=\"Funciones matem\u00e1ticas de Power BI DAX 1\" class=\"wp-image-33306\" srcset='\/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Power-BI-DAX-Math-Functions-1-5192291.png 1177w, \/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Power-BI-DAX-Math-Functions-1-5192291-300x167.png 300w, \/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Power-BI-DAX-Math-Functions-1-5192291-1024x570.png 1024w, \/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Power-BI-DAX-Math-Functions-1-5192291-768x427.png 768w' sizes='(max-width: 1177px) 100vw, 1177px'\/><\/noscript><\/figure>\n<h2><span class=\"ez-toc-section\" id=\"Funciones-matematicas-de-Power-BI-DAX\"><\/span>Funciones matem\u00e1ticas de Power BI DAX<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p>La siguiente serie de ejemplos muestra el uso de funciones matem\u00e1ticas de DAX en Power BI<\/p>\n<h3><span class=\"ez-toc-section\" id=\"Funcion-de-techo-de-Power-BI-DAX\"><\/span>Funci\u00f3n de techo de Power BI DAX<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p>La funci\u00f3n DAX Ceiling en Power BI devuelve el valor m\u00e1s cercano, que es mayor o igual a un valor dado.  La sintaxis de esta funci\u00f3n CEILING de Power BI es:<\/p>\n<pre class=\"wp-block-preformatted lang:tsql decode:true\">CEILING(Number, significance)<\/pre>\n<p>Para demostrar estas funciones de DAX Math en Power BI, tenemos que usar la columna calculada.  Para crear una columna, haga clic en el <strong>Nueva columna<\/strong> opci\u00f3n en Power BI <strong>Hogar<\/strong> pesta\u00f1a, o <strong>Modelado <\/strong>leng\u00fceta.<\/p>\n<p><span id=\"ezoic-pub-ad-placeholder-105\"\/><span style=\"display:block !important;float:none !important;margin-bottom:15px !important;margin-left:0px !important;margin-right:0px !important;margin-top:15px !important;min-height:400px;min-width:580px;text-align:center !important;\" class=\"ezoic-ad box-4 adtester-container adtester-container-105\" data-ez-name=\"tutorialgateway_org-box-4\"><span id=\"div-gpt-ad-tutorialgateway_org-box-4-0\" ezaw=\"580\" ezah=\"400\" style=\"position:relative;z-index:0;display:inline-block;width:100%;max-width:1200px;margin-left:auto !important;margin-right:auto !important;min-height:400px;min-width:580px;\" class=\"ezoic-ad ezoic-adl\"\/><\/span><\/p>\n<figure class=\"wp-block-image\"><img alt='power-bi-dax-math-functions-2-6430505' width='1100' height='703' alt=\"Funci\u00f3n 2 de Power BI DAX CEILING\" class=\"wp-image-33307\" srcset='\/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Power-BI-DAX-Math-Functions-2-6430505.png 1100w, \/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Power-BI-DAX-Math-Functions-2-6430505-300x192.png 300w, \/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Power-BI-DAX-Math-Functions-2-6430505-1024x654.png 1024w, \/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Power-BI-DAX-Math-Functions-2-6430505-768x491.png 768w' data-lazy-sizes='(max-width: 1100px) 100vw, 1100px' src='https:\/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Power-BI-DAX-Math-Functions-2-6430505.png'\/><noscript><img alt='power-bi-dax-math-functions-2-6430505' width='1100' height='703' src='https:\/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Power-BI-DAX-Math-Functions-2-6430505.png' alt=\"Funci\u00f3n 2 de Power BI DAX CEILING\" class=\"wp-image-33307\" srcset='\/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Power-BI-DAX-Math-Functions-2-6430505.png 1100w, \/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Power-BI-DAX-Math-Functions-2-6430505-300x192.png 300w, \/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Power-BI-DAX-Math-Functions-2-6430505-1024x654.png 1024w, \/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Power-BI-DAX-Math-Functions-2-6430505-768x491.png 768w' sizes='(max-width: 1100px) 100vw, 1100px'\/><\/noscript><\/figure>\n<p>Como puede ver en la captura de pantalla a continuaci\u00f3n, cambiamos el nombre de la columna predeterminada a CEIL.  La siguiente declaraci\u00f3n encuentra el valor entero m\u00e1s cercano mayor o igual a Ventas<\/p>\n<pre class=\"wp-block-preformatted lang:tsql decode:true\">CEILING(EmployeeSales[Sales])<\/pre>\n<figure class=\"wp-block-image\"><img alt='power-bi-dax-math-functions-3-9796234' width='1100' height='704' alt=\"Funci\u00f3n 3 de Power BI DAX CEILING\" class=\"wp-image-33308\" srcset='\/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Power-BI-DAX-Math-Functions-3-9796234.png 1100w, \/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Power-BI-DAX-Math-Functions-3-9796234-300x192.png 300w, \/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Power-BI-DAX-Math-Functions-3-9796234-1024x655.png 1024w, \/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Power-BI-DAX-Math-Functions-3-9796234-768x492.png 768w' data-lazy-sizes='(max-width: 1100px) 100vw, 1100px' src='https:\/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Power-BI-DAX-Math-Functions-3-9796234.png'\/><noscript><img alt='power-bi-dax-math-functions-3-9796234' width='1100' height='704' src='https:\/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Power-BI-DAX-Math-Functions-3-9796234.png' alt=\"Funci\u00f3n 3 de Power BI DAX CEILING\" class=\"wp-image-33308\" srcset='\/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Power-BI-DAX-Math-Functions-3-9796234.png 1100w, \/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Power-BI-DAX-Math-Functions-3-9796234-300x192.png 300w, \/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Power-BI-DAX-Math-Functions-3-9796234-1024x655.png 1024w, \/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Power-BI-DAX-Math-Functions-3-9796234-768x492.png 768w' sizes='(max-width: 1100px) 100vw, 1100px'\/><\/noscript><\/figure>\n<p>Perm\u00edtanme agregar este campo CEILING a la tabla que creamos anteriormente.  Consulte el art\u00edculo Crear informe de tabla para comprender los pasos necesarios para crear una tabla.<\/p>\n<figure class=\"wp-block-image\"><img alt='power-bi-dax-math-functions-4-7821942' width='1078' height='706' alt=\"Funci\u00f3n 4 de Power BI DAX CEILING\" class=\"wp-image-33309\" srcset='\/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Power-BI-DAX-Math-Functions-4-7821942.png 1078w, \/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Power-BI-DAX-Math-Functions-4-7821942-300x196.png 300w, \/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Power-BI-DAX-Math-Functions-4-7821942-1024x671.png 1024w, \/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Power-BI-DAX-Math-Functions-4-7821942-768x503.png 768w' data-lazy-sizes='(max-width: 1078px) 100vw, 1078px' src='https:\/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Power-BI-DAX-Math-Functions-4-7821942.png'\/><noscript><img alt='power-bi-dax-math-functions-4-7821942' width='1078' height='706' src='https:\/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Power-BI-DAX-Math-Functions-4-7821942.png' alt=\"Funci\u00f3n 4 de Power BI DAX CEILING\" class=\"wp-image-33309\" srcset='\/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Power-BI-DAX-Math-Functions-4-7821942.png 1078w, \/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Power-BI-DAX-Math-Functions-4-7821942-300x196.png 300w, \/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Power-BI-DAX-Math-Functions-4-7821942-1024x671.png 1024w, \/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Power-BI-DAX-Math-Functions-4-7821942-768x503.png 768w' sizes='(max-width: 1078px) 100vw, 1078px'\/><\/noscript><\/figure>\n<h3><span class=\"ez-toc-section\" id=\"Funcion-Power-BI-DAX-FLOOR\"><\/span>Funci\u00f3n Power BI DAX FLOOR<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p>La funci\u00f3n Power BI DAX FLOOR devuelve el valor m\u00e1s cercano, que es menor o igual a un valor dado.  La sintaxis de esta funci\u00f3n de piso de Power BI DAX es:<\/p>\n<pre class=\"wp-block-preformatted lang:tsql decode:true\">FLOOR(expression, significance)<\/pre>\n<p>Esta funci\u00f3n matem\u00e1tica de Power BI DAX encuentra el valor m\u00e1s cercano que es menor o igual que Ventas<\/p>\n<pre class=\"wp-block-preformatted lang:tsql decode:true\">FLOOR(EmployeeSales[Sales], 1)<\/pre>\n<figure class=\"wp-block-image\"><img alt='power-bi-dax-math-functions-5-8349305' width='1078' height='706' alt=\"Funci\u00f3n POWER BI DAX FLOOR 5\" class=\"wp-image-33310\" srcset='\/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Power-BI-DAX-Math-Functions-5-8349305.png 1078w, \/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Power-BI-DAX-Math-Functions-5-8349305-300x196.png 300w, \/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Power-BI-DAX-Math-Functions-5-8349305-1024x671.png 1024w, \/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Power-BI-DAX-Math-Functions-5-8349305-768x503.png 768w' data-lazy-sizes='(max-width: 1078px) 100vw, 1078px' src='https:\/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Power-BI-DAX-Math-Functions-5-8349305.png'\/><noscript><img alt='power-bi-dax-math-functions-5-8349305' width='1078' height='706' src='https:\/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Power-BI-DAX-Math-Functions-5-8349305.png' alt=\"Funci\u00f3n POWER BI DAX FLOOR 5\" class=\"wp-image-33310\" srcset='\/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Power-BI-DAX-Math-Functions-5-8349305.png 1078w, \/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Power-BI-DAX-Math-Functions-5-8349305-300x196.png 300w, \/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Power-BI-DAX-Math-Functions-5-8349305-1024x671.png 1024w, \/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Power-BI-DAX-Math-Functions-5-8349305-768x503.png 768w' sizes='(max-width: 1078px) 100vw, 1078px'\/><\/noscript><\/figure>\n<h3><span class=\"ez-toc-section\" id=\"Funcion-ROUND-de-Power-BI-DAX\"><\/span>Funci\u00f3n ROUND de Power BI DAX<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p>La funci\u00f3n ROUND de Power BI DAX es redondear los valores dados al valor m\u00e1s cercano.  La sintaxis de esta funci\u00f3n redonda de Power BI DAX es:<\/p>\n<pre class=\"wp-block-preformatted lang:tsql decode:true\">ROUND(expression, significance)<\/pre>\n<p>Redondea los valores de Ventas al entero m\u00e1s cercano.<\/p>\n<pre class=\"wp-block-preformatted lang:tsql decode:true\">ROUND = ROUND(EmployeeSales[Sales], 0)<\/pre>\n<figure class=\"wp-block-image\"><img alt='power-bi-dax-math-functions-6-7901458' width='1078' height='705' alt=\"Funci\u00f3n 6 de Power BI DAX ROUND\" class=\"wp-image-33311\" srcset='\/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Power-BI-DAX-Math-Functions-6-7901458.png 1078w, \/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Power-BI-DAX-Math-Functions-6-7901458-300x196.png 300w, \/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Power-BI-DAX-Math-Functions-6-7901458-1024x670.png 1024w, \/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Power-BI-DAX-Math-Functions-6-7901458-768x502.png 768w' data-lazy-sizes='(max-width: 1078px) 100vw, 1078px' src='https:\/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Power-BI-DAX-Math-Functions-6-7901458.png'\/><noscript><img alt='power-bi-dax-math-functions-6-7901458' width='1078' height='705' src='https:\/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Power-BI-DAX-Math-Functions-6-7901458.png' alt=\"Funci\u00f3n 6 de Power BI DAX ROUND\" class=\"wp-image-33311\" srcset='\/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Power-BI-DAX-Math-Functions-6-7901458.png 1078w, \/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Power-BI-DAX-Math-Functions-6-7901458-300x196.png 300w, \/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Power-BI-DAX-Math-Functions-6-7901458-1024x670.png 1024w, \/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Power-BI-DAX-Math-Functions-6-7901458-768x502.png 768w' sizes='(max-width: 1078px) 100vw, 1078px'\/><\/noscript><\/figure>\n<h3><span class=\"ez-toc-section\" id=\"Funcion-Power-BI-DAX-CURRENCY\"><\/span>Funci\u00f3n Power BI DAX CURRENCY<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p>La funci\u00f3n DAX CURRENCY en Power BI convierte el valor en el tipo de datos de moneda.  La sintaxis de esta funci\u00f3n Power BI DAX CURRENCY es:<\/p>\n<pre class=\"wp-block-preformatted lang:tsql decode:true\">CURRENCY(expression)<\/pre>\n<p>Convierte los valores de Ventas al tipo de datos Moneda<\/p>\n<pre class=\"wp-block-preformatted lang:tsql decode:true\">Money = CURRENCY(EmployeeSales[Sales])<\/pre>\n<figure class=\"wp-block-image\"><img alt='power-bi-dax-math-functions-7-7964758' width='1078' height='704' alt=\"Funci\u00f3n 7 de moneda DAX de Power BI\" class=\"wp-image-33312\" srcset='\/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Power-BI-DAX-Math-Functions-7-7964758.png 1078w, \/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Power-BI-DAX-Math-Functions-7-7964758-300x196.png 300w, \/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Power-BI-DAX-Math-Functions-7-7964758-1024x669.png 1024w, \/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Power-BI-DAX-Math-Functions-7-7964758-768x502.png 768w' data-lazy-sizes='(max-width: 1078px) 100vw, 1078px' src='https:\/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Power-BI-DAX-Math-Functions-7-7964758.png'\/><noscript><img alt='power-bi-dax-math-functions-7-7964758' width='1078' height='704' src='https:\/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Power-BI-DAX-Math-Functions-7-7964758.png' alt=\"Funci\u00f3n 7 de moneda DAX de Power BI\" class=\"wp-image-33312\" srcset='\/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Power-BI-DAX-Math-Functions-7-7964758.png 1078w, \/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Power-BI-DAX-Math-Functions-7-7964758-300x196.png 300w, \/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Power-BI-DAX-Math-Functions-7-7964758-1024x669.png 1024w, \/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Power-BI-DAX-Math-Functions-7-7964758-768x502.png 768w' sizes='(max-width: 1078px) 100vw, 1078px'\/><\/noscript><\/figure>\n<h3><span class=\"ez-toc-section\" id=\"Funcion-Power-BI-DAX-INT\"><\/span>Funci\u00f3n Power BI DAX INT<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p>La funci\u00f3n DAX INT en Power BI convierte el valor dado en un tipo de datos entero.  La sintaxis de esta funci\u00f3n Power BI DAX INT es:<\/p>\n<pre class=\"wp-block-preformatted lang:tsql decode:true\">INT(expression)<\/pre>\n<p>La funci\u00f3n Power BI DAX INT convierte los valores de ventas al tipo de datos Integer<span id=\"ezoic-pub-ad-placeholder-106\" class=\"ezoic-adpicker-ad\"\/><span style=\"display:block !important;float:none;margin-bottom:15px !important;margin-left:0px !important;margin-right:0px !important;margin-top:15px !important;min-height:250px;min-width:300px;text-align:center !important;\" class=\"ezoic-ad banner-1 adtester-container adtester-container-106\" data-ez-name=\"tutorialgateway_org-banner-1\"><span id=\"div-gpt-ad-tutorialgateway_org-banner-1-0\" ezaw=\"300\" ezah=\"250\" style=\"position:relative;z-index:0;display:inline-block;min-height:250px;min-width:300px;\" class=\"ezoic-ad\"\/><\/span><\/p>\n<pre class=\"wp-block-preformatted lang:tsql decode:true\">INT = INT(EmployeeSales[Sales])<\/pre>\n<figure class=\"wp-block-image\"><img alt='power-bi-dax-math-functions-8-6403845' width='1078' height='705' alt=\"Funci\u00f3n 8 de Power BI DAX INT\" class=\"wp-image-33313\" srcset='\/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Power-BI-DAX-Math-Functions-8-6403845.png 1078w, \/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Power-BI-DAX-Math-Functions-8-6403845-300x196.png 300w, \/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Power-BI-DAX-Math-Functions-8-6403845-1024x670.png 1024w, \/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Power-BI-DAX-Math-Functions-8-6403845-768x502.png 768w' data-lazy-sizes='(max-width: 1078px) 100vw, 1078px' src='https:\/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Power-BI-DAX-Math-Functions-8-6403845.png'\/><noscript><img alt='power-bi-dax-math-functions-8-6403845' width='1078' height='705' src='https:\/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Power-BI-DAX-Math-Functions-8-6403845.png' alt=\"Funci\u00f3n 8 de Power BI DAX INT\" class=\"wp-image-33313\" srcset='\/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Power-BI-DAX-Math-Functions-8-6403845.png 1078w, \/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Power-BI-DAX-Math-Functions-8-6403845-300x196.png 300w, \/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Power-BI-DAX-Math-Functions-8-6403845-1024x670.png 1024w, \/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Power-BI-DAX-Math-Functions-8-6403845-768x502.png 768w' sizes='(max-width: 1078px) 100vw, 1078px'\/><\/noscript><\/figure>\n<h3><span class=\"ez-toc-section\" id=\"Funcion-Power-BI-DAX-SQRT\"><\/span>Funci\u00f3n Power BI DAX SQRT<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p>La funci\u00f3n DAX SQRT en power BI devuelve la ra\u00edz cuadrada de un n\u00famero determinado.  La sintaxis de la funci\u00f3n Power BI DAX SQRT es la que se muestra a continuaci\u00f3n:<\/p>\n<pre class=\"wp-block-preformatted lang:tsql decode:true\">SQRT(expression)<\/pre>\n<p>Devuelve la ra\u00edz cuadrada de los valores de una columna de ventas.<\/p>\n<pre class=\"wp-block-preformatted lang:tsql decode:true\">SQRT = SQRT(EmployeeSales[Sales])<\/pre>\n<figure class=\"wp-block-image\"><img alt='power-bi-dax-math-functions-9-5225395' width='1078' height='706' alt=\"Funci\u00f3n 9 de Power BI DAX SQRT\" class=\"wp-image-33314\" srcset='\/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Power-BI-DAX-Math-Functions-9-5225395.png 1078w, \/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Power-BI-DAX-Math-Functions-9-5225395-300x196.png 300w, \/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Power-BI-DAX-Math-Functions-9-5225395-1024x671.png 1024w, \/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Power-BI-DAX-Math-Functions-9-5225395-768x503.png 768w' data-lazy-sizes='(max-width: 1078px) 100vw, 1078px' src='https:\/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Power-BI-DAX-Math-Functions-9-5225395.png'\/><noscript><img alt='power-bi-dax-math-functions-9-5225395' width='1078' height='706' src='https:\/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Power-BI-DAX-Math-Functions-9-5225395.png' alt=\"Funci\u00f3n 9 de Power BI DAX SQRT\" class=\"wp-image-33314\" srcset='\/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Power-BI-DAX-Math-Functions-9-5225395.png 1078w, \/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Power-BI-DAX-Math-Functions-9-5225395-300x196.png 300w, \/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Power-BI-DAX-Math-Functions-9-5225395-1024x671.png 1024w, \/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Power-BI-DAX-Math-Functions-9-5225395-768x503.png 768w' sizes='(max-width: 1078px) 100vw, 1078px'\/><\/noscript><\/figure>\n<h3><span class=\"ez-toc-section\" id=\"Funcion-Power-BI-DAX-SIGN\"><\/span>Funci\u00f3n Power BI DAX SIGN<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p>La funci\u00f3n Power BI DAX SIGN devuelve el signo de un n\u00famero determinado.  Esta funci\u00f3n devuelve 1 para valores positivos, -1 para valores negativos y 0 para ceros.  La sintaxis de esta funci\u00f3n Power BI DAX SIGN es:<\/p>\n<pre class=\"wp-block-preformatted lang:tsql decode:true\">SIGN(expression)<\/pre>\n<p>Devuelve el signo de los valores de la columna de grado de servicio.<\/p>\n<pre class=\"wp-block-preformatted lang:tsql decode:true\">SIGN = SIGN(EmployeeSales[Service Grade])<\/pre>\n<figure class=\"wp-block-image\"><img alt='power-bi-dax-math-functions-10-5803736' width='1080' height='654' alt=\"Funci\u00f3n 10 de Power BI DAX SIGN\" class=\"wp-image-33315\" srcset='\/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Power-BI-DAX-Math-Functions-10-5803736.png 1080w, \/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Power-BI-DAX-Math-Functions-10-5803736-300x182.png 300w, \/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Power-BI-DAX-Math-Functions-10-5803736-1024x620.png 1024w, \/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Power-BI-DAX-Math-Functions-10-5803736-768x465.png 768w' data-lazy-sizes='(max-width: 1080px) 100vw, 1080px' src='https:\/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Power-BI-DAX-Math-Functions-10-5803736.png'\/><noscript><img alt='power-bi-dax-math-functions-10-5803736' width='1080' height='654' src='https:\/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Power-BI-DAX-Math-Functions-10-5803736.png' alt=\"Funci\u00f3n 10 de Power BI DAX SIGN\" class=\"wp-image-33315\" srcset='\/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Power-BI-DAX-Math-Functions-10-5803736.png 1080w, \/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Power-BI-DAX-Math-Functions-10-5803736-300x182.png 300w, \/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Power-BI-DAX-Math-Functions-10-5803736-1024x620.png 1024w, \/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Power-BI-DAX-Math-Functions-10-5803736-768x465.png 768w' sizes='(max-width: 1080px) 100vw, 1080px'\/><\/noscript><\/figure>\n<h3><span class=\"ez-toc-section\" id=\"Funcion-Power-BI-DAX-EVEN\"><\/span>Funci\u00f3n Power BI DAX EVEN<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p>La funci\u00f3n DAX EVEN en Power BI devuelve el entero par m\u00e1s cercano de un n\u00famero dado.  La sintaxis de esta funci\u00f3n Power BI DAX EVEN es:<\/p>\n<pre class=\"wp-block-preformatted lang:tsql decode:true\">EVEN(expression)<\/pre>\n<p>La siguiente declaraci\u00f3n devuelve el entero par m\u00e1s cercano de los valores de una columna de grado de servicio<\/p>\n<pre class=\"wp-block-preformatted lang:tsql decode:true\">EVEN = EVEN(EmployeeSales[Service Grade])<\/pre>\n<figure class=\"wp-block-image\"><img alt='power-bi-dax-math-functions-11-4695486' width='1080' height='726' alt=\"Funci\u00f3n 11 de Power BI DAX EVEN\" class=\"wp-image-33316\" srcset='\/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Power-BI-DAX-Math-Functions-11-4695486.png 1080w, \/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Power-BI-DAX-Math-Functions-11-4695486-300x202.png 300w, \/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Power-BI-DAX-Math-Functions-11-4695486-1024x688.png 1024w, \/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Power-BI-DAX-Math-Functions-11-4695486-768x516.png 768w, \/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Power-BI-DAX-Math-Functions-11-4695486-900x604.png 900w, \/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Power-BI-DAX-Math-Functions-11-4695486-600x403.png 600w, \/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Power-BI-DAX-Math-Functions-11-4695486-400x269.png 400w' data-lazy-sizes='(max-width: 1080px) 100vw, 1080px' src='https:\/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Power-BI-DAX-Math-Functions-11-4695486.png'\/><noscript><img alt='power-bi-dax-math-functions-11-4695486' width='1080' height='726' src='https:\/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Power-BI-DAX-Math-Functions-11-4695486.png' alt=\"Funci\u00f3n 11 de Power BI DAX EVEN\" class=\"wp-image-33316\" srcset='\/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Power-BI-DAX-Math-Functions-11-4695486.png 1080w, \/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Power-BI-DAX-Math-Functions-11-4695486-300x202.png 300w, \/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Power-BI-DAX-Math-Functions-11-4695486-1024x688.png 1024w, \/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Power-BI-DAX-Math-Functions-11-4695486-768x516.png 768w, \/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Power-BI-DAX-Math-Functions-11-4695486-900x604.png 900w, \/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Power-BI-DAX-Math-Functions-11-4695486-600x403.png 600w, \/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Power-BI-DAX-Math-Functions-11-4695486-400x269.png 400w' sizes='(max-width: 1080px) 100vw, 1080px'\/><\/noscript><\/figure>\n<h3><span class=\"ez-toc-section\" id=\"Funcion-ODD-de-Power-BI-DAX\"><\/span>Funci\u00f3n ODD de Power BI DAX<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p>La funci\u00f3n ODD de Power BI DAX devuelve el entero impar m\u00e1s cercano de un n\u00famero determinado.  La sintaxis de esta funci\u00f3n ODD de Power BI DAX es:<\/p>\n<pre class=\"wp-block-preformatted lang:tsql decode:true\">ODD(expression)<\/pre>\n<p>Devuelve el entero impar m\u00e1s cercano de los valores de una columna de grado de servicio.<\/p>\n<pre class=\"wp-block-preformatted lang:tsql decode:true\">EVEN = EVEN(EmployeeSales[Service Grade])<\/pre>\n<figure class=\"wp-block-image\"><img alt='power-bi-dax-math-functions-12-3169461' width='1079' height='687' alt=\"Funci\u00f3n ODD de Power BI DAX 12\" class=\"wp-image-33317\" srcset='\/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Power-BI-DAX-Math-Functions-12-3169461.png 1079w, \/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Power-BI-DAX-Math-Functions-12-3169461-300x191.png 300w, \/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Power-BI-DAX-Math-Functions-12-3169461-1024x652.png 1024w, \/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Power-BI-DAX-Math-Functions-12-3169461-768x489.png 768w' data-lazy-sizes='(max-width: 1079px) 100vw, 1079px' src='https:\/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Power-BI-DAX-Math-Functions-12-3169461.png'\/><noscript><img alt='power-bi-dax-math-functions-12-3169461' width='1079' height='687' src='https:\/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Power-BI-DAX-Math-Functions-12-3169461.png' alt=\"Funci\u00f3n ODD de Power BI DAX 12\" class=\"wp-image-33317\" srcset='\/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Power-BI-DAX-Math-Functions-12-3169461.png 1079w, \/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Power-BI-DAX-Math-Functions-12-3169461-300x191.png 300w, \/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Power-BI-DAX-Math-Functions-12-3169461-1024x652.png 1024w, \/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Power-BI-DAX-Math-Functions-12-3169461-768x489.png 768w' sizes='(max-width: 1079px) 100vw, 1079px'\/><\/noscript><\/figure>\n<h3><span class=\"ez-toc-section\" id=\"Funcion-Power-BI-DAX-FACT\"><\/span>Funci\u00f3n Power BI DAX FACT<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p>La funci\u00f3n Power BI DAX FACT busca el factorial de un n\u00famero determinado.  La sintaxis de esta funci\u00f3n FACT de Power BI DAX es:<\/p>\n<pre class=\"wp-block-preformatted lang:tsql decode:true\">FACT(number)<\/pre>\n<p>Por ejemplo, factorial de 4 = 4 * 3 * 2 * 1 => 24<\/p>\n<p>La siguiente declaraci\u00f3n devuelve el factorial de un ingreso anual dividido por 1000<\/p>\n<pre class=\"wp-block-preformatted lang:tsql decode:true\">FACT = FACT(EmployeeSales[Yearly Income] \/ 1000)<\/pre>\n<figure class=\"wp-block-image\"><img alt='power-bi-dax-math-functions-13-4990819' width='1080' height='726' alt=\"Funci\u00f3n 13 de Power BI DAX FACT\" class=\"wp-image-33318\" srcset='\/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Power-BI-DAX-Math-Functions-13-4990819.png 1080w, \/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Power-BI-DAX-Math-Functions-13-4990819-300x202.png 300w, \/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Power-BI-DAX-Math-Functions-13-4990819-1024x688.png 1024w, \/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Power-BI-DAX-Math-Functions-13-4990819-768x516.png 768w, \/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Power-BI-DAX-Math-Functions-13-4990819-900x604.png 900w, \/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Power-BI-DAX-Math-Functions-13-4990819-600x403.png 600w, \/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Power-BI-DAX-Math-Functions-13-4990819-400x269.png 400w' data-lazy-sizes='(max-width: 1080px) 100vw, 1080px' src='https:\/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Power-BI-DAX-Math-Functions-13-4990819.png'\/><noscript><img alt='power-bi-dax-math-functions-13-4990819' width='1080' height='726' src='https:\/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Power-BI-DAX-Math-Functions-13-4990819.png' alt=\"Funci\u00f3n 13 de Power BI DAX FACT\" class=\"wp-image-33318\" srcset='\/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Power-BI-DAX-Math-Functions-13-4990819.png 1080w, \/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Power-BI-DAX-Math-Functions-13-4990819-300x202.png 300w, \/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Power-BI-DAX-Math-Functions-13-4990819-1024x688.png 1024w, \/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Power-BI-DAX-Math-Functions-13-4990819-768x516.png 768w, \/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Power-BI-DAX-Math-Functions-13-4990819-900x604.png 900w, \/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Power-BI-DAX-Math-Functions-13-4990819-600x403.png 600w, \/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Power-BI-DAX-Math-Functions-13-4990819-400x269.png 400w' sizes='(max-width: 1080px) 100vw, 1080px'\/><\/noscript><\/figure>\n<h3><span class=\"ez-toc-section\" id=\"Funcion-Power-BI-DAX-POWER\"><\/span>Funci\u00f3n Power BI DAX POWER<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p>La funci\u00f3n Power BI DAX POWER encuentra la potencia de un n\u00famero determinado.  Esta funci\u00f3n acepta un segundo argumento para especificar el valor de potencia.  La sintaxis de esta funci\u00f3n Power BI DAX POWER es:<\/p>\n<pre class=\"wp-block-preformatted lang:tsql decode:true\">POWER(expression, raise_number)<\/pre>\n<p>Por ejemplo, Potencia (4, 3) = 4\u00b3.<\/p>\n<p>La siguiente declaraci\u00f3n devuelve el factorial de un ingreso anual dividido por 1000<\/p>\n<pre class=\"wp-block-preformatted lang:tsql decode:true\">POWER = POWER(EmployeeSales[Sales], 2)<\/pre>\n<figure class=\"wp-block-image\"><img alt='power-bi-dax-math-functions-14-1215731' width='1069' height='718' alt=\"Funci\u00f3n Power BI DAX POWER 14\" class=\"wp-image-33319\" srcset='\/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Power-BI-DAX-Math-Functions-14-1215731.png 1069w, \/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Power-BI-DAX-Math-Functions-14-1215731-300x201.png 300w, \/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Power-BI-DAX-Math-Functions-14-1215731-1024x688.png 1024w, \/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Power-BI-DAX-Math-Functions-14-1215731-768x516.png 768w, \/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Power-BI-DAX-Math-Functions-14-1215731-900x604.png 900w, \/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Power-BI-DAX-Math-Functions-14-1215731-600x403.png 600w, \/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Power-BI-DAX-Math-Functions-14-1215731-400x269.png 400w' data-lazy-sizes='(max-width: 1069px) 100vw, 1069px' src='https:\/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Power-BI-DAX-Math-Functions-14-1215731.png'\/><noscript><img alt='power-bi-dax-math-functions-14-1215731' width='1069' height='718' src='https:\/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Power-BI-DAX-Math-Functions-14-1215731.png' alt=\"Funci\u00f3n Power BI DAX POWER 14\" class=\"wp-image-33319\" srcset='\/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Power-BI-DAX-Math-Functions-14-1215731.png 1069w, \/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Power-BI-DAX-Math-Functions-14-1215731-300x201.png 300w, \/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Power-BI-DAX-Math-Functions-14-1215731-1024x688.png 1024w, \/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Power-BI-DAX-Math-Functions-14-1215731-768x516.png 768w, \/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Power-BI-DAX-Math-Functions-14-1215731-900x604.png 900w, \/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Power-BI-DAX-Math-Functions-14-1215731-600x403.png 600w, \/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Power-BI-DAX-Math-Functions-14-1215731-400x269.png 400w' sizes='(max-width: 1069px) 100vw, 1069px'\/><\/noscript><\/figure>\n<h3><span class=\"ez-toc-section\" id=\"Funcion-Power-BI-DAX-DIVIDE\"><\/span>Funci\u00f3n Power BI DAX DIVIDE<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p>La funci\u00f3n DAX DIVIDE en Power BI divide un valor contra otro.  Si hay un error o no se puede dividir, devuelve valores EN BLANCO.  La sintaxis de esta funci\u00f3n DIVIDE de Power BI DAX es:<\/p>\n<pre class=\"wp-block-preformatted lang:tsql decode:true\">DIVIDE(numerator, denominator)<\/pre>\n<p>La siguiente declaraci\u00f3n divide los valores de la columna de ventas entre 30<\/p>\n<pre class=\"wp-block-preformatted lang:tsql decode:true\">POWER = POWER(EmployeeSales[Sales], 2)<\/pre>\n<figure class=\"wp-block-image\"><img alt='power-bi-dax-math-functions-15-8046361' width='1069' height='646' alt=\"Funci\u00f3n DIVIDE de Power BI DAX 15\" class=\"wp-image-33320\" srcset='\/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Power-BI-DAX-Math-Functions-15-8046361.png 1069w, \/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Power-BI-DAX-Math-Functions-15-8046361-300x181.png 300w, \/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Power-BI-DAX-Math-Functions-15-8046361-1024x619.png 1024w, \/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Power-BI-DAX-Math-Functions-15-8046361-768x464.png 768w' data-lazy-sizes='(max-width: 1069px) 100vw, 1069px' src='https:\/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Power-BI-DAX-Math-Functions-15-8046361.png'\/><noscript><img alt='power-bi-dax-math-functions-15-8046361' width='1069' height='646' src='https:\/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Power-BI-DAX-Math-Functions-15-8046361.png' alt=\"Funci\u00f3n DIVIDE de Power BI DAX 15\" class=\"wp-image-33320\" srcset='\/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Power-BI-DAX-Math-Functions-15-8046361.png 1069w, \/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Power-BI-DAX-Math-Functions-15-8046361-300x181.png 300w, \/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Power-BI-DAX-Math-Functions-15-8046361-1024x619.png 1024w, \/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Power-BI-DAX-Math-Functions-15-8046361-768x464.png 768w' sizes='(max-width: 1069px) 100vw, 1069px'\/><\/noscript><\/figure>\n<p>La funci\u00f3n Power BI DAX DIVIDE tambi\u00e9n acepta el tercer argumento.  Utilice este argumento para especificar el n\u00famero alternativo para valores EN BLANCO.<\/p>\n<p>La siguiente declaraci\u00f3n divide los valores de la columna de ventas por los valores de la columna de calificaci\u00f3n.  Si el resultado est\u00e1 en blanco, se devuelve 9.<\/p>\n<pre class=\"wp-block-preformatted lang:tsql decode:true\">POWER = POWER(EmployeeSales[Sales], 2)<\/pre>\n<figure class=\"wp-block-image\"><img alt='power-bi-dax-math-functions-16-2840097' width='1069' height='646' alt=\"Funci\u00f3n DIVIDE de Power BI DAX 16\" class=\"wp-image-33321\" srcset='\/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Power-BI-DAX-Math-Functions-16-2840097.png 1069w, \/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Power-BI-DAX-Math-Functions-16-2840097-300x181.png 300w, \/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Power-BI-DAX-Math-Functions-16-2840097-1024x619.png 1024w, \/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Power-BI-DAX-Math-Functions-16-2840097-768x464.png 768w' data-lazy-sizes='(max-width: 1069px) 100vw, 1069px' src='https:\/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Power-BI-DAX-Math-Functions-16-2840097.png'\/><noscript><img alt='power-bi-dax-math-functions-16-2840097' width='1069' height='646' src='https:\/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Power-BI-DAX-Math-Functions-16-2840097.png' alt=\"Funci\u00f3n DIVIDE de Power BI DAX 16\" class=\"wp-image-33321\" srcset='\/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Power-BI-DAX-Math-Functions-16-2840097.png 1069w, \/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Power-BI-DAX-Math-Functions-16-2840097-300x181.png 300w, \/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Power-BI-DAX-Math-Functions-16-2840097-1024x619.png 1024w, \/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Power-BI-DAX-Math-Functions-16-2840097-768x464.png 768w' sizes='(max-width: 1069px) 100vw, 1069px'\/><\/noscript><\/figure>\n<h3><span class=\"ez-toc-section\" id=\"Funcion-ABS-de-Power-BI-DAX\"><\/span>Funci\u00f3n ABS de Power BI DAX<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p>La funci\u00f3n ABS de Power BI DAX devuelve el valor positivo absoluto.  La sintaxis de esta funci\u00f3n ABS de Power BI DAX es:<\/p>\n<pre class=\"wp-block-preformatted lang:tsql decode:true\">ABS(expression)<\/pre>\n<p>Devuelve el valor positivo absoluto de los valores de la columna de grado de servicio.<\/p>\n<pre class=\"wp-block-preformatted lang:tsql decode:true\">ABS = ABS(EmployeeSales[Service Grade])<\/pre>\n<figure class=\"wp-block-image\"><img alt='power-bi-dax-math-functions-17-4211911' width='1067' height='646' alt=\"Funci\u00f3n ABS de Power BI DAX 17\" class=\"wp-image-33322\" srcset='\/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Power-BI-DAX-Math-Functions-17-4211911.png 1067w, \/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Power-BI-DAX-Math-Functions-17-4211911-300x182.png 300w, \/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Power-BI-DAX-Math-Functions-17-4211911-1024x620.png 1024w, \/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Power-BI-DAX-Math-Functions-17-4211911-768x465.png 768w' data-lazy-sizes='(max-width: 1067px) 100vw, 1067px' src='https:\/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Power-BI-DAX-Math-Functions-17-4211911.png'\/><noscript><img alt='power-bi-dax-math-functions-17-4211911' width='1067' height='646' src='https:\/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Power-BI-DAX-Math-Functions-17-4211911.png' alt=\"Funci\u00f3n ABS de Power BI DAX 17\" class=\"wp-image-33322\" srcset='\/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Power-BI-DAX-Math-Functions-17-4211911.png 1067w, \/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Power-BI-DAX-Math-Functions-17-4211911-300x182.png 300w, \/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Power-BI-DAX-Math-Functions-17-4211911-1024x620.png 1024w, \/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Power-BI-DAX-Math-Functions-17-4211911-768x465.png 768w' sizes='(max-width: 1067px) 100vw, 1067px'\/><\/noscript><\/figure>\n<h3><span class=\"ez-toc-section\" id=\"Funcion-Power-BI-DAX-MOD\"><\/span>Funci\u00f3n Power BI DAX MOD<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p>La funci\u00f3n DAX MOD en Power BI devuelve el resto despu\u00e9s del n\u00famero dividido.  La sintaxis de esta funci\u00f3n MOD de Power BI DAX es:<\/p>\n<pre class=\"wp-block-preformatted lang:tsql decode:true\">MOD(number, divisor)<\/pre>\n<p>Por ejemplo MOD (5, 2) = 1.<\/p>\n<p>La siguiente declaraci\u00f3n devuelve el resto de Ventas divisibles por el resultado de la funci\u00f3n SQRT.<\/p>\n<pre class=\"wp-block-preformatted lang:tsql decode:true\">MOD = MOD(EmployeeSales[Sales], EmployeeSales[SQRT])<\/pre>\n<figure class=\"wp-block-image\"><img alt='power-bi-dax-math-functions-18-6861028' width='1072' height='674' alt=\"Funci\u00f3n Power BI DAX MOD 18\" class=\"wp-image-33323\" srcset='\/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Power-BI-DAX-Math-Functions-18-6861028.png 1072w, \/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Power-BI-DAX-Math-Functions-18-6861028-300x189.png 300w, \/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Power-BI-DAX-Math-Functions-18-6861028-1024x644.png 1024w, \/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Power-BI-DAX-Math-Functions-18-6861028-768x483.png 768w' data-lazy-sizes='(max-width: 1072px) 100vw, 1072px' src='https:\/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Power-BI-DAX-Math-Functions-18-6861028.png'\/><noscript><img alt='power-bi-dax-math-functions-18-6861028' width='1072' height='674' src='https:\/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Power-BI-DAX-Math-Functions-18-6861028.png' alt=\"Funci\u00f3n Power BI DAX MOD 18\" class=\"wp-image-33323\" srcset='\/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Power-BI-DAX-Math-Functions-18-6861028.png 1072w, \/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Power-BI-DAX-Math-Functions-18-6861028-300x189.png 300w, \/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Power-BI-DAX-Math-Functions-18-6861028-1024x644.png 1024w, \/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Power-BI-DAX-Math-Functions-18-6861028-768x483.png 768w' sizes='(max-width: 1072px) 100vw, 1072px'\/><\/noscript><\/figure>\n<h3><span class=\"ez-toc-section\" id=\"Funcion-Power-BI-DAX-MROUND\"><\/span>Funci\u00f3n Power BI DAX MROUND<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p>La funci\u00f3n DAX MROUND devuelve un n\u00famero redondeado al m\u00faltiplo especificado.  La sintaxis de esta funci\u00f3n Power BI DAX MRound es:<\/p>\n<pre class=\"wp-block-preformatted lang:tsql decode:true\">MROUND(expression, multiple)<\/pre>\n<p>La declaraci\u00f3n que usamos es:<\/p>\n<pre class=\"wp-block-preformatted lang:tsql decode:true\">MROUND = MROUND(EmployeeSales[Sales], 0.05)<\/pre>\n<figure class=\"wp-block-image\"><img alt='power-bi-dax-math-functions-19-2331437' width='1071' height='628' alt=\"Funci\u00f3n Power BI DAX MROUND 19\" class=\"wp-image-33324\" srcset='\/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Power-BI-DAX-Math-Functions-19-2331437.png 1071w, \/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Power-BI-DAX-Math-Functions-19-2331437-300x176.png 300w, \/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Power-BI-DAX-Math-Functions-19-2331437-1024x600.png 1024w, \/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Power-BI-DAX-Math-Functions-19-2331437-768x450.png 768w' data-lazy-sizes='(max-width: 1071px) 100vw, 1071px' src='https:\/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Power-BI-DAX-Math-Functions-19-2331437.png'\/><noscript><img alt='power-bi-dax-math-functions-19-2331437' width='1071' height='628' src='https:\/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Power-BI-DAX-Math-Functions-19-2331437.png' alt=\"Funci\u00f3n Power BI DAX MROUND 19\" class=\"wp-image-33324\" srcset='\/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Power-BI-DAX-Math-Functions-19-2331437.png 1071w, \/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Power-BI-DAX-Math-Functions-19-2331437-300x176.png 300w, \/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Power-BI-DAX-Math-Functions-19-2331437-1024x600.png 1024w, \/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Power-BI-DAX-Math-Functions-19-2331437-768x450.png 768w' sizes='(max-width: 1071px) 100vw, 1071px'\/><\/noscript><\/figure>\n<h3><span class=\"ez-toc-section\" id=\"Funcion-de-cociente-de-Power-BI-DAX\"><\/span>Funci\u00f3n de cociente de Power BI DAX<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p>La funci\u00f3n DAX QUOTIENT en Power BI devuelve la parte entera del resultado de la divisi\u00f3n.  La sintaxis de la funci\u00f3n Power BI DAX QUOTIENT es:<\/p>\n<pre class=\"wp-block-preformatted lang:tsql decode:true\">QUOTIENT(numerator, denominator)<\/pre>\n<p>La siguiente declaraci\u00f3n devuelve la parte entera de Ventas dividida por el resultado de la funci\u00f3n Mod:<\/p>\n<pre class=\"wp-block-preformatted lang:tsql decode:true\">QUOTIENT = QUOTIENT(EmployeeSales[Sales], EmployeeSales[MOD])<\/pre>\n<figure class=\"wp-block-image\"><img alt='power-bi-dax-math-functions-20-1478042' width='1072' height='652' alt=\"Funci\u00f3n 20 de Power BI DAX QUOTIENT\" class=\"wp-image-33325\" srcset='\/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Power-BI-DAX-Math-Functions-20-1478042.png 1072w, \/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Power-BI-DAX-Math-Functions-20-1478042-300x182.png 300w, \/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Power-BI-DAX-Math-Functions-20-1478042-1024x623.png 1024w, \/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Power-BI-DAX-Math-Functions-20-1478042-768x467.png 768w' data-lazy-sizes='(max-width: 1072px) 100vw, 1072px' src='https:\/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Power-BI-DAX-Math-Functions-20-1478042.png'\/><noscript><img alt='power-bi-dax-math-functions-20-1478042' width='1072' height='652' src='https:\/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Power-BI-DAX-Math-Functions-20-1478042.png' alt=\"Funci\u00f3n 20 de Power BI DAX QUOTIENT\" class=\"wp-image-33325\" srcset='\/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Power-BI-DAX-Math-Functions-20-1478042.png 1072w, \/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Power-BI-DAX-Math-Functions-20-1478042-300x182.png 300w, \/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Power-BI-DAX-Math-Functions-20-1478042-1024x623.png 1024w, \/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Power-BI-DAX-Math-Functions-20-1478042-768x467.png 768w' sizes='(max-width: 1072px) 100vw, 1072px'\/><\/noscript><\/figure>\n<h3><span class=\"ez-toc-section\" id=\"Funcion-Power-BI-DAX-RAND\"><\/span>Funci\u00f3n Power BI DAX RAND<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p>La funci\u00f3n Power BI DAX RAND devuelve el n\u00famero positivo aleatorio entre 0 y 1. La sintaxis de la funci\u00f3n Power BI DAX RAND es:<\/p>\n<pre class=\"wp-block-preformatted lang:tsql decode:true\">RAND()<\/pre>\n<p>D\u00e9jame crear una nueva columna para generar valores aleatorios<\/p>\n<pre class=\"wp-block-preformatted lang:tsql decode:true\">RAND = RAND()<\/pre>\n<figure class=\"wp-block-image\"><img alt='power-bi-dax-math-functions-21-1445782' width='1056' height='623' alt=\"Funci\u00f3n Power BI DAX RAND 21\" class=\"wp-image-33326\" srcset='\/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Power-BI-DAX-Math-Functions-21-1445782.png 1056w, \/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Power-BI-DAX-Math-Functions-21-1445782-300x177.png 300w, \/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Power-BI-DAX-Math-Functions-21-1445782-1024x604.png 1024w, \/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Power-BI-DAX-Math-Functions-21-1445782-768x453.png 768w' data-lazy-sizes='(max-width: 1056px) 100vw, 1056px' src='https:\/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Power-BI-DAX-Math-Functions-21-1445782.png'\/><noscript><img alt='power-bi-dax-math-functions-21-1445782' width='1056' height='623' src='https:\/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Power-BI-DAX-Math-Functions-21-1445782.png' alt=\"Funci\u00f3n Power BI DAX RAND 21\" class=\"wp-image-33326\" srcset='\/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Power-BI-DAX-Math-Functions-21-1445782.png 1056w, \/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Power-BI-DAX-Math-Functions-21-1445782-300x177.png 300w, \/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Power-BI-DAX-Math-Functions-21-1445782-1024x604.png 1024w, \/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Power-BI-DAX-Math-Functions-21-1445782-768x453.png 768w' sizes='(max-width: 1056px) 100vw, 1056px'\/><\/noscript><\/figure>\n<h3><span class=\"ez-toc-section\" id=\"Funcion-Power-BI-DAX-RANDBETWEEN\"><\/span>Funci\u00f3n Power BI DAX RANDBETWEEN<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p>La funci\u00f3n DAX RANDBETWEEN en Power BI devuelve el n\u00famero aleatorio entre los valores inicial y final especificados por el usuario.  La sintaxis de la funci\u00f3n Power BI DAX RANDBETWEEN es:<\/p>\n<pre class=\"wp-block-preformatted lang:tsql decode:true\">RANDBETWEEN(start, end)<\/pre>\n<p>Perm\u00edtanme crear una nueva columna para generar valores aleatorios entre 10 y 50<\/p>\n<pre class=\"wp-block-preformatted lang:tsql decode:true\">RANDBET = RANDBETWEEN(10, 50)<\/pre>\n<figure class=\"wp-block-image\"><img alt='power-bi-dax-math-functions-22-5476290' width='1055' height='622' alt=\"Funci\u00f3n Power BI DAX RANDBETWEEN 22\" class=\"wp-image-33327\" srcset='\/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Power-BI-DAX-Math-Functions-22-5476290.png 1055w, \/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Power-BI-DAX-Math-Functions-22-5476290-300x177.png 300w, \/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Power-BI-DAX-Math-Functions-22-5476290-1024x604.png 1024w, \/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Power-BI-DAX-Math-Functions-22-5476290-768x453.png 768w' data-lazy-sizes='(max-width: 1055px) 100vw, 1055px' src='https:\/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Power-BI-DAX-Math-Functions-22-5476290.png'\/><noscript><img alt='power-bi-dax-math-functions-22-7514970' width='1055' height='622' src='https:\/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Power-BI-DAX-Math-Functions-22-7514970.png' alt=\"Funci\u00f3n Power BI DAX RANDBETWEEN 22\" class=\"wp-image-33327\" srcset='\/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Power-BI-DAX-Math-Functions-22-7514970.png 1055w, \/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Power-BI-DAX-Math-Functions-22-7514970-300x177.png 300w, \/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Power-BI-DAX-Math-Functions-22-7514970-1024x604.png 1024w, \/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Power-BI-DAX-Math-Functions-22-7514970-768x453.png 768w' sizes='(max-width: 1055px) 100vw, 1055px'\/><\/noscript><\/figure>\n<h3><span class=\"ez-toc-section\" id=\"Funcion-Power-BI-DAX-TRUNC\"><\/span>Funci\u00f3n Power BI DAX TRUNC<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p>La funci\u00f3n Power BI DAX TRUNC trunca el n\u00famero dado a un entero quitando los decimales.  La sintaxis de la funci\u00f3n Power BI DAX TRUNC es:<\/p>\n<pre class=\"wp-block-preformatted lang:tsql decode:true\">TRUNC(number, num_of_digits)<\/pre>\n<p>Esta funci\u00f3n matem\u00e1tica de Power BI DAX trunca los valores de la columna de ventas<\/p>\n<pre class=\"wp-block-preformatted lang:tsql decode:true\">TRUNC = TRUNC(EmployeeSales[Sales], 1)<\/pre>\n<figure class=\"wp-block-image\"><img alt='power-bi-dax-math-functions-23-6606727' width='1056' height='724' alt=\"Funci\u00f3n 23 de Power BI DAX TRUNC\" class=\"wp-image-33328\" srcset='\/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Power-BI-DAX-Math-Functions-23-6606727.png 1056w, \/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Power-BI-DAX-Math-Functions-23-6606727-300x206.png 300w, \/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Power-BI-DAX-Math-Functions-23-6606727-1024x702.png 1024w, \/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Power-BI-DAX-Math-Functions-23-6606727-768x527.png 768w' data-lazy-sizes='(max-width: 1056px) 100vw, 1056px' src='https:\/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Power-BI-DAX-Math-Functions-23-6606727.png'\/><noscript><img alt='power-bi-dax-math-functions-23-4109421' width='1056' height='724' src='https:\/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Power-BI-DAX-Math-Functions-23-4109421.png' alt=\"Funci\u00f3n 23 de Power BI DAX TRUNC\" class=\"wp-image-33328\" srcset='\/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Power-BI-DAX-Math-Functions-23-4109421.png 1056w, \/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Power-BI-DAX-Math-Functions-23-4109421-300x206.png 300w, \/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Power-BI-DAX-Math-Functions-23-4109421-1024x702.png 1024w, \/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Power-BI-DAX-Math-Functions-23-4109421-768x527.png 768w' sizes='(max-width: 1056px) 100vw, 1056px'\/><\/noscript><\/figure>\n<h3><span class=\"ez-toc-section\" id=\"Funcion-ROUNDDOWN-de-Power-BI-DAX\"><\/span>Funci\u00f3n ROUNDDOWN de Power BI DAX<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p>La funci\u00f3n ROUNDDOWN de Power BI DAX redondea el n\u00famero dado hacia un cero.  La sintaxis de la funci\u00f3n ROUNDDOWN de Power BI DAX es:<\/p>\n<pre class=\"wp-block-preformatted lang:tsql decode:true\">ROUNDDOWN(number, num_of_digits)<\/pre>\n<p>Redondea hacia abajo los valores de la columna de Ventas a 2 d\u00edgitos.<\/p>\n<pre class=\"wp-block-preformatted lang:tsql decode:true\">ROUNDDOWN = ROUNDDOWN(EmployeeSales[Sales], -2)<\/pre>\n<figure class=\"wp-block-image\"><img alt='power-bi-dax-math-functions-24-2283482' width='1055' height='623' alt=\"Funci\u00f3n REDONDEO de Power BI DAX 24\" class=\"wp-image-33329\" srcset='\/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Power-BI-DAX-Math-Functions-24-2283482.png 1055w, \/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Power-BI-DAX-Math-Functions-24-2283482-300x177.png 300w, \/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Power-BI-DAX-Math-Functions-24-2283482-1024x605.png 1024w, \/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Power-BI-DAX-Math-Functions-24-2283482-768x454.png 768w' data-lazy-sizes='(max-width: 1055px) 100vw, 1055px' src='https:\/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Power-BI-DAX-Math-Functions-24-2283482.png'\/><noscript><img alt='power-bi-dax-math-functions-24-7591793' width='1055' height='623' src='https:\/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Power-BI-DAX-Math-Functions-24-7591793.png' alt=\"Funci\u00f3n REDONDEO de Power BI DAX 24\" class=\"wp-image-33329\" srcset='\/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Power-BI-DAX-Math-Functions-24-7591793.png 1055w, \/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Power-BI-DAX-Math-Functions-24-7591793-300x177.png 300w, \/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Power-BI-DAX-Math-Functions-24-7591793-1024x605.png 1024w, \/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Power-BI-DAX-Math-Functions-24-7591793-768x454.png 768w' sizes='(max-width: 1055px) 100vw, 1055px'\/><\/noscript><\/figure>\n<h3><span class=\"ez-toc-section\" id=\"Funcion-ROUNDUP-de-Power-BI-DAX\"><\/span>Funci\u00f3n ROUNDUP de Power BI DAX<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p>La funci\u00f3n ROUNDUP de Power BI DAX redondea el n\u00famero dado desde cero.  La sintaxis de la funci\u00f3n ROUNDUP de Power BI DAX es:<\/p>\n<pre class=\"wp-block-preformatted lang:tsql decode:true\">ROUNDUP(number, num_of_digits)<\/pre>\n<p>La siguiente declaraci\u00f3n redondea los valores de la columna de Ventas a 2 d\u00edgitos (es decir, mayor que el original).<\/p>\n<pre class=\"wp-block-preformatted lang:tsql decode:true\">ROUNDUP = ROUNDUP(EmployeeSales[Sales], -2)<\/pre>\n<figure class=\"wp-block-image\"><img alt='power-bi-dax-math-functions-25-5153883' width='1055' height='623' alt=\"Funci\u00f3n REDONDEO de Power BI DAX 25\" class=\"wp-image-33330\" srcset='\/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Power-BI-DAX-Math-Functions-25-5153883.png 1055w, \/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Power-BI-DAX-Math-Functions-25-5153883-300x177.png 300w, \/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Power-BI-DAX-Math-Functions-25-5153883-1024x605.png 1024w, \/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Power-BI-DAX-Math-Functions-25-5153883-768x454.png 768w' data-lazy-sizes='(max-width: 1055px) 100vw, 1055px' src='https:\/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Power-BI-DAX-Math-Functions-25-5153883.png'\/><noscript><img alt='power-bi-dax-math-functions-25-6112549' width='1055' height='623' src='https:\/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Power-BI-DAX-Math-Functions-25-6112549.png' alt=\"Funci\u00f3n REDONDEO de Power BI DAX 25\" class=\"wp-image-33330\" srcset='\/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Power-BI-DAX-Math-Functions-25-6112549.png 1055w, \/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Power-BI-DAX-Math-Functions-25-6112549-300x177.png 300w, \/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Power-BI-DAX-Math-Functions-25-6112549-1024x605.png 1024w, \/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Power-BI-DAX-Math-Functions-25-6112549-768x454.png 768w' sizes='(max-width: 1055px) 100vw, 1055px'\/><\/noscript><\/figure>\n<h3><span class=\"ez-toc-section\" id=\"Funcion-Power-BI-DAX-LCM\"><\/span>Funci\u00f3n Power BI DAX LCM<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p>La funci\u00f3n DAX LCM encuentra el m\u00ednimo com\u00fan o el m\u00ednimo com\u00fan de varios valores enteros.  La sintaxis de esta funci\u00f3n de Power BI DAX LCM es:<\/p>\n<pre class=\"wp-block-preformatted lang:tsql decode:true\">LCM(expression1, expression2,.....)<\/pre>\n<p>Devuelve el m\u00ednimo com\u00fan del resultado SQRT y el resultado de la funci\u00f3n MOD<\/p>\n<pre class=\"wp-block-preformatted lang:tsql decode:true\">LCM = LCM(EmployeeSales[SQRT], EmployeeSales[MOD])<\/pre>\n<figure class=\"wp-block-image\"><img alt='power-bi-dax-math-functions-26-1309047' width='1056' height='650' alt=\"Funci\u00f3n 26 de Power BI DAX LCM\" class=\"wp-image-33331\" srcset='\/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Power-BI-DAX-Math-Functions-26-1309047.png 1056w, \/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Power-BI-DAX-Math-Functions-26-1309047-300x185.png 300w, \/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Power-BI-DAX-Math-Functions-26-1309047-1024x630.png 1024w, \/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Power-BI-DAX-Math-Functions-26-1309047-768x473.png 768w' data-lazy-sizes='(max-width: 1056px) 100vw, 1056px' src='https:\/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Power-BI-DAX-Math-Functions-26-1309047.png'\/><noscript><img alt='power-bi-dax-math-functions-26-6663905' width='1056' height='650' src='https:\/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Power-BI-DAX-Math-Functions-26-6663905.png' alt=\"Funci\u00f3n 26 de Power BI DAX LCM\" class=\"wp-image-33331\" srcset='\/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Power-BI-DAX-Math-Functions-26-6663905.png 1056w, \/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Power-BI-DAX-Math-Functions-26-6663905-300x185.png 300w, \/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Power-BI-DAX-Math-Functions-26-6663905-1024x630.png 1024w, \/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Power-BI-DAX-Math-Functions-26-6663905-768x473.png 768w' sizes='(max-width: 1056px) 100vw, 1056px'\/><\/noscript><\/figure>\n<h3><span class=\"ez-toc-section\" id=\"Funcion-Power-BI-DAX-GCD\"><\/span>Funci\u00f3n Power BI DAX GCD<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p>La funci\u00f3n GCD de Power BI DAX busca el mayor divisor com\u00fan de varios valores enteros.  La sintaxis de la funci\u00f3n Power BI DAX GCD es:<\/p>\n<pre class=\"wp-block-preformatted lang:tsql decode:true\">GCD(expression1, expression2,.....)<\/pre>\n<p>Esta funci\u00f3n matem\u00e1tica de Power BI DAX devuelve el resultado de la funci\u00f3n de divisor com\u00fan m\u00e1s grande de SQRT y el resultado de MOD<\/p>\n<pre class=\"wp-block-preformatted lang:tsql decode:true\">GCD = GCD(EmployeeSales[SQRT], EmployeeSales[MOD])<\/pre>\n<figure class=\"wp-block-image\"><img alt='power-bi-dax-math-functions-27-5015011' width='1056' height='623' alt=\"Funci\u00f3n 27 de Power BI DAX GCD\" class=\"wp-image-33332\" srcset='\/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Power-BI-DAX-Math-Functions-27-5015011.png 1056w, \/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Power-BI-DAX-Math-Functions-27-5015011-300x177.png 300w, \/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Power-BI-DAX-Math-Functions-27-5015011-1024x604.png 1024w, \/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Power-BI-DAX-Math-Functions-27-5015011-768x453.png 768w' data-lazy-sizes='(max-width: 1056px) 100vw, 1056px' src='https:\/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Power-BI-DAX-Math-Functions-27-5015011.png'\/><noscript><img alt='power-bi-dax-math-functions-27-6779070' width='1056' height='623' src='https:\/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Power-BI-DAX-Math-Functions-27-6779070.png' alt=\"Funci\u00f3n 27 de Power BI DAX GCD\" class=\"wp-image-33332\" srcset='\/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Power-BI-DAX-Math-Functions-27-6779070.png 1056w, \/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Power-BI-DAX-Math-Functions-27-6779070-300x177.png 300w, \/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Power-BI-DAX-Math-Functions-27-6779070-1024x604.png 1024w, \/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Power-BI-DAX-Math-Functions-27-6779070-768x453.png 768w' sizes='(max-width: 1056px) 100vw, 1056px'\/><\/noscript><\/figure>\n<\/div>\n","protected":false},"excerpt":{"rendered":"<p>How to use Power BI DAX math functions with examples? Microsoft Power BI DAX provides various math or math functions like ROOF, FLOOR, CURRENCY, INT, SQRT, POWER, MOD, DIVIDE,\u2026<\/p>","protected":false},"author":1,"featured_media":84071,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[1359,1360],"tags":[],"class_list":["post-84073","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 matem\u00e1ticas de Power BI DAX - R Marketing Digital<\/title>\n<meta name=\"description\" content=\"\u00bfC\u00f3mo usar las funciones matem\u00e1ticas de Power BI DAX con ejemplos? Microsoft Power BI DAX proporciona varias funciones matem\u00e1ticas o matem\u00e1ticas como\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/rmarketingdigital.com\/en\/powerbi\/funciones-matematicas-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 matem\u00e1ticas de Power BI DAX\" \/>\n<meta property=\"og:description\" content=\"\u00bfC\u00f3mo usar las funciones matem\u00e1ticas de Power BI DAX con ejemplos? Microsoft Power BI DAX proporciona varias funciones matem\u00e1ticas o matem\u00e1ticas como\" \/>\n<meta property=\"og:url\" content=\"https:\/\/rmarketingdigital.com\/en\/powerbi\/funciones-matematicas-de-power-bi-dax\/\" \/>\n<meta property=\"og:site_name\" content=\"R Marketing Digital\" \/>\n<meta property=\"article:published_time\" content=\"2022-08-20T00:50:51+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Power-BI-DAX-Math-Functions-6-8442658.png\" \/>\n\t<meta property=\"og:image:width\" content=\"1078\" \/>\n\t<meta property=\"og:image:height\" content=\"705\" \/>\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-matematicas-de-power-bi-dax\\\/#article\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/rmarketingdigital.com\\\/powerbi\\\/funciones-matematicas-de-power-bi-dax\\\/\"},\"author\":{\"name\":\"R Marketing Digital\",\"@id\":\"https:\\\/\\\/rmarketingdigital.com\\\/#\\\/schema\\\/person\\\/7c0d9782b2977b840b3740f00c69a73e\"},\"headline\":\"Funciones matem\u00e1ticas de Power BI DAX\",\"datePublished\":\"2022-08-20T00:50:51+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\\\/\\\/rmarketingdigital.com\\\/powerbi\\\/funciones-matematicas-de-power-bi-dax\\\/\"},\"wordCount\":1469,\"image\":{\"@id\":\"https:\\\/\\\/rmarketingdigital.com\\\/powerbi\\\/funciones-matematicas-de-power-bi-dax\\\/#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/rmarketingdigital.com\\\/wp-content\\\/uploads\\\/2020\\\/09\\\/Power-BI-DAX-Math-Functions-6-8442658.png\",\"articleSection\":[\"Power BI\",\"Tutoriales PowerBI\"],\"inLanguage\":\"en-US\"},{\"@type\":\"WebPage\",\"@id\":\"https:\\\/\\\/rmarketingdigital.com\\\/powerbi\\\/funciones-matematicas-de-power-bi-dax\\\/\",\"url\":\"https:\\\/\\\/rmarketingdigital.com\\\/powerbi\\\/funciones-matematicas-de-power-bi-dax\\\/\",\"name\":\"Funciones matem\u00e1ticas de Power BI DAX - R Marketing Digital\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/rmarketingdigital.com\\\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\\\/\\\/rmarketingdigital.com\\\/powerbi\\\/funciones-matematicas-de-power-bi-dax\\\/#primaryimage\"},\"image\":{\"@id\":\"https:\\\/\\\/rmarketingdigital.com\\\/powerbi\\\/funciones-matematicas-de-power-bi-dax\\\/#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/rmarketingdigital.com\\\/wp-content\\\/uploads\\\/2020\\\/09\\\/Power-BI-DAX-Math-Functions-6-8442658.png\",\"datePublished\":\"2022-08-20T00:50:51+00:00\",\"author\":{\"@id\":\"https:\\\/\\\/rmarketingdigital.com\\\/#\\\/schema\\\/person\\\/7c0d9782b2977b840b3740f00c69a73e\"},\"description\":\"\u00bfC\u00f3mo usar las funciones matem\u00e1ticas de Power BI DAX con ejemplos? Microsoft Power BI DAX proporciona varias funciones matem\u00e1ticas o matem\u00e1ticas como\",\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\\\/\\\/rmarketingdigital.com\\\/powerbi\\\/funciones-matematicas-de-power-bi-dax\\\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\\\/\\\/rmarketingdigital.com\\\/powerbi\\\/funciones-matematicas-de-power-bi-dax\\\/#primaryimage\",\"url\":\"https:\\\/\\\/rmarketingdigital.com\\\/wp-content\\\/uploads\\\/2020\\\/09\\\/Power-BI-DAX-Math-Functions-6-8442658.png\",\"contentUrl\":\"https:\\\/\\\/rmarketingdigital.com\\\/wp-content\\\/uploads\\\/2020\\\/09\\\/Power-BI-DAX-Math-Functions-6-8442658.png\",\"width\":1078,\"height\":705,\"caption\":\"power-bi-dax-math-functions-6-8442658-9086635-png\"},{\"@type\":\"WebSite\",\"@id\":\"https:\\\/\\\/rmarketingdigital.com\\\/#website\",\"url\":\"https:\\\/\\\/rmarketingdigital.com\\\/\",\"name\":\"R Marketing Digital\",\"description\":\"Agencia SEO | Publicidad redes sociales | Community Management\",\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\\\/\\\/rmarketingdigital.com\\\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":\"Person\",\"@id\":\"https:\\\/\\\/rmarketingdigital.com\\\/#\\\/schema\\\/person\\\/7c0d9782b2977b840b3740f00c69a73e\",\"name\":\"R Marketing Digital\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/c5599c203e0120b8ccbff4666af86f35f9b3dcad468a8bc6295313a3964a80be?s=96&d=mm&r=g\",\"url\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/c5599c203e0120b8ccbff4666af86f35f9b3dcad468a8bc6295313a3964a80be?s=96&d=mm&r=g\",\"contentUrl\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/c5599c203e0120b8ccbff4666af86f35f9b3dcad468a8bc6295313a3964a80be?s=96&d=mm&r=g\",\"caption\":\"R Marketing Digital\"}}]}<\/script>\n<!-- \/ Yoast SEO Premium plugin. -->","yoast_head_json":{"title":"Power BI DAX math functions - R Marketing Digital","description":"How to use Power BI DAX math functions with examples? Microsoft Power BI DAX provides various mathematical or mathematical functions such as","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-matematicas-de-power-bi-dax\/","og_locale":"en_US","og_type":"article","og_title":"Funciones matem\u00e1ticas de Power BI DAX","og_description":"\u00bfC\u00f3mo usar las funciones matem\u00e1ticas de Power BI DAX con ejemplos? Microsoft Power BI DAX proporciona varias funciones matem\u00e1ticas o matem\u00e1ticas como","og_url":"https:\/\/rmarketingdigital.com\/en\/powerbi\/funciones-matematicas-de-power-bi-dax\/","og_site_name":"R Marketing Digital","article_published_time":"2022-08-20T00:50:51+00:00","og_image":[{"width":1078,"height":705,"url":"https:\/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Power-BI-DAX-Math-Functions-6-8442658.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-matematicas-de-power-bi-dax\/#article","isPartOf":{"@id":"https:\/\/rmarketingdigital.com\/powerbi\/funciones-matematicas-de-power-bi-dax\/"},"author":{"name":"R Marketing Digital","@id":"https:\/\/rmarketingdigital.com\/#\/schema\/person\/7c0d9782b2977b840b3740f00c69a73e"},"headline":"Funciones matem\u00e1ticas de Power BI DAX","datePublished":"2022-08-20T00:50:51+00:00","mainEntityOfPage":{"@id":"https:\/\/rmarketingdigital.com\/powerbi\/funciones-matematicas-de-power-bi-dax\/"},"wordCount":1469,"image":{"@id":"https:\/\/rmarketingdigital.com\/powerbi\/funciones-matematicas-de-power-bi-dax\/#primaryimage"},"thumbnailUrl":"https:\/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Power-BI-DAX-Math-Functions-6-8442658.png","articleSection":["Power BI","Tutoriales PowerBI"],"inLanguage":"en-US"},{"@type":"WebPage","@id":"https:\/\/rmarketingdigital.com\/powerbi\/funciones-matematicas-de-power-bi-dax\/","url":"https:\/\/rmarketingdigital.com\/powerbi\/funciones-matematicas-de-power-bi-dax\/","name":"Power BI DAX math functions - R Marketing Digital","isPartOf":{"@id":"https:\/\/rmarketingdigital.com\/#website"},"primaryImageOfPage":{"@id":"https:\/\/rmarketingdigital.com\/powerbi\/funciones-matematicas-de-power-bi-dax\/#primaryimage"},"image":{"@id":"https:\/\/rmarketingdigital.com\/powerbi\/funciones-matematicas-de-power-bi-dax\/#primaryimage"},"thumbnailUrl":"https:\/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Power-BI-DAX-Math-Functions-6-8442658.png","datePublished":"2022-08-20T00:50:51+00:00","author":{"@id":"https:\/\/rmarketingdigital.com\/#\/schema\/person\/7c0d9782b2977b840b3740f00c69a73e"},"description":"How to use Power BI DAX math functions with examples? Microsoft Power BI DAX provides various mathematical or mathematical functions such as","inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/rmarketingdigital.com\/powerbi\/funciones-matematicas-de-power-bi-dax\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/rmarketingdigital.com\/powerbi\/funciones-matematicas-de-power-bi-dax\/#primaryimage","url":"https:\/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Power-BI-DAX-Math-Functions-6-8442658.png","contentUrl":"https:\/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Power-BI-DAX-Math-Functions-6-8442658.png","width":1078,"height":705,"caption":"power-bi-dax-math-functions-6-8442658-9086635-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\/84073","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=84073"}],"version-history":[{"count":0,"href":"https:\/\/rmarketingdigital.com\/en\/wp-json\/wp\/v2\/posts\/84073\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/rmarketingdigital.com\/en\/wp-json\/wp\/v2\/media\/84071"}],"wp:attachment":[{"href":"https:\/\/rmarketingdigital.com\/en\/wp-json\/wp\/v2\/media?parent=84073"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/rmarketingdigital.com\/en\/wp-json\/wp\/v2\/categories?post=84073"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/rmarketingdigital.com\/en\/wp-json\/wp\/v2\/tags?post=84073"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}