DAX使用日期过滤器计算国家

Question

我有这个DAX公式工作得很好，我想添加一个日期过滤器来过滤在DB sales [date] 30/9/2022之前完成的销售，但它不喜欢日期过滤器。任何帮助和指导，感谢。

Sales Completed =
IF.EAGER (
    CALCULATE (
        COUNTROWS ( 'DB Sales' ),
        'DB Sales'[Status] = "Completed"
    ) + 0 = 0,
    BLANK (),
    CALCULATE (
        COUNTROWS ( 'DB Sales' ),
        'DB Sales'[Status] = "Completed"
    ) + 0
)

Answer 1

您需要将字符串转换为日期进行比较:

Sales Completed before Date = 
VAR _rows = 
    CALCULATE (
        COUNTROWS ( 'DB Sales' ),
        'DB Sales'[Status] = "Completed",
        'DB Sales'[Date] < DATEVALUE("30/9/2022")
    )
RETURN
    IF (_rows = 0, BLANK(), _rows)