topic Re: DAX formula SWITCH in DAX Commands and Tips

DAX formula SWITCH

davidacosta — Thu, 10 Oct 2024 19:10:47 GMT

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 selects a specific sumx

SWITCH(TRUE(),

[Selected Date] = 2025, sumx(FACT_Financial_Sales,FACT_Financial_Sales[Bx Expected QTY FY25]),

[Selected Date] = 2026, sumx(FACT_Financial_Sales,FACT_Financial_Sales[Bx Expected QTY FY26]),

[Selected Date] = 2027, sumx(FACT_Financial_Sales,FACT_Financial_Sales[Bx Expected QTY FY27]),

sumx(FACT_Financial_Sales,FACT_Financial_Sales[Bx Expected QTY FY28]),

)

much appreciated if you guide me.

David

Re: DAX formula SWITCH

ValtteriN — Thu, 10 Oct 2024 19:14:20 GMT

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,

)

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/

Re: DAX formula SWITCH

davidacosta — Thu, 10 Oct 2024 19:26:19 GMT

Thank you very much ValtteriN, after being blinded for 4 hours you helped me in less than 5 minutes, thanks again.