{"id":63302,"date":"2026-01-21T20:16:45","date_gmt":"2026-01-21T12:16:45","guid":{"rendered":"https:\/\/www.wsisp.com\/helps\/63302.html"},"modified":"2026-01-21T20:16:45","modified_gmt":"2026-01-21T12:16:45","slug":"power-bi-2022-%e6%96%b0%e5%a2%9e%e7%aa%97%e5%8f%a3%e5%87%bd%e6%95%b0%e8%a7%a3%e6%9e%90","status":"publish","type":"post","link":"https:\/\/www.wsisp.com\/helps\/63302.html","title":{"rendered":"Power BI 2022 + \u65b0\u589e\u7a97\u53e3\u51fd\u6570\u89e3\u6790"},"content":{"rendered":"

\u4e00\u30012022 + \u65b0\u589e\u7a97\u53e3\u51fd\u6570\u6838\u5fc3\u7279\u70b9\u4e0e\u4f18\u52bf（vs \u4f20\u7edf\u51fd\u6570）<\/h3>\n\n\u51fd\u6570\u6838\u5fc3\u7279\u70b9\u4f20\u7edf\u66ff\u4ee3\u51fd\u6570\u6838\u5fc3\u4f18\u52bf\u6027\u80fd \/ \u6613\u7528\u6027\u5bf9\u6bd4<\/tr>\n\n\n\n\n\n\n
OFFSET<\/td>\n\u52a8\u6001\u76f8\u5bf9\u504f\u79fb，\u57fa\u4e8e\u5f53\u524d\u884c\u53d6\u504f\u79fb N \u884c\u6570\u636e，\u652f\u6301\u5206\u533a \/ \u6392\u5e8f \/ \u7a7a\u503c\u63a7\u5236<\/td>\nDATEADD\/PREVIOUSMONTH（\u65f6\u95f4\u7c7b）\u3001FILTER+TOPN（\u901a\u7528）<\/td>\n1. \u8131\u79bb\u65f6\u95f4\u7ef4\u5ea6\u9650\u5236，\u9002\u914d\u4efb\u610f\u7ef4\u5ea6\u504f\u79fb；2. \u539f\u751f\u652f\u6301\u5206\u533a（PARTITIONBY），\u65e0\u9700\u5d4c\u5957ALLEXCEPT；3. \u8bed\u6cd5\u7b80\u6d01，\u51cf\u5c11\u5d4c\u5957\u5c42\u7ea7<\/td>\n\u6027\u80fd\u63d0\u5347 30%-50%（\u5927\u6570\u636e\u91cf）；\u8bed\u6cd5\u91cf\u51cf\u5c11 60%<\/td>\n<\/tr>\n
INDEX<\/td>\n\u9759\u6001\u7edd\u5bf9\u7d22\u5f15，\u57fa\u4e8e\u56fa\u5b9a\u4f4d\u7f6e（\u7b2c N \u884c \/ \u6700\u540e\u4e00\u884c）\u53d6\u6570，\u53c2\u6570\u4e0eOFFSET\u5b8c\u5168\u517c\u5bb9<\/td>\nFILTER+TOPN+COUNTROWS<\/td>\n1. \u76f4\u63a5\u5b9a\u4f4d\u56fa\u5b9a\u884c，\u65e0\u9700\u8ba1\u7b97\u504f\u79fb；2. \u5206\u533a\u7d22\u5f15（\u5982\u6309\u5e74\u53d6\u9996\u884c）\u65e0\u9700\u989d\u5916\u903b\u8f91；3. \u652f\u6301-1\u76f4\u63a5\u53d6\u6700\u540e\u4e00\u884c，\u7b80\u5316\u6781\u503c\u67e5\u8be2<\/td>\n\u6027\u80fd\u63d0\u5347 50%+；\u65e0\u9700\u624b\u52a8\u8ba1\u7b97\u884c\u4f4d\u7f6e，\u4e0d\u6613\u51fa\u9519<\/td>\n<\/tr>\n
WINDOW<\/td>\n\u81ea\u5b9a\u4e49\u7a97\u53e3\u8303\u56f4（\u76f8\u5bf9 \/ \u7edd\u5bf9），\u652f\u6301\u591a\u884c\u5217\u805a\u5408，\u8986\u76d6\u6eda\u52a8 \/ \u7d2f\u8ba1 \/ \u5e15\u7d2f\u6258\u5206\u6790<\/td>\nFILTER+SUMX+EARLIER（\u7d2f\u8ba1）\u3001TOPN+SUMX（\u6eda\u52a8）<\/td>\n1. \u539f\u751f\u652f\u6301\u7a97\u53e3\u8303\u56f4\u5b9a\u4e49，\u65e0\u9700\u624b\u52a8\u7b5b\u9009；2. \u652f\u6301ABS\/REL\u53cc\u4f4d\u7f6e\u7c7b\u578b，\u9002\u914d\u6240\u6709\u7a97\u53e3\u573a\u666f；3. \u5206\u533a\u7a97\u53e3\u8ba1\u7b97\u66f4\u7b80\u6d01<\/td>\n\u6027\u80fd\u63d0\u5347 40%-70%（\u6570\u636e\u91cf＞10 \u4e07\u884c\u65f6\u66f4\u660e\u663e）；\u4ee3\u7801\u91cf\u51cf\u5c11 70%<\/td>\n<\/tr>\n
RANK<\/td>\n\u7b80\u5316\u7248\u6392\u540d\u51fd\u6570，\u539f\u751f\u652f\u6301\u5206\u533a \/ \u591a\u5b57\u6bb5\u6392\u5e8f \/ \u5e76\u5217\u5904\u7406<\/td>\nRANKX<\/td>\n1. \u65e0\u9700\u624b\u52a8\u6307\u5b9a\u6392\u540d\u6570\u636e\u96c6，\u8bed\u6cd5\u66f4\u7b80\u6d01；2. \u539f\u751f\u652f\u6301PARTITIONBY\u5206\u533a\u6392\u540d；3. \u591a\u5b57\u6bb5\u6392\u540d\u65e0\u9700\u5d4c\u5957CONCATENATEX<\/td>\n\u6027\u80fd\u6301\u5e73，\u4f46\u8bed\u6cd5\u91cf\u51cf\u5c11 50%，\u53ef\u8bfb\u6027\u63d0\u5347<\/td>\n<\/tr>\n
ROWNUMBER<\/td>\n\u8fde\u7eed\u884c\u53f7\u751f\u6210，\u652f\u6301\u5206\u533a \/ \u6392\u5e8f，\u65e0\u8df3\u8fc7\u884c\u53f7<\/td>\nCOUNTROWS+FILTER+EARLIER<\/td>\n1. \u539f\u751f\u652f\u6301\u5206\u533a\u884c\u53f7（\u6bcf\u4e2a\u5206\u533a\u4ece 1 \u5f00\u59cb）；2. \u65e0\u9700\u624b\u52a8\u7d2f\u52a0，\u907f\u514d\u4e0a\u4e0b\u6587\u9519\u8bef；3. \u652f\u6301\u591a\u5217\u6392\u5e8f\u751f\u6210\u884c\u53f7<\/td>\n\u6027\u80fd\u63d0\u5347 60%+；\u5f7b\u5e95\u89e3\u51b3\u4f20\u7edf\u884c\u53f7\u7684\u4e0a\u4e0b\u6587\u51b2\u7a81\u95ee\u9898<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n

\u4e8c\u3001\u57fa\u7840\u6570\u636e（2024-2025 \u5e74，\u5b63\u5ea6\u5212\u5206\u7cbe\u51c6）<\/h3>\n

1. \u65e5\u5386\u8868（Dim Calendar）<\/h4>\n

\u00a0DAX \u751f\u6210：<\/p>\n

Dim Calendar =
\nADDCOLUMNS(
\n CALENDAR(
\n DATE( 2024 , 1 , 1 ) , \/\/ \u5f00\u59cb\u65e5\u671f
\n DATE( 2025 , 12 , 31 ) \/\/ \u7ed3\u675f\u65e5\u671f
\n ),
\n "\u5e74\u5ea6" , YEAR( [Date] ) ,
\n "\u6708\u4efd" , MONTH( [Date] ) ,
\n "\u6708\u4efd\u5e8f\u53f7" , MONTH( [Date] ) ,
\n "\u5b63\u5ea6" , "Q" & QUARTER( [Date] ) ,
\n "\u5e74\u5ea6\u5b63\u5ea6" , YEAR( [Date] ) & "Q" & QUARTER( [Date] ) ,
\n "\u6708\u4efd\u540d\u79f0 CN" ,
\n SWITCH(
\n MONTH( [Date] ),
\n 1, "\u4e00\u6708",
\n 2, "\u4e8c\u6708",
\n 3, "\u4e09\u6708",
\n 4, "\u56db\u6708",
\n 5, "\u4e94\u6708",
\n 6, "\u516d\u6708",
\n 7, "\u4e03\u6708",
\n 8, "\u516b\u6708",
\n 9, "\u4e5d\u6708",
\n 10, "\u5341\u6708",
\n 11, "\u5341\u4e00\u6708",
\n 12, "\u5341\u4e8c\u6708",
\n "\u672a\u77e5\u6708\u4efd"
\n )
\n)<\/p>\n

2. \u9500\u552e\u8868（Fact Sales）<\/h4>\n

\u4fee\u6b63\u540e\u7cbe\u51c6\u6570\u636e（\u6309\u81ea\u7136\u6708 \/ \u5b63\u5ea6\u5212\u5206，\u624b\u5de5\u8ba1\u7b97\u53ef\u9a8c\u8bc1）：<\/p>\n\n\u65e5\u671f\u4ea7\u54c1\u540d\u79f0\u9500\u552e\u989d\u6210\u672c\u6307\u6807\u4e00\u6307\u6807\u4e8c\u662f\u5426\u8fbe\u6807（1 = \u8fbe\u6807 \/ 0 = \u672a\u8fbe\u6807）\u5e74\u5ea6\u5b63\u5ea6\u5e74\u5ea6\u5b63\u5ea6<\/tr>\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n
2024-01-01<\/td>\n\u4ea7\u54c1 A<\/td>\n15000<\/td>\n7500<\/td>\n80<\/td>\n90<\/td>\n1<\/td>\n2024<\/td>\nQ1<\/td>\n2024Q1<\/td>\n<\/tr>\n
2024-02-01<\/td>\n\u4ea7\u54c1 A<\/td>\n16000<\/td>\n8000<\/td>\n85<\/td>\n88<\/td>\n1<\/td>\n2024<\/td>\nQ1<\/td>\n2024Q1<\/td>\n<\/tr>\n
2024-03-01<\/td>\n\u4ea7\u54c1 A<\/td>\n17000<\/td>\n8500<\/td>\n85<\/td>\n85<\/td>\n0<\/td>\n2024<\/td>\nQ1<\/td>\n2024Q1<\/td>\n<\/tr>\n
2024-04-01<\/td>\n\u4ea7\u54c1 A<\/td>\n18000<\/td>\n9000<\/td>\n90<\/td>\n92<\/td>\n1<\/td>\n2024<\/td>\nQ2<\/td>\n2024Q2<\/td>\n<\/tr>\n
2024-05-01<\/td>\n\u4ea7\u54c1 A<\/td>\n19000<\/td>\n9500<\/td>\n90<\/td>\n95<\/td>\n1<\/td>\n2024<\/td>\nQ2<\/td>\n2024Q2<\/td>\n<\/tr>\n
2024-06-01<\/td>\n\u4ea7\u54c1 A<\/td>\n20000<\/td>\n10000<\/td>\n90<\/td>\n95<\/td>\n1<\/td>\n2024<\/td>\nQ2<\/td>\n2024Q2<\/td>\n<\/tr>\n
2024-07-01<\/td>\n\u4ea7\u54c1 A<\/td>\n21000<\/td>\n10500<\/td>\n92<\/td>\n96<\/td>\n1<\/td>\n2024<\/td>\nQ3<\/td>\n2024Q3<\/td>\n<\/tr>\n
2024-08-01<\/td>\n\u4ea7\u54c1 A<\/td>\n22000<\/td>\n11000<\/td>\n92<\/td>\n97<\/td>\n1<\/td>\n2024<\/td>\nQ3<\/td>\n2024Q3<\/td>\n<\/tr>\n
2024-09-01<\/td>\n\u4ea7\u54c1 A<\/td>\n23000<\/td>\n11500<\/td>\n92<\/td>\n98<\/td>\n1<\/td>\n2024<\/td>\nQ3<\/td>\n2024Q3<\/td>\n<\/tr>\n
2024-10-01<\/td>\n\u4ea7\u54c1 A<\/td>\n24000<\/td>\n12000<\/td>\n95<\/td>\n99<\/td>\n1<\/td>\n2024<\/td>\nQ4<\/td>\n2024Q4<\/td>\n<\/tr>\n
2024-11-01<\/td>\n\u4ea7\u54c1 A<\/td>\n25000<\/td>\n12500<\/td>\n95<\/td>\n99<\/td>\n0<\/td>\n2024<\/td>\nQ4<\/td>\n2024Q4<\/td>\n<\/tr>\n
2024-12-01<\/td>\n\u4ea7\u54c1 A<\/td>\n26000<\/td>\n13000<\/td>\n95<\/td>\n99<\/td>\n1<\/td>\n2024<\/td>\nQ4<\/td>\n2024Q4<\/td>\n<\/tr>\n
2025-01-01<\/td>\n\u4ea7\u54c1 A<\/td>\n27000<\/td>\n13500<\/td>\n98<\/td>\n100<\/td>\n1<\/td>\n2025<\/td>\nQ1<\/td>\n2025Q1<\/td>\n<\/tr>\n
2025-02-01<\/td>\n\u4ea7\u54c1 A<\/td>\n28000<\/td>\n14000<\/td>\n98<\/td>\n100<\/td>\n0<\/td>\n2025<\/td>\nQ1<\/td>\n2025Q1<\/td>\n<\/tr>\n
2024-01-01<\/td>\n\u4ea7\u54c1 B<\/td>\n8000<\/td>\n4000<\/td>\n70<\/td>\n80<\/td>\n1<\/td>\n2024<\/td>\nQ1<\/td>\n2024Q1<\/td>\n<\/tr>\n
2024-02-01<\/td>\n\u4ea7\u54c1 B<\/td>\n9000<\/td>\n4500<\/td>\n75<\/td>\n82<\/td>\n0<\/td>\n2024<\/td>\nQ1<\/td>\n2024Q1<\/td>\n<\/tr>\n
2024-03-01<\/td>\n\u4ea7\u54c1 B<\/td>\n8500<\/td>\n4200<\/td>\n75<\/td>\n81<\/td>\n0<\/td>\n2024<\/td>\nQ1<\/td>\n2024Q1<\/td>\n<\/tr>\n
2024-04-01<\/td>\n\u4ea7\u54c1 B<\/td>\n9500<\/td>\n4800<\/td>\n80<\/td>\n85<\/td>\n1<\/td>\n2024<\/td>\nQ2<\/td>\n2024Q2<\/td>\n<\/tr>\n
2024-05-01<\/td>\n\u4ea7\u54c1 B<\/td>\n10000<\/td>\n5000<\/td>\n82<\/td>\n86<\/td>\n1<\/td>\n2024<\/td>\nQ2<\/td>\n2024Q2<\/td>\n<\/tr>\n
2024-06-01<\/td>\n\u4ea7\u54c1 B<\/td>\n10500<\/td>\n5200<\/td>\n82<\/td>\n87<\/td>\n1<\/td>\n2024<\/td>\nQ2<\/td>\n2024Q2<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n

\u5173\u952e\u624b\u5de5\u9a8c\u8bc1\u503c（\u5b63\u5ea6\u6c47\u603b）<\/h4>\n\n\u5e74\u5ea6\u5b63\u5ea6\u4ea7\u54c1 A \u9500\u552e\u989d\u4ea7\u54c1 B \u9500\u552e\u989d\u5408\u8ba1\u9500\u552e\u989d<\/tr>\n\n\n\n\n\n\n
2024Q1<\/td>\n15000+16000+17000=48000<\/td>\n8000+9000+8500=25500<\/td>\n73500<\/td>\n<\/tr>\n
2024Q2<\/td>\n18000+19000+20000=57000<\/td>\n9500+10000+10500=30000<\/td>\n87000<\/td>\n<\/tr>\n
2024Q3<\/td>\n21000+22000+23000=66000<\/td>\n–<\/td>\n66000<\/td>\n<\/tr>\n
2024Q4<\/td>\n24000+25000+26000=75000<\/td>\n–<\/td>\n75000<\/td>\n<\/tr>\n
2025Q1<\/td>\n27000+28000=55000（\u4ec5 1-2 \u6708）<\/td>\n–<\/td>\n55000<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n

\u4e09\u3001\u7a97\u53e3\u51fd\u6570\u8be6\u7ec6\u89e3\u6790（\u4fee\u6b63\u7248\u6848\u4f8b + \u7cbe\u51c6\u9a8c\u8bc1）<\/h3>\n

1.1 OFFSET（\u52a8\u6001\u67e5\u8be2\u3001\u6c42\u8fde\u7eed\u503c）<\/h4>\n

OFFSET\u5b8c\u6574\u8bed\u6cd5：<\/p>\n

OFFSET(
\n delta,\/\/ \u504f\u79fb\u884c\u6570：\u6b63\u503c=\u5f53\u524d\u884c\u540e，\u8d1f\u503c=\u5f53\u524d\u884c\u524d，\u652f\u6301DAX\u8868\u8fbe\u5f0f
\n <relation> or <axis>,\/\/ \u53ef\u9009：\u8868\u8868\u8fbe\u5f0f\/\u89c6\u89c9\u8f74，\u9ed8\u8ba4ALLSELECTED(orderBy\/partitionBy\u5217)
\n orderBy, \/\/ \u53ef\u9009：\u6392\u5e8f\u65b9\u5f0f，\u7701\u7565\u5219\u6309relation\u5217\u9ed8\u8ba4\u6392\u5e8f
\n blanks,\/\/ \u53ef\u9009：\u7a7a\u503c\u5904\u7406（DEFAULT\/FIRST\/LAST）
\n partitionBy, \/\/ \u53ef\u9009：\u5206\u533a\u4f9d\u636e，\u6309\u6307\u5b9a\u5217\u5206\u533a\u540e\u5404\u81ea\u504f\u79fb
\n matchBy,\/\/ \u53ef\u9009：\u5b9a\u4e49\u884c\u5339\u914d\u89c4\u5219（\u552f\u4e00\u6807\u8bc6\u884c）
\n reset\/\/ \u53ef\u9009：\u89c6\u89c9\u8ba1\u7b97\u91cd\u7f6e（\u4ec5\u89c6\u89c9\u8f74\u573a\u666f）
\n)<\/p>\n

1.1.1 \u4e0d\u4f7f\u7528 orderBy<\/h5>\n

\u6848\u4f8b 1：\u83b7\u53d6\u4e0a\u4e2a\u5b63\u5ea6\u9500\u552e\u989d（\u65e0\u5206\u533a）<\/p>\n

— \u57fa\u7840\u5ea6\u91cf\u503c（\u4fee\u6b63\u7248）
\n\u9500\u552e\u989d = SUM('Fact Sales'[\u9500\u552e\u989d])<\/p>\n

— OFFSET\u53d6\u4e0a\u5b63\u5ea6\u9500\u552e\u989d（\u65e0\u5206\u533a）
\nOFFSET-\u4e0a\u5b63\u5ea6\u9500\u552e\u989d =
\nCALCULATE(
\n [\u9500\u552e\u989d],
\n OFFSET(
\n -1,\/\/ \u5411\u524d\u504f\u79fb1\u884c
\n ALLSELECTED('Dim Calendar'[\u5e74\u5ea6\u5b63\u5ea6])\/\/ \u504f\u79fb\u7684\u6570\u636e\u96c6
\n )
\n)<\/p>\n

\u7cbe\u51c6\u7ed3\u679c\u9a8c\u8bc1：<\/p>\n\n\u5e74\u5ea6\u5b63\u5ea6\u9500\u552e\u989dOFFSET – \u4e0a\u5b63\u5ea6\u9500\u552e\u989d<\/tr>\n\n\n\n\n\n\n
2024Q1<\/td>\n73500<\/td>\n\u7a7a<\/td>\n<\/tr>\n
2024Q2<\/td>\n87000<\/td>\n73500<\/td>\n<\/tr>\n
2024Q3<\/td>\n66000<\/td>\n87000<\/td>\n<\/tr>\n
2024Q4<\/td>\n75000<\/td>\n66000<\/td>\n<\/tr>\n
2025Q1<\/td>\n55000<\/td>\n75000<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n

\u6848\u4f8b 2：\u6309\u5e74\u5ea6\u5206\u533a\u53d6\u4e0a\u5b63\u5ea6\u9500\u552e\u989d<\/p>\n

OFFSET-\u5e74\u5ea6\u5185\u4e0a\u5b63\u5ea6\u9500\u552e\u989d =
\nCALCULATE(
\n [\u9500\u552e\u989d],
\n OFFSET(
\n -1,
\n ALLSELECTED('Dim Calendar'[\u5e74\u5ea6\u5b63\u5ea6],'Dim Calendar'[\u5e74\u5ea6]),,, \/\/ \u7a7a\u51faorderBy\/blanks\u53c2\u6570
\n PARTITIONBY('Dim Calendar'[\u5e74\u5ea6]) \/\/ \u6309\u5e74\u5ea6\u5206\u533a
\n )
\n)<\/p>\n

\u7cbe\u51c6\u7ed3\u679c\u9a8c\u8bc1（\u5e74\u5ea6\u5185\u504f\u79fb，\u8de8\u5e74\u5ea6\u91cd\u7f6e）：<\/p>\n\n\u5e74\u5ea6\u5e74\u5ea6\u5b63\u5ea6\u9500\u552e\u989dOFFSET – \u5e74\u5ea6\u5185\u4e0a\u5b63\u5ea6\u9500\u552e\u989d<\/tr>\n\n\n\n\n\n\n
2024<\/td>\n2024Q1<\/td>\n73500<\/td>\n\u7a7a<\/td>\n<\/tr>\n
2024<\/td>\n2024Q2<\/td>\n87000<\/td>\n73500<\/td>\n<\/tr>\n
2024<\/td>\n2024Q3<\/td>\n66000<\/td>\n87000<\/td>\n<\/tr>\n
2024<\/td>\n2024Q4<\/td>\n75000<\/td>\n66000<\/td>\n<\/tr>\n
2025<\/td>\n2025Q1<\/td>\n55000<\/td>\n\u7a7a<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n
1.1.2 \u4f7f\u7528 orderBy<\/h5>\n

\u6848\u4f8b：\u6309\u6708\u4efd\u5e8f\u53f7\u53d6\u4e0a\u6708\u9500\u552e\u989d<\/p>\n

OFFSET-\u4e0a\u6708\u9500\u552e\u989d =
\nCALCULATE(
\n [\u9500\u552e\u989d] ,
\n OFFSET(
\n -1, \/\/ \u5411\u524d\u504f\u79fb1\u884c（\u4e0a\u6708）
\n ALLSELECTED( 'Dim Calendar'[\u6708\u4efd\u540d\u79f0 CN] , 'Dim Calendar'[\u6708\u4efd\u5e8f\u53f7] ), \/\/ \u6570\u636e\u96c6
\n ORDERBY( 'Dim Calendar'[\u6708\u4efd\u5e8f\u53f7] , ASC ) \/\/ \u6309\u6708\u4efd\u5e8f\u53f7\u5347\u5e8f\u6392\u5e8f
\n )
\n)<\/p>\n

\u7cbe\u51c6\u7ed3\u679c\u9a8c\u8bc1（2024 \u5e74 1-4 \u6708）：<\/p>\n\n\u6708\u4efd\u540d\u79f0 CN\u6708\u4efd\u5e8f\u53f7\u9500\u552e\u989dOFFSET – \u4e0a\u6708\u9500\u552e\u989d<\/tr>\n\n\n\n\n\n
\u4e00\u6708<\/td>\n1<\/td>\n23000<\/td>\n\u7a7a<\/td>\n<\/tr>\n
\u4e8c\u6708<\/td>\n2<\/td>\n25000<\/td>\n23000<\/td>\n<\/tr>\n
\u4e09\u6708<\/td>\n3<\/td>\n25500<\/td>\n25000<\/td>\n<\/tr>\n
\u56db\u6708<\/td>\n4<\/td>\n27500<\/td>\n25500<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n
1.1.3 \u7edf\u8ba1\u8fde\u7eed\u503c\u7684\u6700\u5927\u51fa\u73b0\u6b21\u6570（\u5f85\u8865\u5145）<\/h5>\n

\u6848\u4f8b：\u7edf\u8ba1\u4ea7\u54c1 A \u8fde\u7eed\u8fbe\u6807\u7684\u6700\u5927\u6708\u4efd\u6570<\/p>\n<\/p>\n

1.2 INDEX（\u9759\u6001\u67e5\u8be2）<\/h4>\n

INDEX\u5b8c\u6574\u8bed\u6cd5：<\/p>\n

INDEX(
\n position,\/\/ \u68c0\u7d22\u4f4d\u7f6e：1=\u7b2c\u4e00\u884c，-1=\u6700\u540e\u4e00\u884c，\u8d8a\u754c\u8fd4\u56de\u7a7a\u8868
\n <relation> or <axis>,\/\/ \u53ef\u9009：\u8868\u8868\u8fbe\u5f0f\/\u89c6\u89c9\u8f74，\u540cOFFSET
\n orderBy, \/\/ \u53ef\u9009：\u6392\u5e8f\u4f9d\u636e，\u540cOFFSET
\n blanks,\/\/ \u53ef\u9009：\u7a7a\u503c\u5904\u7406，\u540cOFFSET
\n partitionBy, \/\/ \u53ef\u9009：\u5206\u533a\u4f9d\u636e，\u540cOFFSET
\n matchBy,\/\/ \u53ef\u9009：\u884c\u5339\u914d\u89c4\u5219，\u540cOFFSET
\n reset\/\/ \u53ef\u9009：\u89c6\u89c9\u8ba1\u7b97\u91cd\u7f6e，\u540cOFFSET
\n)<\/p>\n

\u6848\u4f8b 1：\u83b7\u53d6\u5168\u8868\u7b2c\u4e00\u5b63\u5ea6\u9500\u552e\u989d（\u65e0\u5206\u533a）<\/h5>\n

INDEX-\u7b2c\u4e00\u5b63\u5ea6\u9500\u552e\u989d =
\nCALCULATE(
\n [\u9500\u552e\u989d],
\n INDEX(1,ALLSELECTED('Dim Calendar'[\u5e74\u5ea6\u5b63\u5ea6])) \/\/ \u53d6\u7b2c1\u884c（2024Q1）
\n)<\/p>\n

\u7cbe\u51c6\u7ed3\u679c：\u65e0\u8bba\u7b5b\u9009\u54ea\u4e2a\u5b63\u5ea6，\u5747\u8fd4\u56de73500（2024Q1 \u5408\u8ba1\u9500\u552e\u989d）\u3002<\/p>\n

\u6848\u4f8b 2：\u6309\u5e74\u5ea6\u5206\u533a\u83b7\u53d6\u672c\u5e74\u7b2c\u4e00\u5b63\u5ea6\u9500\u552e\u989d<\/h5>\n

INDEX-\u5e74\u5ea6\u5185\u7b2c\u4e00\u5b63\u5ea6\u9500\u552e\u989d =
\nCALCULATE(
\n [\u9500\u552e\u989d],
\n INDEX(
\n 1,
\n ALLSELECTED('Dim Calendar'[\u5e74\u5ea6\u5b63\u5ea6],'Dim Calendar'[\u5e74\u5ea6]),,,
\n PARTITIONBY('Dim Calendar'[\u5e74\u5ea6]) \/\/ \u6309\u5e74\u5ea6\u5206\u533a
\n )
\n)<\/p>\n

\u7cbe\u51c6\u7ed3\u679c\u9a8c\u8bc1：<\/p>\n\n\u5e74\u5ea6\u5e74\u5ea6\u5b63\u5ea6INDEX – \u5e74\u5ea6\u5185\u7b2c\u4e00\u5b63\u5ea6\u9500\u552e\u989d<\/tr>\n\n\n\n\n
2024<\/td>\n2024Q1<\/td>\n73500<\/td>\n<\/tr>\n
2024<\/td>\n2024Q2<\/td>\n73500<\/td>\n<\/tr>\n
2025<\/td>\n2025Q1<\/td>\n55000<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n
\u6848\u4f8b 3：\u53d6\u4ea7\u54c1\u9500\u552e\u989d\u6700\u540e\u4e00\u884c（\u6700\u65b0\u6708\u4efd）<\/h5>\n

INDEX-\u4ea7\u54c1\u6700\u65b0\u9500\u552e\u989d =
\nVAR AggregatedSingleTable =
\n SUMMARIZE(
\n \/\/ \u57fa\u7840\u8868：\u4e8b\u5b9e\u8868（\u5df2\u4e0e\u65e5\u671f\u8868\u5efa\u7acb\u5173\u8054）
\n ALLSELECTED('Fact Sales'),
\n \/\/ \u5206\u7ec4\u5b57\u6bb51：\u4ea7\u54c1\u540d\u79f0（\u6765\u6e90\u4e8e\u4e8b\u5b9e\u8868）
\n 'Fact Sales'[\u4ea7\u54c1\u540d\u79f0],
\n \/\/ \u5206\u7ec4\u5b57\u6bb52：\u65e5\u671f（\u901a\u8fc7\u8868\u5173\u7cfb\u5173\u8054\u65e5\u671f\u8868，\u7b49\u4ef7\u4fdd\u7559\u65e5\u671f\u8868\u7684\u5916\u90e8\u7b5b\u9009\u6761\u4ef6）
\n 'Dim Calendar'[Date],
\n \/\/ \u8ba1\u7b97\u6bcf\u4e2a（\u4ea7\u54c1+\u65e5\u671f）\u7ec4\u5408\u5bf9\u5e94\u7684\u9500\u552e\u989d
\n "ProductDateSales", CALCULATE(SUM('Fact Sales'[\u9500\u552e\u989d])) \/\/ \u76f4\u63a5\u8ba1\u7b97\u907f\u514d\u91cd\u590d\u7b5b\u9009，\u63d0\u5347\u6548\u7387
\n )
\nRETURN
\nCALCULATE(
\n [\u9500\u552e\u989d],
\n INDEX(
\n -1, \/\/ \u9009\u53d6\u6bcf\u7ec4\u4e2d\u65e5\u671f\u6700\u65b0\u7684\u4e00\u884c
\n AggregatedSingleTable, \/\/ \u6570\u636e\u8303\u56f4\u4e3aSUMMARIZE\u751f\u6210\u7684\u5355\u5f20\u805a\u5408\u8868
\n ORDERBY('Dim Calendar'[Date], ASC),
\n PARTITIONBY('Fact Sales'[\u4ea7\u54c1\u540d\u79f0])
\n )
\n)<\/p>\n

\u7cbe\u51c6\u7ed3\u679c：<\/p>\n

    \n
  • \u4ea7\u54c1 A：28000（2025-02）<\/li>\n
  • \u4ea7\u54c1 B：10500（2024-06）<\/li>\n<\/ul>\n

    1.3 WINDOW（\u6eda\u52a8\u6c42\u548c\u3001\u7d2f\u8ba1\u6c42\u548c\u3001\u5e15\u7d2f\u6258\u5206\u6790）<\/h4>\n

    WINDOW\u5b8c\u6574\u8bed\u6cd5：<\/p>\n

    WINDOW(
    \n from[, from_type],\/\/ \u7a97\u53e3\u5f00\u59cb\u4f4d\u7f6e+\u7c7b\u578b：ABS=\u7edd\u5bf9\u4f4d\u7f6e，REL=\u76f8\u5bf9\u4f4d\u7f6e（\u9ed8\u8ba4）
    \n to[, to_type],\/\/ \u7a97\u53e3\u7ed3\u675f\u4f4d\u7f6e+\u7c7b\u578b：\u540cfrom_type
    \n <relation> or <axis>,\/\/ \u53ef\u9009：\u8868\u8868\u8fbe\u5f0f\/\u89c6\u89c9\u8f74，\u540cOFFSET
    \n <orderBy>,\/\/ \u53ef\u9009：\u6392\u5e8f\u4f9d\u636e，\u540cOFFSET
    \n <blanks>,\/\/ \u53ef\u9009：\u7a7a\u503c\u5904\u7406，\u540cOFFSET
    \n <partitionBy>,\/\/ \u53ef\u9009：\u5206\u533a\u4f9d\u636e，\u540cOFFSET
    \n <matchBy>,\/\/ \u53ef\u9009：\u884c\u5339\u914d\u89c4\u5219，\u540cOFFSET
    \n <reset>\/\/ \u53ef\u9009：\u89c6\u89c9\u8ba1\u7b97\u91cd\u7f6e，\u540cOFFSET
    \n)<\/p>\n

    1.3.1 \u6eda\u52a8\u6c42\u548c\u4e0e\u7d2f\u8ba1\u6c42\u548c<\/h5>\n

    \u6848\u4f8b 1：\u6eda\u52a8\u6c42\u548c（\u8fd1 2 \u4e2a\u5b63\u5ea6\u9500\u552e\u989d\u6c42\u548c）<\/p>\n

    WINDOW-\u8fd12\u5b63\u5ea6\u6eda\u52a8\u9500\u552e\u989d =
    \nCALCULATE(
    \n [\u9500\u552e\u989d],
    \n WINDOW(
    \n -1,REL, \/\/ \u5f00\u59cb：\u5f53\u524d\u884c\u524d1\u884c（REL=\u76f8\u5bf9\u4f4d\u7f6e）
    \n 0,REL, \/\/ \u7ed3\u675f：\u5f53\u524d\u884c
    \n ALLSELECTED('Dim Calendar'[\u5e74\u5ea6\u5b63\u5ea6]),
    \n ORDERBY('Dim Calendar'[\u5e74\u5ea6\u5b63\u5ea6], ASC)
    \n )
    \n)<\/p>\n

    \u7cbe\u51c6\u7ed3\u679c\u9a8c\u8bc1：<\/p>\n\n\u5e74\u5ea6\u5b63\u5ea6\u9500\u552e\u989dWINDOW – \u8fd1 2 \u5b63\u5ea6\u6eda\u52a8\u9500\u552e\u989d<\/tr>\n\n\n\n\n\n\n
    2024Q1<\/td>\n73500<\/td>\n73500<\/td>\n<\/tr>\n
    2024Q2<\/td>\n87000<\/td>\n160500（73500+87000）<\/td>\n<\/tr>\n
    2024Q3<\/td>\n66000<\/td>\n153000（87000+66000）<\/td>\n<\/tr>\n
    2024Q4<\/td>\n75000<\/td>\n141000（66000+75000）<\/td>\n<\/tr>\n
    2025Q1<\/td>\n55000<\/td>\n130000（75000+55000）<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n

    \u6848\u4f8b 2：\u7d2f\u8ba1\u6c42\u548c（\u5e74\u521d\u81f3\u4eca\u9500\u552e\u989d）<\/p>\n

    WINDOW-\u5e74\u521d\u81f3\u4eca\u9500\u552e\u989d =
    \nCALCULATE(
    \n [\u9500\u552e\u989d],
    \n WINDOW(
    \n 1,ABS, \/\/ \u5f00\u59cb：\u5206\u533a\u7b2c1\u884c（ABS=\u7edd\u5bf9\u4f4d\u7f6e）
    \n 0,REL, \/\/ \u7ed3\u675f：\u5f53\u524d\u884c
    \n ALLSELECTED('Dim Calendar'[\u5e74\u5ea6\u5b63\u5ea6], 'Dim Calendar'[\u5e74\u5ea6]),
    \n ORDERBY('Dim Calendar'[\u5e74\u5ea6\u5b63\u5ea6], ASC),,,
    \n PARTITIONBY('Dim Calendar'[\u5e74\u5ea6]) \/\/ \u6309\u5e74\u5ea6\u5206\u533a\u7d2f\u8ba1
    \n )
    \n)<\/p>\n

    \u7cbe\u51c6\u7ed3\u679c\u9a8c\u8bc1：<\/p>\n\n\u5e74\u5ea6\u5e74\u5ea6\u5b63\u5ea6\u9500\u552e\u989dWINDOW – \u5e74\u521d\u81f3\u4eca\u9500\u552e\u989d<\/tr>\n\n\n\n\n\n\n
    2024<\/td>\n2024Q1<\/td>\n73500<\/td>\n73500<\/td>\n<\/tr>\n
    2024<\/td>\n2024Q2<\/td>\n87000<\/td>\n160500（73500+87000）<\/td>\n<\/tr>\n
    2024<\/td>\n2024Q3<\/td>\n66000<\/td>\n226500（160500+66000）<\/td>\n<\/tr>\n
    2024<\/td>\n2024Q4<\/td>\n75000<\/td>\n301500（226500+75000）<\/td>\n<\/tr>\n
    2025<\/td>\n2025Q1<\/td>\n55000<\/td>\n55000<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n
    1.3.2 \u5e15\u7d2f\u6258\u5206\u6790（\u4e8c\u516b\u5b9a\u5f8b）<\/h5>\n

    \u6848\u4f8b：\u4ea7\u54c1\u9500\u552e\u989d\u5e15\u7d2f\u6258\u5206\u6790（80% \u9500\u552e\u989d\u5bf9\u5e94\u4ea7\u54c1\u5360\u6bd4）<\/p>\n

    — \u6b65\u9aa41：\u5355\u4e2a\u4ea7\u54c1\u603b\u9500\u552e\u989d
    \n\u4ea7\u54c1\u9500\u552e\u989d = CALCULATE([\u9500\u552e\u989d], ALLSELECTED('Dim Calendar'[Date]))<\/p>\n

    — \u6b65\u9aa42：\u6240\u6709\u4ea7\u54c1\u603b\u9500\u552e\u989d
    \n\u603b\u9500\u552e\u989d = CALCULATE([\u9500\u552e\u989d], ALL('Fact Sales'[\u4ea7\u54c1\u540d\u79f0]))<\/p>\n

    — \u6b65\u9aa43：WINDOW\u8ba1\u7b97\u7d2f\u8ba1\u9500\u552e\u989d（\u6309\u9500\u552e\u989d\u964d\u5e8f）
    \n\u7d2f\u8ba1\u9500\u552e\u989d =
    \nCALCULATE(
    \n [\u9500\u552e\u989d],
    \n WINDOW(
    \n 1,ABS, \/\/ \u5f00\u59cb：\u7b2c1\u884c（\u9500\u552e\u989d\u6700\u9ad8）
    \n 0,REL, \/\/ \u7ed3\u675f：\u5f53\u524d\u884c
    \n ALLSELECTED('Fact Sales'[\u4ea7\u54c1\u540d\u79f0]),
    \n ORDERBY([\u4ea7\u54c1\u9500\u552e\u989d], DESC) \/\/ \u6309\u9500\u552e\u989d\u964d\u5e8f\u6392\u5e8f
    \n )
    \n)<\/p>\n

    — \u6b65\u9aa44：\u7d2f\u8ba1\u9500\u552e\u989d\u5360\u6bd4
    \n\u7d2f\u8ba1\u9500\u552e\u989d\u5360\u6bd4 = DIVIDE([\u7d2f\u8ba1\u9500\u552e\u989d], [\u603b\u9500\u552e\u989d], 0)<\/p>\n

    — \u6b65\u9aa45：\u8d21\u732e80%\u9500\u552e\u989d\u7684\u4ea7\u54c1\u5360\u6bd4
    \n80%\u9500\u552e\u989d\u4ea7\u54c1\u5360\u6bd4 =
    \nVAR Pareto80 =
    \nFILTER(
    \n ALLSELECTED('Fact Sales'[\u4ea7\u54c1\u540d\u79f0]),
    \n [\u7d2f\u8ba1\u9500\u552e\u989d\u5360\u6bd4] <= 0.8
    \n)
    \nRETURN
    \nDIVIDE(COUNTROWS(Pareto80), COUNTROWS(ALL('Fact Sales'[\u4ea7\u54c1\u540d\u79f0])), 0)<\/p>\n

    \u7cbe\u51c6\u7ed3\u679c\u9a8c\u8bc1：<\/p>\n

      \n
    • \u4ea7\u54c1 A \u603b\u9500\u552e\u989d：15000+16000+17000+18000+19000+20000+21000+22000+23000+24000+25000+26000+27000+28000 = 301000<\/li>\n
    • \u4ea7\u54c1 B \u603b\u9500\u552e\u989d：8000+9000+8500+9500+10000+10500 = 55500<\/li>\n
    • \u603b\u9500\u552e\u989d：301000+55500 = 356500<\/li>\n
    • \u4ea7\u54c1 A \u5360\u6bd4：301000\/356500 \u2248 84.43%（\u5df2\u8d85 80%）<\/li>\n
    • \u6700\u7ec880%\u9500\u552e\u989d\u4ea7\u54c1\u5360\u6bd4\u8fd4\u56de50%（\u4ec5\u4ea7\u54c1 A \u5c31\u8986\u76d6 80%+ \u9500\u552e\u989d）\u3002<\/li>\n<\/ul>\n

      1.4 RANK（\u591a\u5b57\u6bb5\u6392\u540d \/ \u5206\u533a\u6392\u540d）<\/h4>\n

      RANK\u5b8c\u6574\u8bed\u6cd5：<\/p>\n

      RANK (
      \n [<ties>],\/\/ \u53ef\u9009：\u5e76\u5217\u5904\u7406（SKIP=\u8df3\u8dc3\u6392\u540d，DENSE=\u8fde\u7eed\u6392\u540d），\u9ed8\u8ba4SKIP
      \n [<relation> or <axis>],\/\/ \u53ef\u9009：\u8868\u8868\u8fbe\u5f0f\/\u89c6\u89c9\u8f74，\u540cOFFSET
      \n [<orderBy>],\/\/ \u53ef\u9009：\u6392\u5e8f\u4f9d\u636e，\u652f\u6301\u591a\u5b57\u6bb5
      \n [<blanks>],\/\/ \u53ef\u9009：\u7a7a\u503c\u5904\u7406，\u540cOFFSET
      \n [<partitionBy>],\/\/ \u53ef\u9009：\u5206\u533a\u4f9d\u636e，\u540cOFFSET
      \n [<matchBy>],\/\/ \u53ef\u9009：\u884c\u5339\u914d\u89c4\u5219，\u540cOFFSET
      \n [<reset>]\/\/ \u53ef\u9009：\u89c6\u89c9\u8ba1\u7b97\u91cd\u7f6e，\u540cOFFSET
      \n)<\/p>\n

      \u6848\u4f8b 1：\u591a\u5b57\u6bb5\u6392\u540d（\u6307\u6807\u4e00\u964d\u5e8f\u2192\u6307\u6807\u4e8c\u964d\u5e8f）<\/h5>\n

      — \u57fa\u7840\u5ea6\u91cf\u503c
      \n\u6307\u6807\u4e00\u5408\u8ba1 = SUM('Fact Sales'[\u6307\u6807\u4e00])
      \n\u6307\u6807\u4e8c\u5408\u8ba1 = SUM('Fact Sales'[\u6307\u6807\u4e8c])<\/p>\n

      — \u591a\u5b57\u6bb5\u6392\u540d
      \n\u591a\u5b57\u6bb5\u6392\u540d =
      \nRANK(
      \n SKIP, \/\/ \u5e76\u5217\u8df3\u8dc3\u6392\u540d
      \n ALLSELECTED('Fact Sales'[\u4ea7\u54c1\u540d\u79f0]),
      \n ORDERBY([\u6307\u6807\u4e00\u5408\u8ba1], DESC, [\u6307\u6807\u4e8c\u5408\u8ba1], DESC) \/\/ \u5148\u6307\u6807\u4e00，\u540e\u6307\u6807\u4e8c
      \n)<\/p>\n

      \u7cbe\u51c6\u7ed3\u679c\u9a8c\u8bc1：<\/p>\n\n\u4ea7\u54c1\u540d\u79f0\u6307\u6807\u4e00\u5408\u8ba1\u6307\u6807\u4e8c\u5408\u8ba1\u591a\u5b57\u6bb5\u6392\u540d<\/tr>\n\n\n\n
      \u4ea7\u54c1 A<\/td>\n80+85+85+90+90+90+92+92+92+95+95+95+98+98 = 1267<\/td>\n90+88+85+92+95+95+96+97+98+99+99+99+100+100 = 1323<\/td>\n1<\/td>\n<\/tr>\n
      \u4ea7\u54c1 B<\/td>\n70+75+75+80+82+82 = 464<\/td>\n80+82+81+85+86+87 = 501<\/td>\n2<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n
      \u6848\u4f8b 2：\u5206\u533a\u6392\u540d（\u6309\u6708\u4efd\u5206\u533a，\u4ea7\u54c1\u9500\u552e\u989d\u6392\u540d）<\/h5>\n

      \u6708\u5ea6\u4ea7\u54c1\u9500\u552e\u989d\u6392\u540d =
      \nRANK(
      \n DENSE, \/\/ \u5e76\u5217\u8fde\u7eed\u6392\u540d
      \n ALLSELECTED('Dim Calendar'[\u6708\u4efd], 'Fact Sales'[\u4ea7\u54c1\u540d\u79f0]),
      \n ORDERBY([\u9500\u552e\u989d], DESC),,,
      \n PARTITIONBY('Dim Calendar'[\u6708\u4efd]) \/\/ \u6309\u6708\u4efd\u5206\u533a
      \n)<\/p>\n

      \u7cbe\u51c6\u7ed3\u679c\u9a8c\u8bc1（2024 \u5e74 1 \u6708）：<\/p>\n\n\u6708\u4efd\u4ea7\u54c1\u540d\u79f0\u9500\u552e\u989d\u6708\u5ea6\u4ea7\u54c1\u9500\u552e\u989d\u6392\u540d<\/tr>\n\n\n\n
      1<\/td>\n\u4ea7\u54c1 A<\/td>\n15000<\/td>\n1<\/td>\n<\/tr>\n
      1<\/td>\n\u4ea7\u54c1 B<\/td>\n8000<\/td>\n2<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n

      1.5 ROWNUMBER（\u5206\u533a\u884c\u53f7 \/ \u8fde\u7eed\u884c\u53f7）<\/h4>\n

      ROWNUMBER\u5b8c\u6574\u8bed\u6cd5：<\/p>\n

      ROWNUMBER (
      \n [<relation> or <axis>],\/\/ \u53ef\u9009：\u8868\u8868\u8fbe\u5f0f\/\u89c6\u89c9\u8f74，\u540cOFFSET
      \n [<orderBy>],\/\/ \u53ef\u9009：\u6392\u5e8f\u4f9d\u636e，\u540cOFFSET
      \n [<blanks>],\/\/ \u53ef\u9009：\u7a7a\u503c\u5904\u7406，\u540cOFFSET
      \n [<partitionBy>],\/\/ \u53ef\u9009：\u5206\u533a\u4f9d\u636e，\u540cOFFSET
      \n [<matchBy>],\/\/ \u53ef\u9009：\u884c\u5339\u914d\u89c4\u5219，\u540cOFFSET
      \n [<reset>]\/\/ \u53ef\u9009：\u89c6\u89c9\u8ba1\u7b97\u91cd\u7f6e，\u540cOFFSET
      \n)<\/p>\n

      \u6848\u4f8b 1：\u5168\u8868\u8fde\u7eed\u884c\u53f7（\u6309\u9500\u552e\u989d\u964d\u5e8f）<\/h5>\n

      \u4ea7\u54c1\u8fde\u7eed\u884c\u53f7 =
      \nROWNUMBER(
      \n ALLSELECTED('Fact Sales'[\u4ea7\u54c1\u540d\u79f0]),
      \n ORDERBY([\u4ea7\u54c1\u9500\u552e\u989d], DESC)
      \n)<\/p>\n

      \u7cbe\u51c6\u7ed3\u679c：<\/p>\n

        \n
      • \u4ea7\u54c1 A \u884c\u53f7：1<\/li>\n
      • \u4ea7\u54c1 B \u884c\u53f7：2<\/li>\n<\/ul>\n
        \u6848\u4f8b 2：\u5206\u533a\u884c\u53f7（\u6309\u5e74\u5ea6\u5206\u533a，\u5b63\u5ea6\u884c\u53f7）<\/h5>\n

        \u5e74\u5ea6\u5185\u5b63\u5ea6\u884c\u53f7 =
        \nROWNUMBER(
        \n ALLSELECTED('Dim Calendar'[\u5e74\u5ea6], 'Dim Calendar'[\u5b63\u5ea6]),
        \n ORDERBY('Dim Calendar'[\u5b63\u5ea6], ASC),,,
        \n PARTITIONBY('Dim Calendar'[\u5e74\u5ea6])
        \n)<\/p>\n

        \u7cbe\u51c6\u7ed3\u679c\u9a8c\u8bc1：<\/p>\n\n\u5e74\u5ea6\u5b63\u5ea6\u5e74\u5ea6\u5185\u5b63\u5ea6\u884c\u53f7<\/tr>\n\n\n\n\n\n\n
        2024<\/td>\nQ1<\/td>\n1<\/td>\n<\/tr>\n
        2024<\/td>\nQ2<\/td>\n2<\/td>\n<\/tr>\n
        2024<\/td>\nQ3<\/td>\n3<\/td>\n<\/tr>\n
        2024<\/td>\nQ4<\/td>\n4<\/td>\n<\/tr>\n
        2025<\/td>\nQ1<\/td>\n1<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n
        \u6848\u4f8b 3：\u7b5b\u9009\u524d N \u884c（\u53d6\u5e74\u5ea6\u5185\u524d 1 \u4e2a\u5b63\u5ea6\u6570\u636e）<\/h5>\n

        \u5e74\u5ea6\u5185\u524d1\u5b63\u5ea6\u6570\u636e =
        \nFILTER(
        \n ALLSELECTED('Dim Calendar'[\u5e74\u5ea6\u5b63\u5ea6], 'Dim Calendar'[\u5e74\u5ea6]),
        \n [\u5e74\u5ea6\u5185\u5b63\u5ea6\u884c\u53f7] <= 1
        \n)<\/p>\n

        \u7cbe\u51c6\u7ed3\u679c：\u4ec5\u8fd4\u56de 2024Q1\u30012025Q1 \u7684\u6570\u636e\u3002<\/p>\n

        \u56db\u3001\u6838\u5fc3\u603b\u7ed3<\/h3>\n
      • \u51fd\u6570\u4f7f\u7528\u5173\u952e：\n
          \n
        • \u5206\u533a\u8ba1\u7b97\u5fc5\u987b\u5c06\u5206\u533a\u5b57\u6bb5\u52a0\u5165relation\u53c2\u6570（\u5982\u5e74\u5ea6\u5206\u533a\u9700\u5305\u542b\u5e74\u5ea6\u5217）；<\/li>\n
        • \u65f6\u95f4\u7c7b\u504f\u79fb \/ \u7d22\u5f15\u4f18\u5148\u6309\u6708\u4efd\u5e8f\u53f7\/\u5e74\u5ea6\u5b63\u5ea6\u6392\u5e8f，\u907f\u514d\u4e2d\u6587\u6708\u4efd\u6392\u5e8f\u9519\u8bef；<\/li>\n
        • \u5927\u6570\u636e\u91cf\u573a\u666f\u4e0b，WINDOW\u66ff\u4ee3\u4f20\u7edfFILTER+SUMX\u53ef\u663e\u8457\u63d0\u5347\u6027\u80fd（40%-70%）\u3002<\/li>\n<\/ul>\n<\/li>\n","protected":false},"excerpt":{"rendered":"

          \u4e00\u30012022 \u65b0\u589e\u7a97\u53e3\u51fd\u6570\u6838\u5fc3\u7279\u70b9\u4e0e\u4f18\u52bf（vs \u4f20\u7edf\u51fd\u6570）\u51fd\u6570\u6838\u5fc3\u7279\u70b9\u4f20\u7edf\u66ff\u4ee3\u51fd\u6570\u6838\u5fc3\u4f18\u52bf\u6027\u80fd \/ \u6613\u7528\u6027\u5bf9\u6bd4OFFSET\u52a8\u6001\u76f8\u5bf9\u504f\u79fb，\u57fa\u4e8e\u5f53\u524d\u884c\u53d6\u504f\u79fb N \u884c\u6570\u636e，\u652f\u6301\u5206\u533a \/ \u6392\u5e8f \/ \u7a7a\u503c\u63a7\u5236DATEADD\/PREVIOUSMONTH（\u65f6\u95f4\u7c7b）\u3001FILTERTOPN（\u901a\u7528）1. \u8131\u79bb\u65f6\u95f4\u7ef4\u5ea6\u9650\u5236，\u9002\u914d\u4efb\u610f\u7ef4\u5ea6\u504f\u79fb；2. \u539f\u751f\u652f\u6301\u5206<\/p>\n","protected":false},"author":2,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[1],"tags":[87,100,43],"topic":[],"class_list":["post-63302","post","type-post","status-publish","format-standard","hentry","category-server","tag-87","tag-100","tag-43"],"yoast_head":"\nPower BI 2022 + \u65b0\u589e\u7a97\u53e3\u51fd\u6570\u89e3\u6790 - \u7f51\u7855\u4e92\u8054\u5e2e\u52a9\u4e2d\u5fc3<\/title>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/www.wsisp.com\/helps\/63302.html\" \/>\n<meta property=\"og:locale\" content=\"zh_CN\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Power BI 2022 + \u65b0\u589e\u7a97\u53e3\u51fd\u6570\u89e3\u6790 - \u7f51\u7855\u4e92\u8054\u5e2e\u52a9\u4e2d\u5fc3\" \/>\n<meta property=\"og:description\" content=\"\u4e00\u30012022 \u65b0\u589e\u7a97\u53e3\u51fd\u6570\u6838\u5fc3\u7279\u70b9\u4e0e\u4f18\u52bf（vs \u4f20\u7edf\u51fd\u6570）\u51fd\u6570\u6838\u5fc3\u7279\u70b9\u4f20\u7edf\u66ff\u4ee3\u51fd\u6570\u6838\u5fc3\u4f18\u52bf\u6027\u80fd \/ \u6613\u7528\u6027\u5bf9\u6bd4OFFSET\u52a8\u6001\u76f8\u5bf9\u504f\u79fb，\u57fa\u4e8e\u5f53\u524d\u884c\u53d6\u504f\u79fb N \u884c\u6570\u636e，\u652f\u6301\u5206\u533a \/ \u6392\u5e8f \/ \u7a7a\u503c\u63a7\u5236DATEADD\/PREVIOUSMONTH（\u65f6\u95f4\u7c7b）\u3001FILTERTOPN（\u901a\u7528）1. \u8131\u79bb\u65f6\u95f4\u7ef4\u5ea6\u9650\u5236，\u9002\u914d\u4efb\u610f\u7ef4\u5ea6\u504f\u79fb；2. \u539f\u751f\u652f\u6301\u5206\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.wsisp.com\/helps\/63302.html\" \/>\n<meta property=\"og:site_name\" content=\"\u7f51\u7855\u4e92\u8054\u5e2e\u52a9\u4e2d\u5fc3\" \/>\n<meta property=\"article:published_time\" content=\"2026-01-21T12:16:45+00:00\" \/>\n<meta name=\"author\" content=\"admin\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"\u4f5c\u8005\" \/>\n\t<meta name=\"twitter:data1\" content=\"admin\" \/>\n\t<meta name=\"twitter:label2\" content=\"\u9884\u8ba1\u9605\u8bfb\u65f6\u95f4\" \/>\n\t<meta name=\"twitter:data2\" content=\"6 \u5206\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\/\/www.wsisp.com\/helps\/63302.html\",\"url\":\"https:\/\/www.wsisp.com\/helps\/63302.html\",\"name\":\"Power BI 2022 + \u65b0\u589e\u7a97\u53e3\u51fd\u6570\u89e3\u6790 - \u7f51\u7855\u4e92\u8054\u5e2e\u52a9\u4e2d\u5fc3\",\"isPartOf\":{\"@id\":\"https:\/\/www.wsisp.com\/helps\/#website\"},\"datePublished\":\"2026-01-21T12:16:45+00:00\",\"dateModified\":\"2026-01-21T12:16:45+00:00\",\"author\":{\"@id\":\"https:\/\/www.wsisp.com\/helps\/#\/schema\/person\/358e386c577a3ab51c4493330a20ad41\"},\"breadcrumb\":{\"@id\":\"https:\/\/www.wsisp.com\/helps\/63302.html#breadcrumb\"},\"inLanguage\":\"zh-Hans\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/www.wsisp.com\/helps\/63302.html\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/www.wsisp.com\/helps\/63302.html#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"\u9996\u9875\",\"item\":\"https:\/\/www.wsisp.com\/helps\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Power BI 2022 + \u65b0\u589e\u7a97\u53e3\u51fd\u6570\u89e3\u6790\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/www.wsisp.com\/helps\/#website\",\"url\":\"https:\/\/www.wsisp.com\/helps\/\",\"name\":\"\u7f51\u7855\u4e92\u8054\u5e2e\u52a9\u4e2d\u5fc3\",\"description\":\"\u9999\u6e2f\u670d\u52a1\u5668_\u9999\u6e2f\u4e91\u670d\u52a1\u5668\u8d44\u8baf_\u670d\u52a1\u5668\u5e2e\u52a9\u6587\u6863_\u670d\u52a1\u5668\u6559\u7a0b\",\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/www.wsisp.com\/helps\/?s={search_term_string}\"},\"query-input\":\"required name=search_term_string\"}],\"inLanguage\":\"zh-Hans\"},{\"@type\":\"Person\",\"@id\":\"https:\/\/www.wsisp.com\/helps\/#\/schema\/person\/358e386c577a3ab51c4493330a20ad41\",\"name\":\"admin\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"zh-Hans\",\"@id\":\"https:\/\/www.wsisp.com\/helps\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/gravatar.wp-china-yes.net\/avatar\/?s=96&d=mystery\",\"contentUrl\":\"https:\/\/gravatar.wp-china-yes.net\/avatar\/?s=96&d=mystery\",\"caption\":\"admin\"},\"sameAs\":[\"http:\/\/wp.wsisp.com\"],\"url\":\"https:\/\/www.wsisp.com\/helps\/author\/admin\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Power BI 2022 + \u65b0\u589e\u7a97\u53e3\u51fd\u6570\u89e3\u6790 - \u7f51\u7855\u4e92\u8054\u5e2e\u52a9\u4e2d\u5fc3","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:\/\/www.wsisp.com\/helps\/63302.html","og_locale":"zh_CN","og_type":"article","og_title":"Power BI 2022 + \u65b0\u589e\u7a97\u53e3\u51fd\u6570\u89e3\u6790 - \u7f51\u7855\u4e92\u8054\u5e2e\u52a9\u4e2d\u5fc3","og_description":"\u4e00\u30012022 \u65b0\u589e\u7a97\u53e3\u51fd\u6570\u6838\u5fc3\u7279\u70b9\u4e0e\u4f18\u52bf（vs \u4f20\u7edf\u51fd\u6570）\u51fd\u6570\u6838\u5fc3\u7279\u70b9\u4f20\u7edf\u66ff\u4ee3\u51fd\u6570\u6838\u5fc3\u4f18\u52bf\u6027\u80fd \/ \u6613\u7528\u6027\u5bf9\u6bd4OFFSET\u52a8\u6001\u76f8\u5bf9\u504f\u79fb，\u57fa\u4e8e\u5f53\u524d\u884c\u53d6\u504f\u79fb N \u884c\u6570\u636e，\u652f\u6301\u5206\u533a \/ \u6392\u5e8f \/ \u7a7a\u503c\u63a7\u5236DATEADD\/PREVIOUSMONTH（\u65f6\u95f4\u7c7b）\u3001FILTERTOPN（\u901a\u7528）1. \u8131\u79bb\u65f6\u95f4\u7ef4\u5ea6\u9650\u5236，\u9002\u914d\u4efb\u610f\u7ef4\u5ea6\u504f\u79fb；2. \u539f\u751f\u652f\u6301\u5206","og_url":"https:\/\/www.wsisp.com\/helps\/63302.html","og_site_name":"\u7f51\u7855\u4e92\u8054\u5e2e\u52a9\u4e2d\u5fc3","article_published_time":"2026-01-21T12:16:45+00:00","author":"admin","twitter_card":"summary_large_image","twitter_misc":{"\u4f5c\u8005":"admin","\u9884\u8ba1\u9605\u8bfb\u65f6\u95f4":"6 \u5206"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/www.wsisp.com\/helps\/63302.html","url":"https:\/\/www.wsisp.com\/helps\/63302.html","name":"Power BI 2022 + \u65b0\u589e\u7a97\u53e3\u51fd\u6570\u89e3\u6790 - \u7f51\u7855\u4e92\u8054\u5e2e\u52a9\u4e2d\u5fc3","isPartOf":{"@id":"https:\/\/www.wsisp.com\/helps\/#website"},"datePublished":"2026-01-21T12:16:45+00:00","dateModified":"2026-01-21T12:16:45+00:00","author":{"@id":"https:\/\/www.wsisp.com\/helps\/#\/schema\/person\/358e386c577a3ab51c4493330a20ad41"},"breadcrumb":{"@id":"https:\/\/www.wsisp.com\/helps\/63302.html#breadcrumb"},"inLanguage":"zh-Hans","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.wsisp.com\/helps\/63302.html"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/www.wsisp.com\/helps\/63302.html#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"\u9996\u9875","item":"https:\/\/www.wsisp.com\/helps"},{"@type":"ListItem","position":2,"name":"Power BI 2022 + \u65b0\u589e\u7a97\u53e3\u51fd\u6570\u89e3\u6790"}]},{"@type":"WebSite","@id":"https:\/\/www.wsisp.com\/helps\/#website","url":"https:\/\/www.wsisp.com\/helps\/","name":"\u7f51\u7855\u4e92\u8054\u5e2e\u52a9\u4e2d\u5fc3","description":"\u9999\u6e2f\u670d\u52a1\u5668_\u9999\u6e2f\u4e91\u670d\u52a1\u5668\u8d44\u8baf_\u670d\u52a1\u5668\u5e2e\u52a9\u6587\u6863_\u670d\u52a1\u5668\u6559\u7a0b","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/www.wsisp.com\/helps\/?s={search_term_string}"},"query-input":"required name=search_term_string"}],"inLanguage":"zh-Hans"},{"@type":"Person","@id":"https:\/\/www.wsisp.com\/helps\/#\/schema\/person\/358e386c577a3ab51c4493330a20ad41","name":"admin","image":{"@type":"ImageObject","inLanguage":"zh-Hans","@id":"https:\/\/www.wsisp.com\/helps\/#\/schema\/person\/image\/","url":"https:\/\/gravatar.wp-china-yes.net\/avatar\/?s=96&d=mystery","contentUrl":"https:\/\/gravatar.wp-china-yes.net\/avatar\/?s=96&d=mystery","caption":"admin"},"sameAs":["http:\/\/wp.wsisp.com"],"url":"https:\/\/www.wsisp.com\/helps\/author\/admin"}]}},"_links":{"self":[{"href":"https:\/\/www.wsisp.com\/helps\/wp-json\/wp\/v2\/posts\/63302","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.wsisp.com\/helps\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.wsisp.com\/helps\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.wsisp.com\/helps\/wp-json\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/www.wsisp.com\/helps\/wp-json\/wp\/v2\/comments?post=63302"}],"version-history":[{"count":0,"href":"https:\/\/www.wsisp.com\/helps\/wp-json\/wp\/v2\/posts\/63302\/revisions"}],"wp:attachment":[{"href":"https:\/\/www.wsisp.com\/helps\/wp-json\/wp\/v2\/media?parent=63302"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.wsisp.com\/helps\/wp-json\/wp\/v2\/categories?post=63302"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.wsisp.com\/helps\/wp-json\/wp\/v2\/tags?post=63302"},{"taxonomy":"topic","embeddable":true,"href":"https:\/\/www.wsisp.com\/helps\/wp-json\/wp\/v2\/topic?post=63302"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}