powerbi - 如何将 If ISBLANK 和 Concatenate 添加到 PowerBI 中的函数

Question

我在下面有这段代码可以正常工作。如果没有数据，如何在任何 SELECTEDVALUE 上插入“无可用信息”？目前它显示了这一点：

我想添加一个连接员工名字和姓氏，然后是回车，然后是 SELECTEDVALUE。函数也可以对列进行连接吗？

EmployeeData = 
VAR SelectedEmpl_ID =
    SELECTEDVALUE (EMPLOYEE_TRANSCRIPT[EMPL_ID])
VAR SelectedCrseCode =
    SELECTEDVALUE (EMPLOYEE_TRANSCRIPT[CRSE_CDE])
VAR SelectedJJNbr =
    SELECTEDVALUE ( EMPLOYEE_TRANSCRIPT[EMPL_JJ_NBR] )
VAR Label =
    "Employee ID " & SelectedEmpl_ID
        & UNICHAR ( 10 ) & " Course Code: " & SelectedCrseCode
        & UNICHAR ( 10 ) & " Employee: " & SelectedJJNbr
RETURN
    Label

标签： powerbi

Answer 1

这是插入“无可用信息”的一种方法

EmployeeData =
VAR SelectedEmpl_ID  = SELECTEDVALUE ( EMPLOYEE_TRANSCRIPT[EMPL_ID] )
VAR SelectedCrseCode = SELECTEDVALUE ( EMPLOYEE_TRANSCRIPT[CRSE_CDE] )
VAR SelectedJJNbr    = SELECTEDVALUE ( EMPLOYEE_TRANSCRIPT[EMPL_JJ_NBR] )
VAR Label =
    "Employee ID "
        & IF ( ISBLANK ( SelectedEmpl_ID ), "No info available", SelectedEmpl_ID )
        & UNICHAR ( 10 ) & " Course Code: "
        & IF ( ISBLANK ( SelectedCrseCode ), "No info available", SelectedCrseCode )
        & UNICHAR ( 10 ) & " Employee: "
        & IF ( ISBLANK ( SelectedJJNbr ), "No info available", SelectedJJNbr )
RETURN
    Label