Power BI / DAX中的COUNTIF等值？ [英] COUNTIF equivalent in Power BI / DAX?

问题描述

我有下表，并尝试从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屋！