Forum Discussion
Marcox28
3 years agoHelper II
Optimize formula Calculated column
Hi Guys, in one of my model I have this computed column. How can I optimize the code to improve performance? CalculateColumn = IF(SEARCH("[CT]",'FactTable'[Code],1,0 )>0,"GPS", IF(SEARCH("[CA]"...
Marcox28
3 years agoHelper II
Thanks a lot, but how can I use the switch function to replace nested IF?