Forum Discussion
StoryofData
Helper III
Helper IIISWITCH FUNCTION
I am trying to use SWITCH, it seems to be working but when the column is not summarized but when I do a count then it counts BLANKS, what am I doing wrong? Column 2 = SWITCH( TRUE (), 'Table...
I think the issue is after the last condition then. Switch has a default if no conditions are true, e.g.
SWITCH(TRUE() ,Test, Result ,Test, Result ,Default)Change your code to the following:
SWITCH ( TRUE (), 'Table'[EmplId] = BLANK (), BLANK (), 'Table'[IssueSub Formatted] = BLANK (), BLANK (), 'Table'[City] = "Not Applicable", BLANK (), 'Table'[City] = "Not Disclosed", BLANK (), 'Table'[IssueSub Formatted] = "Referral/Redirect", BLANK (), 'Table'[Title Categorized] = "Former Employee", BLANK (), 'Table'[EmplId] <> BLANK () ,COMBINEVALUES (" - ", [CaseNumber], [EmplId]))Let me know if that fixed it. I removed the =TRUE()
BrianConnelly
Resolver III
Resolver IIIWhy a SWITCH if you only have one condition?
IF(ISBLANK(EmpLid), BLANK(), COMBINEVALUES("-",'Table'[EmplId],'Table'[CaseNumber]))
StoryofDataHelper III
Helper IIII have at least 5 other conditions, I just shortened it for the sake of the question, thought I'd be able to apply the solution across the entire syntax
SWITCH (
TRUE (),
'Table'[EmplId] = BLANK (), BLANK (),
'Table'[IssueSub Formatted] = BLANK (), BLANK (),
'Table'[City] = "Not Applicable", BLANK (),
'Table'[City] = "Not Disclosed", BLANK (),
'Table'[City] = "Not Disclosed", BLANK (),
'Table'[IssueSub Formatted] = "Referral/Redirect", BLANK (),
'Table'[Title Categorized] = "Former Employee", BLANK (),
'Table'[EmplId] <> BLANK ()
= TRUE (),
COMBINEVALUES (" - ", [CaseNumber], [EmplId]))
If any of these columns have values I do not want - blanks, not applicable then I want the column value for that row to be empty
If any of these columns have values I do not want - blanks, not applicable then I want the column value for that row to be empty
- BrianConnelly
I think the issue is after the last condition then. Switch has a default if no conditions are true, e.g.
SWITCH(TRUE() ,Test, Result ,Test, Result ,Default)Change your code to the following:
SWITCH ( TRUE (), 'Table'[EmplId] = BLANK (), BLANK (), 'Table'[IssueSub Formatted] = BLANK (), BLANK (), 'Table'[City] = "Not Applicable", BLANK (), 'Table'[City] = "Not Disclosed", BLANK (), 'Table'[IssueSub Formatted] = "Referral/Redirect", BLANK (), 'Table'[Title Categorized] = "Former Employee", BLANK (), 'Table'[EmplId] <> BLANK () ,COMBINEVALUES (" - ", [CaseNumber], [EmplId]))Let me know if that fixed it. I removed the =TRUE()
- StoryofData
Thank you!