{"id":35,"date":"2026-10-08T07:53:24","date_gmt":"2026-10-07T22:53:24","guid":{"rendered":"https:\/\/vera-b.com\/?p=35"},"modified":"2026-10-08T07:53:24","modified_gmt":"2026-10-07T22:53:24","slug":"dax-max-%ed%95%a8%ec%88%98-%ec%a0%95%eb%a6%ac-%ea%b0%80%ec%9e%a5-%ec%b5%9c%ea%b7%bc-%eb%82%a0%ec%a7%9c%ec%99%80-%ec%b5%9c%ea%b3%a0%ea%b0%92-%ed%95%98%ed%95%9c-%eb%91%90%ea%b8%b0%ec%99%80-%eb%b9%88","status":"publish","type":"post","link":"https:\/\/vera-b.com\/?p=35","title":{"rendered":"DAX MAX \ud568\uc218 \uc815\ub9ac: \uac00\uc7a5 \ucd5c\uadfc \ub0a0\uc9dc\uc640 \ucd5c\uace0\uac12, \ud558\ud55c \ub450\uae30\uc640 \ube48 \uac12\uc758 \ud568\uc815"},"content":{"rendered":"\n<p>\uac00\uc7a5 \ucd5c\uadfc \uc8fc\ubb38\uc77c, \uac00\uc7a5 \ube44\uc2fc \ub2e8\uac00, \ub450 \uac12 \uc911 \ud070 \ucabd. \uc774\ub7f0 &#8220;\uac00\uc7a5 \ud070 \uac12&#8221;\uc774 \ud544\uc694\ud560 \ub54c \uc4f0\ub294 \ud568\uc218\uac00 MAX\uc785\ub2c8\ub2e4. \uc55e\uc11c \uc815\ub9ac\ud55c <a href=\"https:\/\/vera-b.com\/?p=33\">MIN \ud568\uc218 \uae00<\/a>\uc758 \uac70\uc6b8 \uac19\uc740 \ud568\uc218\ub77c\uc11c \uc0ac\uc6a9\ubc95\uc740 \uac70\uc758 \uac19\uc2b5\ub2c8\ub2e4. \uadf8\ub798\uc11c \uc624\ud788\ub824 \uac19\uc740 \uc9c0\uc810\uc5d0\uc11c \uac19\uc740 \uc2e4\uc218\ub97c \ud558\uae30 \uc27d\uc2b5\ub2c8\ub2e4. \uc5f4 \ud558\ub098\ub97c \ubc1b\ub294 \ud615\ud0dc\uc640 \uac12 \ub450 \uac1c\ub97c \ubc1b\ub294 \ud615\ud0dc\uac00 \ub530\ub85c \uc788\uace0, \ub450 \ubc88\uc9f8 \ud615\ud0dc\uc5d0\uc11c \ube48 \uac12\uc744 \ub2e4\ub8e8\ub294 \ubc29\uc2dd\uc774 \ubb38\uc11c\ub9c8\ub2e4 \ub2e4\ub974\uac8c \uc801\ud600 \uc788\ub2e4\ub294 \uc810\uc774 \ud2b9\ud788 \uadf8\ub807\uc2b5\ub2c8\ub2e4. \uc774 \uae00\uc5d0\uc11c\ub294 \ub450 \ud615\ud0dc\uc758 \ucc28\uc774, \uc2e4\ubb34\uc5d0\uc11c \uc790\uc8fc \uc4f0\ub294 \uc138 \uac00\uc9c0 \uc0c1\ud669, \uadf8\ub9ac\uace0 \ube48 \uac12\uc5d0\uc11c \uc870\uc2ec\ud560 \uc810\uc744 \uc815\ub9ac\ud569\ub2c8\ub2e4.<\/p>\n\n<h2>\ubb38\ubc95: \ub450 \uac00\uc9c0 \ud615\ud0dc<\/h2>\n\n<pre><code>MAX( &lt;\uc5f4&gt; )\nMAX( &lt;\uc2dd1&gt;, &lt;\uc2dd2&gt; )<\/code><\/pre>\n\n<p>Microsoft \ubb38\uc11c\uc758 \uc124\uba85\ub300\ub85c MAX\ub294 &#8220;\uc5f4\uc5d0\uc11c \uac00\uc7a5 \ud070 \uac12, \ub610\ub294 \ub450 \uc2dd \uc0ac\uc774\uc5d0\uc11c \ub354 \ud070 \uac12&#8221;\uc744 \ub3cc\ub824\uc90d\ub2c8\ub2e4. \uc5f4 \ud615\ud0dc\uc5d0 \ub0a0\uc9dc\ub97c \uc4f0\uba74 \uac00\uc7a5 \ucd5c\uadfc \ub0a0\uc9dc\uac00 \ubc18\ud658\ub418\uace0, DAX Guide\ub294 \ubb38\uc790\uc5f4\uc740 \uc54c\ud30c\ubcb3(\uc0ac\uc804) \uc21c\uc11c\ub85c \ube44\uad50\ud558\uba70 \ub17c\ub9ac\uac12\uc740 \ubb34\uc2dc\ud55c\ub2e4\uace0 \uc124\uba85\ud569\ub2c8\ub2e4. \uac12\uc774 \uc788\ub294 \ud589\uc774 \ud558\ub098\ub3c4 \uc5c6\uc73c\uba74 \ube48 \uac12\uc744 \ub3cc\ub824\uc90d\ub2c8\ub2e4.<\/p>\n\n<h2>Power BI Desktop\uc5d0\uc11c \uce21\uc815\uac12\uc73c\ub85c \ub9cc\ub4e4\uae30<\/h2>\n\n<p>\uba54\ub274 \uc774\ub984\uc740 Power BI \ubc84\uc804\uacfc \uc5b8\uc5b4 \uc124\uc815\uc5d0 \ub530\ub77c \uc870\uae08 \ub2e4\ub97c \uc218 \uc788\ub2e4\ub294 \uc810\uc744 \uba3c\uc800 \ub9d0\uc500\ub4dc\ub9bd\ub2c8\ub2e4. \uc77c\ubc18\uc801\uc778 \uc21c\uc11c\ub294 \uc774\ub807\uc2b5\ub2c8\ub2e4.<\/p>\n\n<ol>\n<li>\ubcf4\uace0\uc11c \ubcf4\uae30\uc5d0\uc11c \uc624\ub978\ucabd \ud544\ub4dc \ucc3d\uc758 \ud14c\uc774\ube14(\uc608: Sales)\uc744 \uc120\ud0dd\ud569\ub2c8\ub2e4.<\/li>\n<li>\uc0c1\ub2e8 \ub9ac\ubcf8\uc5d0\uc11c &#8220;\uc0c8 \uce21\uc815\uac12&#8221;(\uc601\ubb38\ud310\uc740 New measure)\uc744 \ub204\ub985\ub2c8\ub2e4.<\/li>\n<li>\uc218\uc2dd \uc785\ub825\uc904\uc5d0 <code>\ucd5c\uace0\ub2e8\uac00 = MAX( Sales[\ub2e8\uac00] )<\/code>\ucc98\ub7fc \uc774\ub984\uacfc \uc2dd\uc744 \uc801\uace0 Enter\ub97c \ub204\ub985\ub2c8\ub2e4.<\/li>\n<li>\ub9cc\ub4e0 \uce21\uc815\uac12\uc744 \ud45c \uc2dc\uac01\ud654\uc5d0 \uc62c\ub9ac\uace0 \uc0c1\ud488 \uac19\uc740 \uc5f4\uacfc \ud568\uaed8 \ub193\uc544 \uc904\ub9c8\ub2e4 \uac12\uc774 \uc5b4\ub5bb\uac8c \ub2ec\ub77c\uc9c0\ub294\uc9c0 \ud655\uc778\ud569\ub2c8\ub2e4.<\/li>\n<\/ol>\n\n<h2>\uc608\uc81c \ub370\uc774\ud130<\/h2>\n\n<p>\uc55e\uc120 <a href=\"https:\/\/vera-b.com\/?p=22\">SUM<\/a>, <a href=\"https:\/\/vera-b.com\/?p=23\">SUMX<\/a>, <a href=\"https:\/\/vera-b.com\/?p=24\">AVERAGE<\/a> \uae00\uacfc \uc774\uc5b4\uc9c0\ub294 \uac00\uc0c1 \ub370\uc774\ud130\uc785\ub2c8\ub2e4. \uacb0\uacfc\ub294 Power BI\uc5d0\uc11c \ub3cc\ub9b0 \ud654\uba74\uc774 \uc544\ub2c8\ub77c \uc9c1\uc811 \uad6c\ud55c \uac12\uc774\ub2c8, \uac19\uc740 \uc2dd\uc744 \ubcf8\uc778 \ub370\uc774\ud130\uc5d0 \uc801\uc6a9\ud574\uc11c \ud655\uc778\ud574 \ubcf4\uc138\uc694.<\/p>\n\n<table style=\"border-collapse:collapse;\" border=\"1\" cellpadding=\"8\">\n<thead><tr><th>\uc8fc\ubb38<\/th><th>\uc8fc\ubb38\uc77c<\/th><th>\uc0c1\ud488<\/th><th>\uc218\ub7c9<\/th><th>\ub2e8\uac00<\/th><\/tr><\/thead>\n<tbody>\n<tr><td>1<\/td><td>3\/2<\/td><td>\ub178\ud2b8\ubd81<\/td><td>1<\/td><td>120<\/td><\/tr>\n<tr><td>2<\/td><td>3\/3<\/td><td>\ub9c8\uc6b0\uc2a4<\/td><td>3<\/td><td>4<\/td><\/tr>\n<tr><td>3<\/td><td>3\/5<\/td><td>\ubaa8\ub2c8\ud130<\/td><td>2<\/td><td>20<\/td><\/tr>\n<tr><td>4<\/td><td>3\/7<\/td><td>\ub9c8\uc6b0\uc2a4<\/td><td>5<\/td><td>4<\/td><\/tr>\n<tr><td>5<\/td><td>3\/9<\/td><td>\ub178\ud2b8\ubd81<\/td><td>2<\/td><td>100<\/td><\/tr>\n<\/tbody>\n<\/table>\n\n<h2>\uc2e4\ubb34 \uc2dc\ub098\ub9ac\uc624 1: \uac00\uc7a5 \ucd5c\uadfc \ub0a0\uc9dc\uc640 \uac00\uc7a5 \ub192\uc740 \uac12<\/h2>\n\n<pre><code>\ub9c8\uc9c0\ub9c9\uc8fc\ubb38\uc77c = MAX( Sales[\uc8fc\ubb38\uc77c] )\n\ucd5c\uace0\ub2e8\uac00 = MAX( Sales[\ub2e8\uac00] )<\/code><\/pre>\n\n<p>\ub9c8\uc9c0\ub9c9 \uc8fc\ubb38\uc77c\uc740 <strong>3\/9<\/strong>(5\ubc88 \uc8fc\ubb38)\uc774\uace0, \ucd5c\uace0 \ub2e8\uac00\ub294 \ub178\ud2b8\ubd81\uc758 <strong>120<\/strong>\uc785\ub2c8\ub2e4. \uc0c1\ud488\ubcc4 \ud45c\uc5d0 \uc62c\ub9ac\uba74 \uc0c1\ud488\ub9c8\ub2e4 \ub530\ub85c \uacc4\uc0b0\ub429\ub2c8\ub2e4.<\/p>\n\n<table style=\"border-collapse:collapse;\" border=\"1\" cellpadding=\"8\">\n<thead><tr><th>\uc0c1\ud488<\/th><th>\ub9c8\uc9c0\ub9c9\uc8fc\ubb38\uc77c<\/th><th>\ucd5c\uace0\ub2e8\uac00<\/th><\/tr><\/thead>\n<tbody>\n<tr><td>\ub178\ud2b8\ubd81<\/td><td>3\/9<\/td><td>120<\/td><\/tr>\n<tr><td>\ub9c8\uc6b0\uc2a4<\/td><td>3\/7<\/td><td>4<\/td><\/tr>\n<tr><td>\ubaa8\ub2c8\ud130<\/td><td>3\/5<\/td><td>20<\/td><\/tr>\n<tr><td>\ud569\uacc4<\/td><td>3\/9<\/td><td>120<\/td><\/tr>\n<\/tbody>\n<\/table>\n\n<p>\ub178\ud2b8\ubd81\uc740 \ub2e8\uac00 120\uacfc 100 \uc911 \ud070 120\uc785\ub2c8\ub2e4. \ud569\uacc4 \uc904\uc740 \uc904\ub4e4\uc758 \uac12\uc744 \ub2e4\uc2dc \ubaa8\uc740 \uac83\uc774 \uc544\ub2c8\ub77c \ud544\ud130 \uc5c6\uc774 \uc804\uccb4\uc5d0\uc11c \uc0c8\ub85c \uad6c\ud55c \uac12\uc774\uace0, \ucd5c\ub313\uac12\uc740 \uadf8 \uacb0\uacfc\uac00 \uc6b0\uc5f0\ud788 \uc904\ub4e4\uc758 \ucd5c\ub313\uac12\uacfc \uac19\uc544 \ubcf4\uc77c \ubfd0\uc785\ub2c8\ub2e4. \uc774 &#8220;\ub9c8\uc9c0\ub9c9 \uc8fc\ubb38\uc77c&#8221;\uc740 &#8220;\ub9c8\uc9c0\ub9c9 \uc8fc\ubb38 \uc774\ud6c4 \uba70\uce60\uc774 \uc9c0\ub0ac\ub294\uac00&#8221; \uac19\uc740 \uacbd\uacfc\uc77c \uacc4\uc0b0\uc758 \ucd9c\ubc1c\uc810\uc73c\ub85c \uc790\uc8fc \uc4f0\uc785\ub2c8\ub2e4.<\/p>\n\n<h2>\uc2e4\ubb34 \uc2dc\ub098\ub9ac\uc624 2: \ub450 \uac12 \uc911 \ud070 \uac12\uc73c\ub85c \ud558\ud55c \ub450\uae30<\/h2>\n\n<p>MAX\uc758 \ub450 \ubc88\uc9f8 \ud615\ud0dc\ub294 &#8220;\ub354 \ud070 \ucabd\uc744 \uace0\ub978\ub2e4&#8221;\ub294 \ub73b\uc774\ub77c\uc11c, \uac12\uc5d0 \ud558\ud55c\uc744 \ub458 \ub54c \uc501\ub2c8\ub2e4. \uc608\ub97c \ub4e4\uc5b4 \uc218\ub2f9\uc744 \uacc4\uc0b0\ud560 \ub54c \uc2e4\uc801\uc5d0 \ub530\ub978 \uae08\uc561\uc774 \uc788\ub354\ub77c\ub3c4 \ucd5c\uc18c \ubcf4\uc7a5\uc561 50\ubcf4\ub2e4 \ub0ae\uc544\uc9c0\uc9c0\ub294 \uc54a\uac8c \ud558\ub294 \uaddc\uce59\uc785\ub2c8\ub2e4.<\/p>\n\n<pre><code>\uc9c0\uae09\uc218\ub2f9 =\nMAX( [\uc2e4\uc801\uc218\ub2f9], [\ucd5c\uc18c\ubcf4\uc7a5\uc561] )<\/code><\/pre>\n\n<table style=\"border-collapse:collapse;\" border=\"1\" cellpadding=\"8\">\n<thead><tr><th>\ud300<\/th><th>\uc2e4\uc801\uc218\ub2f9<\/th><th>\ucd5c\uc18c\ubcf4\uc7a5\uc561<\/th><th>\uc9c0\uae09\uc218\ub2f9<\/th><\/tr><\/thead>\n<tbody>\n<tr><td>A<\/td><td>30<\/td><td>50<\/td><td>50<\/td><\/tr>\n<tr><td>B<\/td><td>80<\/td><td>50<\/td><td>80<\/td><\/tr>\n<\/tbody>\n<\/table>\n\n<p>A\ud300\uc740 \uc2e4\uc801\uc218\ub2f9 30\uc774 \ubcf4\uc7a5\uc561\ubcf4\ub2e4 \uc791\uc73c\ub2c8 50\uc774 \uc9c0\uae09\ub418\uace0, B\ud300\uc740 80\uc774 \ub354 \ud06c\ub2c8 80\uc774 \uc9c0\uae09\ub429\ub2c8\ub2e4. MIN\uc73c\ub85c \uc0c1\ud55c\uc744 \ub450\ub294 \uac83\uacfc \uc815\ubc18\ub300\uc758 \uc4f0\uc784\uc785\ub2c8\ub2e4. \ub2e4\ub9cc \uc774 \ud615\ud0dc\ub294 \ub450 \uac12 \uc911 \ud558\ub098\uac00 \ube48 \uac12\uc77c \ub54c \uacb0\uacfc\uac00 \ubb38\uc11c\ub9c8\ub2e4 \ub2e4\ub974\uac8c \uc801\ud600 \uc788\uc73c\ub2c8, \uc544\ub798 &#8220;\ube48 \uac12&#8221; \ud56d\ubaa9\uc744 \uaf2d \ud655\uc778\ud558\uc138\uc694.<\/p>\n\n<h2>\uc2e4\ubb34 \uc2dc\ub098\ub9ac\uc624 3: \uacc4\uc0b0\ud55c \uac12\ub4e4\uc758 \ucd5c\ub313\uac12 (MAXX)<\/h2>\n\n<p>MAX\ub294 \ubaa8\ub378\uc5d0 \uc788\ub294 \uc5f4\uc744 \ubc1b\uc2b5\ub2c8\ub2e4. \uc218\ub7c9 \u00d7 \ub2e8\uac00\ucc98\ub7fc \ud589\ub9c8\ub2e4 \uacc4\uc0b0\ud55c \uac12\uc758 \ucd5c\ub313\uac12\uc740 MAXX\ub97c \uc501\ub2c8\ub2e4.<\/p>\n\n<pre><code>\ucd5c\ub300\uc8fc\ubb38\uae08\uc561 =\nMAXX(\n    Sales,\n    Sales[\uc218\ub7c9] * Sales[\ub2e8\uac00]\n)<\/code><\/pre>\n\n<p>\ud589\ub9c8\ub2e4 120, 12, 40, 20, 200\uc774 \uacc4\uc0b0\ub418\ubbc0\ub85c \ucd5c\ub313\uac12\uc740 <strong>200<\/strong>(5\ubc88 \uc8fc\ubb38)\uc785\ub2c8\ub2e4. DAX Guide\ub294 \uc5f4 \ud558\ub098\uc5d0 \uc4f4 MAX\uac00 \ub0b4\ubd80\uc801\uc73c\ub85c MAXX\ub97c \uc2e4\ud589\ud558\ub294 \uac83\uacfc \uac19\uace0 \uc131\ub2a5 \ucc28\uc774\uac00 \uc5c6\ub2e4\uace0 \uc124\uba85\ud569\ub2c8\ub2e4. MAX\ub294 \ubaa8\ub378\uc758 \uc5f4\uc5d0\ub9cc \uc4f8 \uc218 \uc788\uc73c\ub2c8, \uacc4\uc0b0\ud55c \uac12\uc774\ub098 \ubcc0\uc218\uc758 \ub0b4\uc6a9\uc744 \ub3cc\uc544\uc57c \ud560 \ub54c\ub294 MAXX\uac00 \ud544\uc694\ud569\ub2c8\ub2e4. MAXX\ub294 \uc120\ud0dd \uc778\uc218\uac00 \ud558\ub098 \ub354 \uc788\ub294\ub370, \uc774 \uae00\uc5d0\uc11c\ub294 \ub2e4\ub8e8\uc9c0 \uc54a\uc2b5\ub2c8\ub2e4.<\/p>\n\n<p>MAXX\ub294 \uce21\uc815\uac12\uc744 \uadf8\ub8f9\ubcc4\ub85c \uacc4\uc0b0\ud55c \ub4a4 \uadf8\uc911 \ucd5c\ub313\uac12\uc744 \uad6c\ud560 \ub54c\ub3c4 \uc501\ub2c8\ub2e4. &#8220;\uc0c1\ud488\ubcc4 \ucd1d\ub9e4\ucd9c \uc911 \uac00\uc7a5 \ud070 \ub9e4\ucd9c&#8221;\uc740 \uc774\ub807\uac8c \uad6c\ud569\ub2c8\ub2e4.<\/p>\n\n<pre><code>\ucd1d\ub9e4\ucd9c = SUMX( Sales, Sales[\uc218\ub7c9] * Sales[\ub2e8\uac00] )\n\n\ucd5c\ub300\uc0c1\ud488\ub9e4\ucd9c =\nMAXX(\n    VALUES( Sales[\uc0c1\ud488] ),\n    [\ucd1d\ub9e4\ucd9c]\n)\n\n\ucd5c\ub300\uc0c1\ud488\ube44\uc911 =\nDIVIDE( [\ucd5c\ub300\uc0c1\ud488\ub9e4\ucd9c], [\ucd1d\ub9e4\ucd9c] )<\/code><\/pre>\n\n<p>\uc0c1\ud488\ubcc4 \ucd1d\ub9e4\ucd9c\uc740 \ub178\ud2b8\ubd81 320, \ub9c8\uc6b0\uc2a4 32, \ubaa8\ub2c8\ud130 40\uc774\ub77c\uc11c \ucd5c\ub300 \uc0c1\ud488 \ub9e4\ucd9c\uc740 <strong>320<\/strong>\uc774\uace0, \uc804\uccb4 \ucd1d\ub9e4\ucd9c 392 \uc911 \ube44\uc911\uc740 320 \u00f7 392 = \uc57d <strong>81.6%<\/strong>\uc785\ub2c8\ub2e4. \ud55c\ub450 \uc0c1\ud488\uc5d0 \ub9e4\ucd9c\uc774 \uc3e0\ub824 \uc788\ub294\uc9c0 \ud655\uc778\ud558\ub294 \uc9c0\ud45c\ub85c \uc4f8 \uc218 \uc788\uc2b5\ub2c8\ub2e4. \ubc18\ubcf5 \uc548\uc5d0\uc11c \uce21\uc815\uac12\uc744 \ubd80\ub974\uba74 &#8220;\uc9c0\uae08 \ub3c4\ub294 \uc0c1\ud488&#8221;\uc774 \ud544\ud130\ub85c \ubc14\ub00c\ub294 \ucee8\ud14d\uc2a4\ud2b8 \uc804\ud658\uc774 \uc77c\uc5b4\ub0a9\ub2c8\ub2e4(<a href=\"https:\/\/vera-b.com\/?p=19\">CALCULATE \ud568\uc218 \uae00<\/a> \ucc38\uace0).<\/p>\n\n<h2>\ube48 \uac12: \uc124\uba85\uc774 \uc11c\ub85c \ub2e4\ub978 \ubd80\ubd84<\/h2>\n\n<p>MIN\uacfc \ub9c8\ucc2c\uac00\uc9c0\ub85c \ube48 \uac12 \ucc98\ub9ac\ub294 MAX\uc5d0\uc11c \uac00\uc7a5 \uc870\uc2ec\ud574\uc57c \ud560 \ubd80\ubd84\uc785\ub2c8\ub2e4. \ubb38\uc11c\ub97c \ube44\uad50\ud574 \ubcf4\ub2c8 \uc11c\ub85c \ub2e4\ub974\uac8c \uc801\ud600 \uc788\ub294 \ub300\ubaa9\uc774 \uc788\uc5b4\uc11c, \ud655\uc778\ub41c \ub0b4\uc6a9\uacfc \uac08\ub9ac\ub294 \ub0b4\uc6a9\uc744 \ub098\ub220 \uc815\ub9ac\ud569\ub2c8\ub2e4.<\/p>\n\n<ul>\n<li><strong>\uc5f4 \ud615\ud0dc<\/strong>: \ube48 \uac12\uc740 \uac74\ub108\ub6f0\uace0, \uac12\uc774 \uc788\ub294 \ud589\uc774 \ud558\ub098\ub3c4 \uc5c6\uc73c\uba74 \ube48 \uac12\uc744 \ub3cc\ub824\uc900\ub2e4\uace0 DAX Guide\uac00 \uc124\uba85\ud569\ub2c8\ub2e4. \ub17c\ub9ac\uac12(TRUE\/FALSE)\uc740 \uc9c0\uc6d0\ud558\uc9c0 \uc54a\uace0, \ud544\uc694\ud558\uba74 MAXA\ub97c \uc4f4\ub2e4\uace0 Microsoft \ubb38\uc11c\uac00 \uc548\ub0b4\ud569\ub2c8\ub2e4.<\/li>\n<li><strong>\ub450 \uac12 \ud615\ud0dc<\/strong>: \uc5ec\uae30\uc11c \uc124\uba85\uc774 \uac08\ub9bd\ub2c8\ub2e4. DAX Guide\ub294 \ub450 \uac12 \ud615\ud0dc\uc5d0\uc11c MAX\uac00 \ube48 \uac12\uc744 &#8220;\uc758\ubbf8 \uc788\ub294 \uac12&#8221;\uc73c\ub85c \ucde8\uae09\ud558\uba70, <code>MAX( -2, BLANK() )<\/code>\uc758 \uacb0\uacfc\uac00 \ube48 \uac12\uc774\ub77c\uace0 \uc124\uba85\ud558\uace0, MAXX\ub85c \uac19\uc740 \ube44\uad50\ub97c \ud558\uba74 \ube48 \uac12\uc774 \ubb34\uc2dc\ub418\uc5b4 -2\uac00 \ub098\uc628\ub2e4\uace0 \ub300\ube44\ud569\ub2c8\ub2e4. \ubc18\uba74 Microsoft \ubb38\uc11c\ub294 \ube44\uad50\ud560 \ub54c \ube48 \uac12\uc774 0\uc73c\ub85c \ucde8\uae09\ub41c\ub2e4\uace0 \uc801\uace0, \uc608\ub85c <code>MAX( 1, BLANK() )<\/code>\uc774 1, <code>MAX( -1, BLANK() )<\/code>\uc774 0\uc744 \ub3cc\ub824\uc900\ub2e4\uace0 \uc124\uba85\ud569\ub2c8\ub2e4. \ub458 \ub2e4 &#8220;\ube48 \uac12\uc774 \uc5f4 \ud615\ud0dc\ucc98\ub7fc \uadf8\ub0e5 \ubb34\uc2dc\ub418\uc9c0\ub294 \uc54a\ub294\ub2e4&#8221;\ub294 \uc810\uc740 \uac19\uc9c0\ub9cc, \uc74c\uc218\uc640 \ube44\uad50\ud560 \ub54c \uacb0\uacfc\uac00 \ub2e4\ub974\uac8c \uc801\ud600 \uc788\uc2b5\ub2c8\ub2e4.<\/li>\n<\/ul>\n\n<p>\uc5b4\ub290 \ucabd \uc124\uba85\uc774 \uc9c0\uae08 \uc4f0\ub294 \ubc84\uc804\uc5d0 \ub9de\ub294\uc9c0\ub294 \uc774 \uae00\uc5d0\uc11c \ub2e8\uc815\ud560 \uc218 \uc5c6\uc2b5\ub2c8\ub2e4. \uc81c\uac00 Power BI\uc5d0\uc11c \uc9c1\uc811 \ub3cc\ub824 \ud655\uc778\ud55c \uac83\uc774 \uc544\ub2c8\uae30 \ub54c\ubb38\uc785\ub2c8\ub2e4. \uadf8\ub798\uc11c \ube48 \uac12 \uac00\ub2a5\uc131\uc774 \uc788\ub294 \ub450 \uac12\uc744 MAX\uc5d0 \ub123\uae30 \uc804\uc5d0 \ubbf8\ub9ac \ucc98\ub9ac\ud558\ub294 \uac83\uc774 \uc548\uc804\ud569\ub2c8\ub2e4.<\/p>\n\n<pre><code>\uc9c0\uae09\uc218\ub2f9_\uc548\uc804 =\nVAR \uc2e4\uc801\uac12 = [\uc2e4\uc801\uc218\ub2f9]\nVAR \ubcf4\uc7a5\uac12 = [\ucd5c\uc18c\ubcf4\uc7a5\uc561]\nRETURN\n    IF(\n        ISBLANK( \uc2e4\uc801\uac12 ),\n        \ubcf4\uc7a5\uac12,\n        MAX( \uc2e4\uc801\uac12, \ubcf4\uc7a5\uac12 )\n    )<\/code><\/pre>\n\n<p>\uc774\ub807\uac8c &#8220;\uc2e4\uc801\uc218\ub2f9\uc774 \ube44\uc5b4 \uc788\uc73c\uba74 \ubcf4\uc7a5\uc561\uc744 \uc9c0\uae09\ud55c\ub2e4&#8221;\ucc98\ub7fc \ube48 \uac12\uc77c \ub54c\uc758 \uacb0\uacfc\ub97c \uc2dd\uc5d0\uc11c \uc9c1\uc811 \uc815\ud574 \ub450\uba74 \uc5b4\ub290 \ucabd \uc124\uba85\uc774 \ub9de\ub354\ub77c\ub3c4 \uacb0\uacfc\uac00 \ud754\ub4e4\ub9ac\uc9c0 \uc54a\uc2b5\ub2c8\ub2e4. \uc774 \uaddc\uce59\uc774 \uc5c5\ubb34\uc5d0 \ub9de\ub294\uc9c0\ub294 \ubcc4\ub3c4\ub85c \uc815\ud574\uc57c \ud569\ub2c8\ub2e4. \ube48 \uac12\uc744 0\uc73c\ub85c \ubc14\uafb8\ub294 \ubc29\ubc95\ub3c4 \uc788\uc9c0\ub9cc, SQLBI\uc758 \uae00(\ube48 \uac12 \ub300\uc2e0 0\uc744 \ubc18\ud658\ud558\ub294 \ubc29\ubc95)\uc774 \uc9c0\uc801\ud558\ub4ef \ub370\uc774\ud130\uac00 \uc5c6\ub294 \uad6c\uac04\uae4c\uc9c0 0\uc774 \ud45c\uc2dc\ub418\ub294 \ubd80\uc791\uc6a9\uc774 \uc788\uc2b5\ub2c8\ub2e4.<\/p>\n\n<h2>\ud14d\uc2a4\ud2b8 \uc5f4\uc5d0\ub3c4 \uc4f8 \uc218 \uc788\uc744\uae4c<\/h2>\n\n<p>MIN \uae00\uc5d0\uc11c \uc18c\uac1c\ud55c \uac83\ucc98\ub7fc, SQLBI\uc758 2015\ub144 \uae00\uc740 MIN\uacfc MAX\ub97c \ud14d\uc2a4\ud2b8 \uc5f4\uc5d0\ub294 \uc4f8 \uc218 \uc5c6\ub2e4\uace0 \ud558\uba74\uc11c FIRSTNONBLANK, LASTNONBLANK\ub97c \ub300\uc548\uc73c\ub85c \uc81c\uc2dc\ud588\uc2b5\ub2c8\ub2e4. \ud604\uc7ac DAX Guide\ub294 \ubb38\uc790\uc5f4\uc744 \uc54c\ud30c\ubcb3 \uc21c\uc11c\ub85c \ube44\uad50\ud55c\ub2e4\uace0 \uc124\uba85\ud558\ub2c8, \ubc84\uc804\uc5d0 \ub530\ub77c \ub3d9\uc791\uc774 \ub2ec\ub77c\uc84c\uc744 \uc218 \uc788\uc2b5\ub2c8\ub2e4. \ud14d\uc2a4\ud2b8 \uc5f4\uc5d0 \uc4f8 \uacc4\ud68d\uc774\ub77c\uba74 \uc0ac\uc6a9\ud558\ub294 \ud658\uacbd\uc5d0\uc11c \uc9c1\uc811 \ud655\uc778\ud574 \ubcf4\uc138\uc694.<\/p>\n\n<h2>\uc4f0\uc9c0 \ub9d0\uc544\uc57c \ud560 \ub54c<\/h2>\n\n<ul>\n<li><strong>TRUE\/FALSE \uc5f4<\/strong>: MAX\ub294 \uc9c0\uc6d0\ud558\uc9c0 \uc54a\uc2b5\ub2c8\ub2e4. MAXA\ub97c \uc4f0\uc138\uc694.<\/li>\n<li><strong>\uacc4\uc0b0\ud55c \uac12\uc774\ub098 \ubcc0\uc218\uc758 \ucd5c\ub313\uac12<\/strong>: \uc5f4\uc774 \uc544\ub2c8\ub77c \uc2dd\uc774\ubbc0\ub85c MAXX\ub97c \uc368\uc57c \ud569\ub2c8\ub2e4.<\/li>\n<li><strong>\ube48 \uac12\uc774 \uc11e\uc77c \uc218 \uc788\ub294 \ub450 \uac12 \ube44\uad50<\/strong>: \uc704\ucc98\ub7fc \ubbf8\ub9ac \ucc98\ub9ac\ud558\uc138\uc694.<\/li>\n<li><strong>&#8220;\uac00\uc7a5 \ud070 \uac12&#8221;\uc774 \uc544\ub2c8\ub77c &#8220;\uadf8 \uac12\uc744 \uac00\uc9c4 \ud589\uc758 \ub2e4\ub978 \uc5f4&#8221;\uc774 \ud544\uc694\ud560 \ub54c<\/strong>: \uc608\ub97c \ub4e4\uc5b4 \ucd5c\uace0 \ub2e8\uac00 \uc0c1\ud488\uc758 \uc774\ub984\uc740 MAX \ud558\ub098\ub85c \uad6c\ud560 \uc218 \uc5c6\uc2b5\ub2c8\ub2e4. \ub2e4\ub978 \ud568\uc218\uc640 \ud568\uaed8 \uc368\uc57c \ud569\ub2c8\ub2e4.<\/li>\n<\/ul>\n\n<h2>\uc54c\uc544\ub458 \uc810<\/h2>\n\n<ul>\n<li>DAX Guide\ub294 MAX\uac00 DirectQuery\uc758 \uce21\uc815\uac12\uacfc \uacc4\uc0b0 \uc5f4\uc5d0\uc11c \uc9c0\uc6d0\ub41c\ub2e4\uace0 \uc548\ub0b4\ud569\ub2c8\ub2e4.<\/li>\n<li>\ud55c \uc5f4\uc758 \ub370\uc774\ud130 \ud615\uc2dd\uc740 \ud558\ub098\uc785\ub2c8\ub2e4. \uc22b\uc790 \uc5f4\uc774\uba74 \uc22b\uc790\ub07c\ub9ac, \ub0a0\uc9dc \uc5f4\uc774\uba74 \ub0a0\uc9dc\ub07c\ub9ac \ube44\uad50\ud569\ub2c8\ub2e4.<\/li>\n<li>\uc9c0\uc5ed \uc124\uc815\uc5d0 \ub530\ub77c \uc778\uc218 \uad6c\ubd84\uc790\uac00 \uc27c\ud45c \ub300\uc2e0 \uc138\ubbf8\ucf5c\ub860\uc77c \uc218 \uc788\uc2b5\ub2c8\ub2e4. \uc2dd\uc744 \ubd99\uc5ec \ub123\uc5c8\ub294\ub370 \uc624\ub958\uac00 \ub09c\ub2e4\uba74 \uba3c\uc800 \ud655\uc778\ud574 \ubcf4\uc138\uc694.<\/li>\n<\/ul>\n\n<h2>\uc790\uc8fc \ud558\ub294 \uc2e4\uc218<\/h2>\n\n<ol>\n<li><strong>\ud569\uacc4 \uc904\uc774 \uc904\ubcc4 \uac12\uc758 \ucd5c\ub313\uac12\uacfc \uac19\uc740 \uc774\uc720\ub97c \ubaa8\ub984<\/strong>: \ud544\ud130 \uc5c6\uc774 \uc0c8\ub85c \uacc4\uc0b0\ud55c \uac12\uc774\uace0, \uacb0\uacfc\uac00 \uc6b0\uc5f0\ud788 \uc77c\uce58\ud560 \uc218 \uc788\uc2b5\ub2c8\ub2e4.<\/li>\n<li><strong>\ub450 \uac12 \ud615\ud0dc\uc5d0\uc11c \ube48 \uac12 \ub54c\ubb38\uc5d0 \uc758\ub3c4\uc640 \ub2e4\ub978 \uacb0\uacfc<\/strong>: \ubb38\uc11c\ub9c8\ub2e4 \ub2e4\ub974\uac8c \uc124\uba85\ud558\ub294 \ubd80\ubd84\uc774\ub77c \ubbf8\ub9ac \ucc98\ub9ac\ud558\ub294 \uac83\uc774 \uc548\uc804\ud569\ub2c8\ub2e4.<\/li>\n<li><strong>\uacc4\uc0b0\uc2dd\uc744 MAX\uc5d0 \ubc14\ub85c \ub123\uc74c<\/strong>: MAX( Sales[\uc218\ub7c9] * Sales[\ub2e8\uac00] )\ucc98\ub7fc \uc4f0\uba74 \uc548 \ub418\uace0, MAXX\uac00 \ud544\uc694\ud569\ub2c8\ub2e4.<\/li>\n<li><strong>\ub17c\ub9ac\uac12 \uc5f4\uc5d0 MAX<\/strong>: \uc9c0\uc6d0\ud558\uc9c0 \uc54a\uc2b5\ub2c8\ub2e4.<\/li>\n<\/ol>\n\n<h2>\ube44\uc2b7\ud55c \ud568\uc218<\/h2>\n\n<ul>\n<li><strong>MIN<\/strong>: \uac00\uc7a5 \uc791\uc740 \uac12. \uc0ac\uc6a9\ubc95\uc774 \uac19\uc2b5\ub2c8\ub2e4.<\/li>\n<li><strong>MAXX, MINX<\/strong>: \ud589\ub9c8\ub2e4 \uacc4\uc0b0\ud55c \uac12\uc758 \ucd5c\ub313\uac12, \ucd5c\uc19f\uac12<\/li>\n<li><strong>MAXA<\/strong>: \ub17c\ub9ac\uac12\uae4c\uc9c0 \ucc98\ub9ac\ud558\ub294 \ud615\ud0dc<\/li>\n<li><strong>FIRSTDATE, LASTDATE<\/strong>: \ub0a0\uc9dc \uc5f4\uc5d0\uc11c \uccab \ub0a0\uc9dc\uc640 \ub9c8\uc9c0\ub9c9 \ub0a0\uc9dc. \uc2dc\uac04 \ube44\uad50 \uacc4\uc0b0\uc5d0\uc11c \uc790\uc8fc \uc4f0\uc785\ub2c8\ub2e4.<\/li>\n<\/ul>\n\n<h2>\uc815\ub9ac<\/h2>\n\n<p>MAX\ub294 \uc5f4\uc758 \ucd5c\ub313\uac12(\ub610\ub294 \uac00\uc7a5 \ucd5c\uadfc \ub0a0\uc9dc)\uacfc \ub450 \uac12 \uc911 \ud070 \uac12, \ub450 \uac00\uc9c0 \uc6a9\ub3c4\ub85c \ub098\ub220 \uae30\uc5b5\ud558\uba74 \ub429\ub2c8\ub2e4. \uacc4\uc0b0\ud55c \uac12\uc758 \ucd5c\ub313\uac12\uc740 MAXX, \ub17c\ub9ac\uac12\uc740 MAXA, \uadf8\ub9ac\uace0 \ube48 \uac12\uc774 \uc11e\uc77c \uc218 \uc788\ub294 \ub450 \uac12 \ube44\uad50\ub294 \ubbf8\ub9ac \ucc98\ub9ac\ud574 \ub450\ub294 \uac83\uc774 \uc548\uc804\ud569\ub2c8\ub2e4. \uc608\uc81c\ub294 \uac00\uc0c1 \ub370\uc774\ud130\uc774\ub2c8 \ubcf8\uc778 \ubaa8\ub378\uc758 \uc5f4 \uc774\ub984\uc73c\ub85c \ubc14\uafd4 \uc9c1\uc811 \ud655\uc778\ud574 \ubcf4\uc2dc\uace0, \ud2b9\ud788 \ube48 \uac12\uc774 \uc788\ub294 \ub370\uc774\ud130\uc5d0\uc11c\ub294 \uacb0\uacfc\ub97c \uaf2d \ub208\uc73c\ub85c \ud655\uc778\ud574 \ubcf4\uc138\uc694. \ub3d9\uc791\uc740 \ubc84\uc804\uc5d0 \ub530\ub77c \ub2e4\ub97c \uc218 \uc788\uc5b4 \uacf5\uc2dd \ubb38\uc11c\ub3c4 \ud568\uaed8 \ubcf4\uc2dc\uae38 \uad8c\ud569\ub2c8\ub2e4.<\/p>\n\n<h2>\ucc38\uace0\ud55c \uc790\ub8cc<\/h2>\n<ul>\n<li>Microsoft Learn, MAX function (DAX): https:\/\/learn.microsoft.com\/en-us\/dax\/max-function-dax<\/li>\n<li>Microsoft Learn, MAXX function (DAX): https:\/\/learn.microsoft.com\/en-us\/dax\/maxx-function-dax<\/li>\n<li>DAX Guide, MAX: https:\/\/dax.guide\/max\/<\/li>\n<li>DAX Guide, MAXX: https:\/\/dax.guide\/maxx\/<\/li>\n<li>SQLBI, How to return 0 instead of BLANK in DAX: https:\/\/www.sqlbi.com\/articles\/how-to-return-0-instead-of-blank-in-dax\/<\/li>\n<li>SQLBI, Use FIRSTNONBLANK and LASTNONBLANK instead of MIN and MAX (2015): https:\/\/www.sqlbi.com\/blog\/marco\/2015\/02\/24\/use-firstnonblank-and-lastnonblank-instead-of-min-and-max-dax\/<\/li>\n<\/ul>\n","protected":false},"excerpt":{"rendered":"<p>DAX MAX \ud568\uc218\uc758 \ub450 \uac00\uc9c0 \ud615\ud0dc, \uac00\uc7a5 \ucd5c\uadfc \ub0a0\uc9dc\uc640 \ud558\ud55c \ub450\uae30, MAXX, \uadf8\ub9ac\uace0 \ubb38\uc11c\ub9c8\ub2e4 \uc124\uba85\uc774 \ub2e4\ub978 \ube48 \uac12 \ucc98\ub9ac\ub97c \uac00\uc0c1 \ub370\uc774\ud130 \uc608\uc81c\ub85c \uc815\ub9ac\ud588\uc2b5\ub2c8\ub2e4.<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_jetpack_newsletter_access":"","_jetpack_dont_email_post_to_subs":false,"_jetpack_newsletter_tier_id":0,"_jetpack_memberships_contains_paywalled_content":false,"_jetpack_memberships_contains_paid_content":false,"footnotes":""},"categories":[3],"tags":[4,16,17,6],"class_list":["post-35","post","type-post","status-publish","format-standard","hentry","category-power-bi","tag-dax","tag-max","tag-maxx","tag-power-bi"],"jetpack_sharing_enabled":true,"jetpack_featured_media_url":"","_links":{"self":[{"href":"https:\/\/vera-b.com\/index.php?rest_route=\/wp\/v2\/posts\/35","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/vera-b.com\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/vera-b.com\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/vera-b.com\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/vera-b.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=35"}],"version-history":[{"count":1,"href":"https:\/\/vera-b.com\/index.php?rest_route=\/wp\/v2\/posts\/35\/revisions"}],"predecessor-version":[{"id":43,"href":"https:\/\/vera-b.com\/index.php?rest_route=\/wp\/v2\/posts\/35\/revisions\/43"}],"wp:attachment":[{"href":"https:\/\/vera-b.com\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=35"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/vera-b.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=35"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/vera-b.com\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=35"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}