powerbi - 函数日期的参数数据类型错误或结果太小或太大错误

Question

得到错误

An Argument of Function Date has wrong data type or result is too small or too large

当以下度量包含在任何图表中时。但是，该值在 KPI 中正确显示。

LastYear =
VAR lastFromDate =
    DATE ( YEAR ( [From_Date] ) - 1, MONTH ( [From_Date] ), DAY ( [From_Date] ) )
VAR lastToDate =
    DATE ( YEAR ( [To_Date] ) - 1, MONTH ( [To_Date] ), DAY ( [To_Date] ) )
RETURN
    IF (
        [DateDiff] > 365,
        0,
        SUMX (
            FILTER (
                ALL ( WUSA_CAL_DIM ),
                WUSA_CAL_DIM[End_Date] >= lastFromDate
                    && WUSA_CAL_DIM[End_Date] <= lastToDate
            ),
            [Sales_Value]
        )
    )

我想根据切片器中的从和至今显示去年的销售额。删除 -1 可以解决问题，但在需要的情况下不会显示上一年的销售额。

Answer 1

我认为这与变量中 [From_Date] 和 [To_Date] 缺乏上下文有关。但是，由于缺乏上下文，无法访问您的源数据并且对您的数据模型一无所知，我在这里做出了巨大的假设。

PowerBI(或者更确切地说是 DAX)不知道您希望它使用哪一组日期。

尝试类似的事情:

LastYear =
VAR lastFromDate =
    SELECTEDVALUE(From_Tbl[From_Date], TODAY()) - 365
VAR lastToDate =
    SELECTEDVALUE(To_Tbl[To_Date], TODAY()) - 365
RETURN
    IF (
        [DateDiff] > 365,
        0,
        SUMX (
            FILTER (
                ALL ( WUSA_CAL_DIM ),
                WUSA_CAL_DIM[End_Date] >= lastFromDate
                    && WUSA_CAL_DIM[End_Date] <= lastToDate
            ),
            [Sales_Value]
        )
    )