Forum Discussion
Power Pivot issues
Hi the SWITCH function I tried on power pivot resulted in an error I can't understand how to solve (syntax for Q1 is incorrect), please have a look at the following screenshots and let me know how I...
Hello
That error usually pops up when there’s a small syntax issue in your formula. Most times, it’s caused by using curly quotes (like “Q1”) instead of straight quotes ("Q1").
Try retyping the formula directly in Power Pivot. Double check that each pair of quotes is straight, your commas and brackets are correct, and that you’re using the SWITCH function correctly. It often works better when used with TRUE() to compare values.
Let me know if the error still shows up, happy to help further.