{"id":33,"date":"2026-10-07T07:51:32","date_gmt":"2026-10-06T22:51:32","guid":{"rendered":"https:\/\/vera-b.com\/?p=33"},"modified":"2026-10-07T07:51:32","modified_gmt":"2026-10-06T22:51:32","slug":"dax-min-%ed%95%a8%ec%88%98-%ec%a0%95%eb%a6%ac-%ec%97%b4%ec%9d%98-%ec%b5%9c%ec%86%9f%ea%b0%92%ea%b3%bc-%eb%91%90-%ea%b0%92-%eb%b9%84%ea%b5%90-%eb%b9%88-%ea%b0%92-%ec%b2%98%eb%a6%ac%ec%9d%98-%ed%95%a8","status":"publish","type":"post","link":"https:\/\/vera-b.com\/?p=33","title":{"rendered":"DAX MIN \ud568\uc218 \uc815\ub9ac: \uc5f4\uc758 \ucd5c\uc19f\uac12\uacfc \ub450 \uac12 \ube44\uad50, \ube48 \uac12 \ucc98\ub9ac\uc758 \ud568\uc815"},"content":{"rendered":"\n

\uac00\uc7a5 \uc774\ub978 \uc8fc\ubb38\uc77c, \uac00\uc7a5 \ub0ae\uc740 \ub2e8\uac00, \ub450 \uac12 \uc911 \uc791\uc740 \ucabd. \uc774\ub7f0 “\uac00\uc7a5 \uc791\uc740 \uac12”\uc774 \ud544\uc694\ud560 \ub54c \uc4f0\ub294 \ud568\uc218\uac00 MIN\uc785\ub2c8\ub2e4. \uc774\ub984\ub9cc \ubcf4\uba74 \ub354 \uc124\uba85\ud560 \uac83\uc774 \uc5c6\uc5b4 \ubcf4\uc774\ub294\ub370, \uc5f4 \ud558\ub098\ub97c \ubc1b\ub294 \ud615\ud0dc\uc640 \uac12 \ub450 \uac1c\ub97c \ubc1b\ub294 \ud615\ud0dc\uac00 \ub530\ub85c \uc788\uace0, \ube48 \uac12\uc744 \ub2e4\ub8e8\ub294 \ubc29\uc2dd\uc774 \ud615\ud0dc\ub9c8\ub2e4 \ub2e4\ub974\uac8c \uc124\uba85\ub418\uc5b4 \uc788\uc5b4\uc11c \ucc98\uc74c \uc4f8 \ub54c \ud5f7\uac08\ub9ac\uae30 \uc27d\uc2b5\ub2c8\ub2e4. \uc774 \uae00\uc5d0\uc11c\ub294 \ub450 \ud615\ud0dc\uc758 \ucc28\uc774, \uc2e4\ubb34\uc5d0\uc11c \uc790\uc8fc \uc4f0\ub294 \uc0c1\ud669 \uc138 \uac00\uc9c0, \uadf8\ub9ac\uace0 \ube48 \uac12\uc5d0\uc11c \uc870\uc2ec\ud560 \uc810\uae4c\uc9c0 \uc815\ub9ac\ud569\ub2c8\ub2e4.<\/p>\n\n

\ubb38\ubc95: \ub450 \uac00\uc9c0 \ud615\ud0dc<\/h2>\n\n
MIN( <\uc5f4> )\nMIN( <\uc2dd1>, <\uc2dd2> )<\/code><\/pre>\n\n
Microsoft \ubb38\uc11c\uc758 \uc124\uba85\ub300\ub85c MIN\uc740 “\uc5f4\uc5d0\uc11c \uac00\uc7a5 \uc791\uc740 \uac12, \ub610\ub294 \ub450 \uc2dd \uc0ac\uc774\uc5d0\uc11c \ub354 \uc791\uc740 \uac12”\uc744 \ub3cc\ub824\uc90d\ub2c8\ub2e4. \uc5f4 \ud615\ud0dc\ub294 \uc22b\uc790\ubfd0 \uc544\ub2c8\ub77c \ub0a0\uc9dc\uc5d0\ub3c4 \uc4f8 \uc218 \uc788\uace0, \ub0a0\uc9dc\uc5d0 \uc4f0\uba74 \uac00\uc7a5 \uc774\ub978 \ub0a0\uc9dc\uac00 \ubc18\ud658\ub429\ub2c8\ub2e4. DAX Guide\ub294 \ubb38\uc790\uc5f4 \uc5f4\ub3c4 \uc54c\ud30c\ubcb3(\uc0ac\uc804) \uc21c\uc11c\ub85c \ube44\uad50\ud55c\ub2e4\uace0 \uc124\uba85\ud569\ub2c8\ub2e4. \ubc18\ud658\uac12\uc740 \uc785\ub825\uacfc \uac19\uc740 \ub370\uc774\ud130 \ud615\uc2dd\uc785\ub2c8\ub2e4.<\/p>\n\n
Power BI Desktop\uc5d0\uc11c \uce21\uc815\uac12\uc73c\ub85c \ub9cc\ub4e4\uae30<\/h2>\n\n
\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
    \n
  1. \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
  2. \uc0c1\ub2e8 \ub9ac\ubcf8\uc5d0\uc11c “\uc0c8 \uce21\uc815\uac12”(\uc601\ubb38\ud310\uc740 New measure)\uc744 \ub204\ub985\ub2c8\ub2e4.<\/li>\n
  3. \uc218\uc2dd \uc785\ub825\uc904\uc5d0 \ucd5c\uc800\ub2e8\uac00 = MIN( Sales[\ub2e8\uac00] )<\/code>\ucc98\ub7fc \uc774\ub984\uacfc \uc2dd\uc744 \uc801\uace0 Enter\ub97c \ub204\ub985\ub2c8\ub2e4.<\/li>\n
  4. \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
    \uc608\uc81c \ub370\uc774\ud130<\/h2>\n\n
    \uc55e\uc120 SUM<\/a>, SUMX<\/a>, AVERAGE<\/a> \uae00\uacfc \uc774\uc5b4\uc9c0\ub294 \uac00\uc0c1 \ub370\uc774\ud130\uc785\ub2c8\ub2e4. \uc774\ubc88\uc5d0\ub294 \uc8fc\ubb38\uc77c \uc5f4\uc744 \ucd94\uac00\ud588\uc2b5\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\n\n
    \uc8fc\ubb38<\/th>\uc8fc\ubb38\uc77c<\/th>\uc0c1\ud488<\/th>\uc218\ub7c9<\/th>\ub2e8\uac00<\/th><\/tr><\/thead>\n
    1<\/td>3\/2<\/td>\ub178\ud2b8\ubd81<\/td>1<\/td>120<\/td><\/tr>\n
    2<\/td>3\/3<\/td>\ub9c8\uc6b0\uc2a4<\/td>3<\/td>4<\/td><\/tr>\n
    3<\/td>3\/5<\/td>\ubaa8\ub2c8\ud130<\/td>2<\/td>20<\/td><\/tr>\n
    4<\/td>3\/7<\/td>\ub9c8\uc6b0\uc2a4<\/td>5<\/td>4<\/td><\/tr>\n
    5<\/td>3\/9<\/td>\ub178\ud2b8\ubd81<\/td>2<\/td>100<\/td><\/tr>\n<\/tbody>\n<\/table>\n\n
    \uc2e4\ubb34 \uc2dc\ub098\ub9ac\uc624 1: \uac00\uc7a5 \uc774\ub978 \ub0a0\uc9dc\uc640 \uac00\uc7a5 \ub0ae\uc740 \uac12<\/h2>\n\n
    \uccab\uc8fc\ubb38\uc77c = MIN( Sales[\uc8fc\ubb38\uc77c] )\n\ucd5c\uc800\ub2e8\uac00 = MIN( Sales[\ub2e8\uac00] )<\/code><\/pre>\n\n
    \uccab \uc8fc\ubb38\uc77c\uc740 3\/2<\/strong>(1\ubc88 \uc8fc\ubb38)\uc774\uace0, \ucd5c\uc800 \ub2e8\uac00\ub294 \ub9c8\uc6b0\uc2a4\uc758 4<\/strong>\uc785\ub2c8\ub2e4. \uc774 \uce21\uc815\uac12\uc744 \uc0c1\ud488\ubcc4 \ud45c\uc5d0 \uc62c\ub9ac\uba74 \uc0c1\ud488\ub9c8\ub2e4 \ub530\ub85c \uacc4\uc0b0\ub429\ub2c8\ub2e4.<\/p>\n\n\n\n
    \uc0c1\ud488<\/th>\uccab\uc8fc\ubb38\uc77c<\/th>\ucd5c\uc800\ub2e8\uac00<\/th><\/tr><\/thead>\n
    \ub178\ud2b8\ubd81<\/td>3\/2<\/td>100<\/td><\/tr>\n
    \ub9c8\uc6b0\uc2a4<\/td>3\/3<\/td>4<\/td><\/tr>\n
    \ubaa8\ub2c8\ud130<\/td>3\/5<\/td>20<\/td><\/tr>\n
    \ud569\uacc4<\/td>3\/2<\/td>4<\/td><\/tr>\n<\/tbody>\n<\/table>\n\n
    \ub178\ud2b8\ubd81\uc740 \ub2e8\uac00 120\uacfc 100 \uc911 \uc791\uc740 100\uc774\uace0, \ud569\uacc4 \uc904\uc740 \ud544\ud130\uac00 \uc5c6\ub294 \uc804\uccb4\uc5d0\uc11c \uad6c\ud558\ubbc0\ub85c 3\/2\uc640 4\uac00 \ub098\uc635\ub2c8\ub2e4. \uc55e\uc120 AVERAGE \uae00\uc5d0\uc11c \ubcf8 \uac83\ucc98\ub7fc, \ud569\uacc4 \uc904\uc740 \uc704 \uc904\ub4e4\uc758 \uac12\uc744 \ub2e4\uc2dc \uacc4\uc0b0\ud558\ub294 \uac83\uc774 \uc544\ub2c8\ub77c \ud544\ud130 \uc5c6\uc774 \uc0c8\ub85c \uacc4\uc0b0\ud55c \uac12\uc785\ub2c8\ub2e4. \ucd5c\uc19f\uac12\uc740 \uc904\ub4e4\uc758 \ucd5c\uc19f\uac12\uacfc \uc6b0\uc5f0\ud788 \uac19\uc544 \ubcf4\uc774\uc9c0\ub9cc \uc6d0\ub9ac\ub294 \uac19\uc2b5\ub2c8\ub2e4.<\/p>\n\n
    \uc2e4\ubb34 \uc2dc\ub098\ub9ac\uc624 2: \ub450 \uac12 \uc911 \uc791\uc740 \uac12\uc73c\ub85c \uc0c1\ud55c \ub450\uae30<\/h2>\n\n
    MIN\uc758 \ub450 \ubc88\uc9f8 \ud615\ud0dc\ub294 “\ub354 \uc791\uc740 \ucabd\uc744 \uace0\ub978\ub2e4”\ub294 \ub73b\uc774\ub77c\uc11c, \uac12\uc5d0 \uc0c1\ud55c\uc744 \uc50c\uc6b8 \ub54c \uc790\uc8fc \uc501\ub2c8\ub2e4. \uc608\ub97c \ub4e4\uc5b4 \uc601\uc5c5\ud300 \uc2e4\uc801\uc744 \uc778\uc815\ud560 \ub54c \ubaa9\ud45c\ub97c \ub118\uc740 \ubd80\ubd84\uc740 \uc778\uc815\ud558\uc9c0 \uc54a\ub294 \uaddc\uce59\uc774\ub77c\uace0 \ud574 \ubcf4\uaca0\uc2b5\ub2c8\ub2e4.<\/p>\n\n
    \uc778\uc815\uc2e4\uc801 =\nMIN( [\uc2e4\uc801], [\ubaa9\ud45c] )<\/code><\/pre>\n\n\n\n
    \ud300<\/th>\uc2e4\uc801<\/th>\ubaa9\ud45c<\/th>\uc778\uc815\uc2e4\uc801<\/th><\/tr><\/thead>\n
    A<\/td>130<\/td>100<\/td>100<\/td><\/tr>\n
    B<\/td>80<\/td>100<\/td>80<\/td><\/tr>\n<\/tbody>\n<\/table>\n\n
    A\ud300\uc740 \uc2e4\uc801\uc774 \ubaa9\ud45c\ub97c \ub118\uc5c8\uc73c\ub2c8 \ubaa9\ud45c\uc778 100\uae4c\uc9c0\ub9cc, B\ud300\uc740 \uc2e4\uc801 80\uc774 \ub354 \uc791\uc73c\ub2c8 80\uc774 \uc778\uc815\ub429\ub2c8\ub2e4. \uc7ac\uace0\uc640 \uc8fc\ubb38 \uc218\ub7c9 \uc911 \uc791\uc740 \ucabd\uc73c\ub85c \ucd9c\uace0 \uac00\ub2a5 \uc218\ub7c9\uc744 \uc815\ud558\ub294 \uc2dd\ub3c4 \uac19\uc740 \ubaa8\uc591\uc785\ub2c8\ub2e4. \ub2e4\ub9cc \uc544\ub798 “\ube48 \uac12” \ud56d\ubaa9\uc5d0\uc11c \uc124\uba85\ud558\ub4ef, \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 \uc8fc\uc758\uac00 \ud544\uc694\ud569\ub2c8\ub2e4.<\/p>\n\n
    \uc2e4\ubb34 \uc2dc\ub098\ub9ac\uc624 3: \uacc4\uc0b0\ud55c \uac12\ub4e4\uc758 \ucd5c\uc19f\uac12 (MINX)<\/h2>\n\n
    MIN\uc740 \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\uc19f\uac12\uc740 MINX\ub97c \uc501\ub2c8\ub2e4.<\/p>\n\n
    \ucd5c\uc18c\uc8fc\ubb38\uae08\uc561 =\nMINX(\n    Sales,\n    Sales[\uc218\ub7c9] * Sales[\ub2e8\uac00]\n)<\/code><\/pre>\n\n
    \ud589\ub9c8\ub2e4 120, 12, 40, 20, 200\uc774 \uacc4\uc0b0\ub418\ubbc0\ub85c \ucd5c\uc19f\uac12\uc740 12<\/strong>\uc785\ub2c8\ub2e4. DAX Guide\ub294 \uc5f4 \ud558\ub098\uc5d0 \uc4f4 MIN\uc774 \ub0b4\ubd80\uc801\uc73c\ub85c MINX\ub97c \uc2e4\ud589\ud558\ub294 \uac83\uacfc \uac19\uace0 \uc131\ub2a5 \ucc28\uc774\uac00 \uc5c6\ub2e4\uace0 \uc124\uba85\ud569\ub2c8\ub2e4. MIN\uc774 \ubaa8\ub378\uc758 \uc5f4\uc5d0\ub9cc \uc4f8 \uc218 \uc788\ub2e4\ub294 \uc810\uc5d0\uc11c, \ubcc0\uc218\uc5d0 \ub2f4\uae34 \uac12\uc774\ub098 \uacc4\uc0b0\ud55c \uc5f4\uc744 \ub3cc\uc544\uc57c \ud560 \ub54c\ub294 MINX\uac00 \ud544\uc694\ud558\ub2e4\uace0 \ub367\ubd99\uc785\ub2c8\ub2e4.<\/p>\n\n
    MINX\ub294 \uce21\uc815\uac12\uc744 \uadf8\ub8f9\ubcc4\ub85c \uacc4\uc0b0\ud55c \ub4a4 \uadf8\uc911 \ucd5c\uc19f\uac12\uc744 \uad6c\ud560 \ub54c\ub3c4 \uc501\ub2c8\ub2e4. “\uc0c1\ud488\ubcc4 \ucd1d\ub9e4\ucd9c \uc911 \uac00\uc7a5 \uc801\uc740 \ub9e4\ucd9c”\uc740 \uc774\ub807\uac8c \uad6c\ud569\ub2c8\ub2e4.<\/p>\n\n
    \ucd1d\ub9e4\ucd9c = SUMX( Sales, Sales[\uc218\ub7c9] * Sales[\ub2e8\uac00] )\n\n\ucd5c\uc18c\uc0c1\ud488\ub9e4\ucd9c =\nMINX(\n    VALUES( Sales[\uc0c1\ud488] ),\n    [\ucd1d\ub9e4\ucd9c]\n)<\/code><\/pre>\n\n
    \uc0c1\ud488\ubcc4 \ucd1d\ub9e4\ucd9c\uc740 \ub178\ud2b8\ubd81 320, \ub9c8\uc6b0\uc2a4 32, \ubaa8\ub2c8\ud130 40\uc774\ub77c\uc11c \uacb0\uacfc\ub294 32<\/strong>\uc785\ub2c8\ub2e4. \ubc18\ubcf5 \uc548\uc5d0\uc11c \uce21\uc815\uac12\uc744 \ubd80\ub974\uba74 “\uc9c0\uae08 \ub3c4\ub294 \uc0c1\ud488”\uc774 \ud544\ud130\ub85c \ubc14\ub00c\ub294 \ucee8\ud14d\uc2a4\ud2b8 \uc804\ud658\uc774 \uc77c\uc5b4\ub0a9\ub2c8\ub2e4(CALCULATE \ud568\uc218 \uae00<\/a> \ucc38\uace0).<\/p>\n\n
    \ube48 \uac12: \uc124\uba85\uc774 \uc11c\ub85c \ub2e4\ub978 \ubd80\ubd84<\/h2>\n\n
    \ube48 \uac12 \ucc98\ub9ac\ub294 MIN\uc5d0\uc11c \uac00\uc7a5 \uc870\uc2ec\ud574\uc57c \ud560 \ubd80\ubd84\uc785\ub2c8\ub2e4. \uc774 \uae00\uc744 \uc4f0\uba74\uc11c \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
      \n
    • \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 MINA\ub97c \uc4f4\ub2e4\uace0 Microsoft \ubb38\uc11c\uac00 \uc548\ub0b4\ud569\ub2c8\ub2e4.<\/li>\n
    • \ub450 \uac12 \ud615\ud0dc<\/strong>: \uc5ec\uae30\uc11c \uc124\uba85\uc774 \uac08\ub9bd\ub2c8\ub2e4. DAX Guide\ub294 \ub450 \uac12 \ud615\ud0dc\uc5d0\uc11c MIN\uc774 \ube48 \uac12\uc744 “\uc758\ubbf8 \uc788\ub294 \uac12”\uc73c\ub85c \ucde8\uae09\ud574\uc11c \uac74\ub108\ub6f0\uc9c0 \uc54a\uc73c\uba70, \uadf8\ub798\uc11c MIN( 2, BLANK() )<\/code>\uc758 \uacb0\uacfc\uac00 \ube48 \uac12\uc774\ub77c\uace0 \uc124\uba85\ud558\uace0, MINX\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 MIN( 1, BLANK() )<\/code>\uc774 0\uc744 \ub3cc\ub824\uc900\ub2e4\uace0 \uc124\uba85\ud569\ub2c8\ub2e4. \ub458 \ub2e4 “\ube48 \uac12\uc774 \uc5f4 \ud615\ud0dc\ucc98\ub7fc \uadf8\ub0e5 \ubb34\uc2dc\ub418\uc9c0\ub294 \uc54a\ub294\ub2e4”\ub294 \uc810\uc740 \uac19\uc9c0\ub9cc \uacb0\uacfc \uac12\uc740 \ub2e4\ub985\ub2c8\ub2e4.<\/li>\n<\/ul>\n\n
      \ub450 \uc124\uba85 \uc911 \uc5b4\ub290 \ucabd\uc774 \uc9c0\uae08 \uc0ac\uc6a9\ud558\ub294 \ubc84\uc804\uc5d0 \ub9de\ub294\uc9c0\ub294 \uc774 \uae00\uc5d0\uc11c \ub2e8\uc815\ud560 \uc218 \uc5c6\uc2b5\ub2c8\ub2e4. \uc81c\uac00 \uc9c1\uc811 Power BI\uc5d0\uc11c \ub3cc\ub824 \ubcf8 \uac83\uc774 \uc544\ub2c8\uae30 \ub54c\ubb38\uc785\ub2c8\ub2e4. \uadf8\ub798\uc11c \uc2e4\ubb34\uc5d0\uc11c\ub294 \ube48 \uac12 \uac00\ub2a5\uc131\uc774 \uc788\ub294 \ub450 \uac12\uc744 MIN\uc5d0 \ub123\uae30 \uc804\uc5d0 \ubbf8\ub9ac \ucc98\ub9ac\ud558\ub294 \uac83\uc774 \uc548\uc804\ud569\ub2c8\ub2e4.<\/p>\n\n
      \uc778\uc815\uc2e4\uc801_\uc548\uc804 =\nVAR \uc2e4\uc801\uac12 = [\uc2e4\uc801]\nVAR \ubaa9\ud45c\uac12 = [\ubaa9\ud45c]\nRETURN\n    IF(\n        ISBLANK( \uc2e4\uc801\uac12 ) || ISBLANK( \ubaa9\ud45c\uac12 ),\n        BLANK(),\n        MIN( \uc2e4\uc801\uac12, \ubaa9\ud45c\uac12 )\n    )<\/code><\/pre>\n\n
      \uc774\ub807\uac8c \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. \ube48 \uac12\uc744 0\uc73c\ub85c \ubc14\uafb8\uba74 \ud3b8\ud574 \ubcf4\uc774\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. BLANK\uc5d0 0\uc744 \ub354\ud558\uba74 0\uc774 \ub41c\ub2e4\ub294 \uc810\uc740 \ud655\uc2e4\ud558\uc9c0\ub9cc, \uadf8 \uacb0\uacfc\ub97c \uc5b4\ub514\uae4c\uc9c0 \ubcf4\uc5ec\uc904\uc9c0\ub294 \ub530\ub85c \uc815\ud574\uc57c \ud569\ub2c8\ub2e4.<\/p>\n\n
      \ud14d\uc2a4\ud2b8 \uc5f4\uc5d0\ub3c4 \uc4f8 \uc218 \uc788\uc744\uae4c<\/h2>\n\n
      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. \uadf8\ub7f0\ub370 \ud604\uc7ac Microsoft \ubb38\uc11c\uc640 DAX Guide\ub294 \ud14d\uc2a4\ud2b8\ub3c4 \ucc98\ub9ac\ud558\uba70 \uc54c\ud30c\ubcb3 \uc21c\uc11c\ub85c \ube44\uad50\ud55c\ub2e4\uace0 \uc124\uba85\ud569\ub2c8\ub2e4. \uae00\uc774 \uc4f0\uc778 \uc2dc\uae30\uac00 10\ub144 \uac00\uae4c\uc774 \ucc28\uc774 \ub098\ub294 \ub9cc\ud07c \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\uc2dc\uae38 \uad8c\ud569\ub2c8\ub2e4.<\/p>\n\n
      \uc4f0\uc9c0 \ub9d0\uc544\uc57c \ud560 \ub54c<\/h2>\n\n
        \n
      • TRUE\/FALSE \uc5f4<\/strong>: MIN\uc740 \uc9c0\uc6d0\ud558\uc9c0 \uc54a\uc2b5\ub2c8\ub2e4. MINA\ub97c \uc4f0\uc138\uc694.<\/li>\n
      • \uacc4\uc0b0\ud55c \uac12\uc774\ub098 \ubcc0\uc218\uc758 \ucd5c\uc19f\uac12<\/strong>: \uc5f4\uc774 \uc544\ub2c8\ub77c \uc2dd\uc774\ubbc0\ub85c MINX\ub97c \uc368\uc57c \ud569\ub2c8\ub2e4.<\/li>\n
      • \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
      • “\uac00\uc7a5 \uc774\ub978 \ub0a0\uc9dc” \ub300\uc2e0 “\uccab \ubc88\uc9f8 \uac12”\uc774 \ud544\uc694\ud560 \ub54c<\/strong>: \ubaa9\uc801\uc774 \ub2e4\ub974\uba74 \ub2e4\ub978 \ud568\uc218\uac00 \ub9de\uc744 \uc218 \uc788\uc2b5\ub2c8\ub2e4.<\/li>\n<\/ul>\n\n
        \uc54c\uc544\ub458 \uc810<\/h2>\n\n
          \n
        • DAX Guide\ub294 MIN\uc774 DirectQuery\uc758 \uce21\uc815\uac12\uacfc \uacc4\uc0b0 \uc5f4\uc5d0\uc11c \uc9c0\uc6d0\ub41c\ub2e4\uace0 \uc548\ub0b4\ud569\ub2c8\ub2e4.<\/li>\n
        • \uc5f4 \ud615\ud0dc\uc5d0 \uc22b\uc790, \ub0a0\uc9dc, \ud14d\uc2a4\ud2b8\ub97c \uc4f8 \uc218 \uc788\uc9c0\ub9cc \ud55c \uc5f4\uc758 \ub370\uc774\ud130 \ud615\uc2dd\uc740 \ud558\ub098\uc785\ub2c8\ub2e4.<\/li>\n
        • \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
          \uc790\uc8fc \ud558\ub294 \uc2e4\uc218<\/h2>\n\n
            \n
          1. \ud569\uacc4 \uc904\uc774 \uc904\ubcc4 \uac12\uc758 \ucd5c\uc19f\uac12\uacfc \uac19\uc740 \uc774\uc720\ub97c \ubaa8\ub984<\/strong>: \ud544\ud130 \uc5c6\uc774 \uc0c8\ub85c \uacc4\uc0b0\ud55c \uac12\uc774\uace0, \uc6b0\uc5f0\ud788 \uc77c\uce58\ud560 \uc218 \uc788\uc2b5\ub2c8\ub2e4.<\/li>\n
          2. \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
          3. \uacc4\uc0b0\uc2dd\uc744 MIN\uc5d0 \ubc14\ub85c \ub123\uc74c<\/strong>: MIN( Sales[\uc218\ub7c9] * Sales[\ub2e8\uac00] )\ucc98\ub7fc \uc4f0\uba74 \uc548 \ub418\uace0, MINX\uac00 \ud544\uc694\ud569\ub2c8\ub2e4.<\/li>\n
          4. \ub17c\ub9ac\uac12 \uc5f4\uc5d0 MIN<\/strong>: \uc9c0\uc6d0\ud558\uc9c0 \uc54a\uc2b5\ub2c8\ub2e4.<\/li>\n<\/ol>\n\n
            \ube44\uc2b7\ud55c \ud568\uc218<\/h2>\n\n
              \n
            • MAX<\/strong>: \uac00\uc7a5 \ud070 \uac12. \uc0ac\uc6a9\ubc95\uc774 \uac19\uc2b5\ub2c8\ub2e4.<\/li>\n
            • MINX, MAXX<\/strong>: \ud589\ub9c8\ub2e4 \uacc4\uc0b0\ud55c \uac12\uc758 \ucd5c\uc19f\uac12, \ucd5c\ub313\uac12<\/li>\n
            • MINA<\/strong>: \ub17c\ub9ac\uac12\uae4c\uc9c0 \ucc98\ub9ac\ud558\ub294 \ud615\ud0dc<\/li>\n
            • 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
              \uc815\ub9ac<\/h2>\n\n
              MIN\uc740 \uc5f4\uc758 \ucd5c\uc19f\uac12(\ub610\ub294 \uac00\uc7a5 \uc774\ub978 \ub0a0\uc9dc)\uacfc \ub450 \uac12 \uc911 \uc791\uc740 \uac12, \ub450 \uac00\uc9c0 \uc6a9\ub3c4\ub85c \ub098\ub220 \uae30\uc5b5\ud558\uba74 \ub429\ub2c8\ub2e4. \uacc4\uc0b0\ud55c \uac12\uc758 \ucd5c\uc19f\uac12\uc740 MINX, \ub17c\ub9ac\uac12\uc740 MINA, \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
              \ucc38\uace0\ud55c \uc790\ub8cc<\/h2>\n
                \n
              • Microsoft Learn, MIN function (DAX): https:\/\/learn.microsoft.com\/en-us\/dax\/min-function-dax<\/li>\n
              • Microsoft Learn, MINX function (DAX): https:\/\/learn.microsoft.com\/en-us\/dax\/minx-function-dax<\/li>\n
              • DAX Guide, MIN: https:\/\/dax.guide\/min\/<\/li>\n
              • DAX Guide, MINX: https:\/\/dax.guide\/minx\/<\/li>\n
              • 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
              • 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":"
                DAX MIN \ud568\uc218\uc758 \ub450 \uac00\uc9c0 \ud615\ud0dc, \uac00\uc7a5 \uc774\ub978 \ub0a0\uc9dc\uc640 \uc0c1\ud55c \ub450\uae30, MINX, \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,14,15,6],"class_list":["post-33","post","type-post","status-publish","format-standard","hentry","category-power-bi","tag-dax","tag-min","tag-minx","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\/33","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=33"}],"version-history":[{"count":1,"href":"https:\/\/vera-b.com\/index.php?rest_route=\/wp\/v2\/posts\/33\/revisions"}],"predecessor-version":[{"id":41,"href":"https:\/\/vera-b.com\/index.php?rest_route=\/wp\/v2\/posts\/33\/revisions\/41"}],"wp:attachment":[{"href":"https:\/\/vera-b.com\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=33"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/vera-b.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=33"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/vera-b.com\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=33"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}