Forum Discussion

BekahLoSurdo's avatar
BekahLoSurdo
Resolver IV
7 years ago
Solved

CONCATENATEX with Multiple Columns

Hi everyone,   Is there a way to take advantage of CONCATENATEX's delimiter feature (specifically: add a comma when there's another item in the list, don't add a comma for the last or only item) ac...
Need Help
  • parry2k's avatar
    parry2k
    7 years ago

    BekahLoSurdo add condition in following

     

    MissingField(s) = 
VAR _F1 = 
    IF( 'Sample'[Field1] <> BLANK() || 'Sample'[Field1Valid] = "Y",
    BLANK(),
    "Field1" )
VAR _F2 =
    IF( 'Sample'[Field2] <> BLANK(),
    BLANK(),
    "Field2" )
RETURN
SWITCH( TRUE(),
__F1 == BLANK() && __F2 == BLANK(), "",
__F2 == BLANK(), __F1,
__F1 == BLANK(), __F2,
_F1 & ", " & _F2
)
parry2k's avatar
parry2k
Super User
7 years ago

BekahLoSurdo add condition in following

 

MissingField(s) = 
VAR _F1 = 
    IF( 'Sample'[Field1] <> BLANK() || 'Sample'[Field1Valid] = "Y",
    BLANK(),
    "Field1" )
VAR _F2 =
    IF( 'Sample'[Field2] <> BLANK(),
    BLANK(),
    "Field2" )
RETURN
SWITCH( TRUE(),
__F1 == BLANK() && __F2 == BLANK(), "",
__F2 == BLANK(), __F1,
__F1 == BLANK(), __F2,
_F1 & ", " & _F2
)