Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Reply
Anonymous
Not applicable

SWITCH slower than before October 2021 update

Hi,

 

Anyone else experiencing performance issues with the SWITCH function since the October 2021 update?

 

It was mentioned that the performance of SWITCH was improved, especially if the function has a large number of values, but I am seeing the opposite.

 

I have a SWITCH / TRUE measure with around 500 lines and the performance is terrible.

It takes around 5-10 seconds just to add another line. Before it was instant.

 

It simply renames some names, example of a couple of lines:

 

New Name =
SWITCH ( TRUE(),
'Receipt Status'[Name Old] = "ABB Electrification Canada SRI", "ABB",
'Receipt Status'[Name Old] = "ABB Power Electronics Inc.", "ABB",
'Receipt Status'[Name Old] = "Acal BFI", "Acal BFI",
'Receipt Status'[Name Old] = "ACAL BFI UK (GBP)", "Acal BFI",
'Receipt Status'[Name Old] = "ACAL BFI UK (USD)", "Acal BFI",
 
Thanks!

 

1 ACCEPTED SOLUTION
amitchandak
Super User
Super User

@Anonymous ,  Please check if someone reported a similar issue https://community.powerbi.com/t5/Issues/idb-p/Issues

 

Try this one like 

New Name =
SWITCH ( 'Receipt Status'[Name Old] ,
 "ABB Electrification Canada SRI", "ABB",
 "ABB Power Electronics Inc.", "ABB",
 "Acal BFI", "Acal BFI",
 "ACAL BFI UK (GBP)", "Acal BFI",
 "ACAL BFI UK (USD)", "Acal BFI",

//Others

)

View solution in original post

2 REPLIES 2
amitchandak
Super User
Super User

@Anonymous ,  Please check if someone reported a similar issue https://community.powerbi.com/t5/Issues/idb-p/Issues

 

Try this one like 

New Name =
SWITCH ( 'Receipt Status'[Name Old] ,
 "ABB Electrification Canada SRI", "ABB",
 "ABB Power Electronics Inc.", "ABB",
 "Acal BFI", "Acal BFI",
 "ACAL BFI UK (GBP)", "Acal BFI",
 "ACAL BFI UK (USD)", "Acal BFI",

//Others

)

Anonymous
Not applicable

Thanks, that works better!

Helpful resources

Announcements
PBI_Carousel_NL_June

Fabric Community Update - June 2024

Get the latest Fabric updates from Build 2024, key Skills Challenge voucher deadlines, top blogs, forum posts, and product ideas.

Top Solution Authors