Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Solved! Go to Solution.
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()
Why a SWITCH if you only have one condition?
IF(ISBLANK(EmpLid), BLANK(), COMBINEVALUES("-",'Table'[EmplId],'Table'[CaseNumber]))
I 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
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()
Thank you!
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
105 | |
94 | |
75 | |
63 | |
62 |
User | Count |
---|---|
137 | |
105 | |
104 | |
80 | |
63 |