Forum Discussion
Solved
DAX formula SWITCH
Hello, I'm making this calculation buy seems not working. "Argument 9 in SWITCH function is required" Basically what I'm doing is that, based on the selection of a specific year, the formula selec...
Hi David,
It seems you have a rogue comma in your dax. If you replace the sumxs with placeholders values you can see the following:a = SWITCH(TRUE(),1 = 2025, 1,2 = 2026, 2,3 = 2027, 3,4,)
The comma after 4 is the issue.
So here remove the comma:
sumx(FACT_Financial_Sales,FACT_Financial_Sales[Bx Expected QTY FY28]),
I hope this post helps to solve your issue and if it does consider accepting it as a solution and giving the post a thumbs up!
My LinkedIn: https://www.linkedin.com/in/n%C3%A4ttiahov-00001/
Thank you very much ValtteriN, after being blinded for 4 hours you helped me in less than 5 minutes, thanks again.