raynok's avatar
raynok
Frequent Visitor
8 years ago
Status:
Accepted

Case expressions may only be nested to level 10.

Hi There and happy new year,   I've been running a report since 03-2017 with an "added conditional Column".It has 16 rows of conditions.   After applying the Dec 2017 update, I'm now receiv...
Reports
v-jiascu-msft's avatar
v-jiascu-msft
Icon for Microsoft Employee rankMicrosoft Employee
8 years ago

Hi raynok,

 

I'm going to report this issue. I will update later. The workaround of adding conditional column could be using DAX formula instead. (You can add more conditions)

Column =
SWITCH ( [id], 1, 10, 2, 20, 3, 30, 4, 40, 999 )

Case_expressions_may_only_be_nested_to_level_10

 

Best Regards,

Dale

Completed Ideas