Skip to main content
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 

Get Fabric Certified for FREE during Fabric Data Days. Don't miss your chance! Request now

ColinE711

SWITCH command failing

Submitted by on ‎12-28-2016 12:48 PM

The SWITCH command is failing when being used with more than 10 levels in DirectQuery.  I sent a frown and received a response, so I'm guessing it's in the ICM, but I'd like to know status since all queries I have using SWITCH commands fail given more than 10 options.

Status: New
See more ideas labeled with:
2 Comments (2 New)
Comments
v-qiuyu-msft
Community Support
Community Support
‎01-05-2017 10:10 PM

Hi @ColinE711,

 

Did you create a caluclated column or a measure in DirectQuery mode?

 

Best Regards,
Qiuyun Yu

ColinE711
New Member
‎01-06-2017 09:43 AM

It is a calculated column.  I have since tried to change to use more than 10 nested IF statements, and it fails with the same error.  It appears to be that the number of nested cases is capped at 10 for case expressions, which appears to be a limitation introduced by Power BI.  The MSDN example used in the SWITCH documentation shows 13 cases.

 

The error I receive is:

Case expressions may only be nested to level 10.

 

Idea Statuses