Power BI/DAX 中的 COUNTIF 等效项? [英] COUNTIF equivalent in Power BI / DAX?
本文介绍了Power BI/DAX 中的 COUNTIF 等效项?的处理方法,对大家解决问题具有一定的参考价值,需要的朋友们下面随着小编来一起学习吧!
问题描述
我有下表并试图从 excel 转移到 Power Bi.在excel中,我使用 =COUNTIFS($A$2:$A$16,"<="&E2,$B$2:$B$16,">="&E2)
来获取计数值,但我想知道如何在 Power BI 中计算它
I have the below table and trying to move from excel to Power Bi. In excel I use =COUNTIFS($A$2:$A$16,"<="&E2,$B$2:$B$16,">="&E2)
to get Count value but I wonder how can I calculate it in Power BI
open_date close_date Date Count
16-Sep-18 14-Jan-19 16-Sep-18 1
21-Sep-18 19-Jan-19 17-Sep-18 1
23-Sep-18 21-Jan-19 18-Sep-18 1
17-Jan-19 27-Jan-19 19-Sep-18 1
26-Jan-19 28-Jan-19 20-Sep-18 1
27-Jan-19 28-Jan-19 21-Sep-18 2
19-Jan-19 19-Jan-19 22-Sep-18 2
19-Jan-19 29-Jan-19 23-Sep-18 3
27-Jan-19 29-Jan-19 24-Sep-18 3
20-Jan-19 30-Jan-19 25-Sep-18 3
23-Jan-19 30-Jan-19 26-Sep-18 3
26-Jan-19 30-Jan-19 27-Sep-18 3
28-Jan-19 30-Jan-19 28-Sep-18 3
21-Jan-19 31-Jan-19 29-Sep-18 3
25-Jan-19 31-Jan-19 30-Sep-18 3
推荐答案
有多种方法可以做到这一点,但它们都会使用某种过滤.
There are multiple ways to do this, but they'll all use some sort of filtering.
这里有几个例子:
CountIf =
COUNTROWS (
FILTER (
ALL ( Table1 ),
Table1[open_date] <= MAX ( Table1[Date] ) &&
Table1[close_date] >= MAX ( Table1[Date] )
)
)
和
CountIf =
VAR CurrentDate =
MAX ( Table1[Date] )
RETURN
CALCULATE (
COUNT ( Table1[Date] ),
ALL ( Table1 ),
Table1[open_date] <= CurrentDate,
Table1[close_date] >= CurrentDate
)
这篇关于Power BI/DAX 中的 COUNTIF 等效项?的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!
查看全文