主页 / coding / 问题 / 78512197
Accepted
Seyma Kalay
Asked: 2024-05-21 21:24:33 +0800 CST

DAX 中带有 if 语句的计算列

  • 772

我想创建一个专栏，其中包括Current_Week, Previous_Week,and Non

get_CW = //works fine
IF(
    AND(
    WEEKNUM(TODAY()) = WEEKNUM('Calendar'[Date]),
    YEAR(TODAY()) = YEAR('Calendar'[Date])
   ),
  "CW",
   "Non"
)

我一直在计算下面的 PW

get_CW_and_PW = 

IF(    
    AND(
    WEEKNUM(TODAY()) = WEEKNUM('Calendar'[Date]),
    YEAR(TODAY()) = YEAR('Calendar'[Date])
   ),
   "CW",
 IF(    
  /// CW-7 days
   ),
   "PW",

   "Non"
)
powerbi

1 个回答

  1. Best Answer

    使用变量：

    get_CW =
VAR Current_Week = WEEKNUM ( TODAY () )
VAR Previous_Week = WEEKNUM ( TODAY () - 7 )
VAR Result =
    SWITCH (
        WEEKNUM ( 'Calendar'[Date] ),
        Current_Week, "CW",
        Previous_Week, "PW",
        "None"
    )
RETURN Result
    • 1

相关问题