topic Re: Why my DAX is with ; instead of ,? in DAX Commands and Tips

Why my DAX is with ; instead of ,?

Anonymous — Fri, 30 Sep 2022 12:33:22 GMT

Hi all,

I have installed the Power Bi Desktop form the Microsoft Store, however when I try to create a DAX script I have to put ; intead of , Therefore, when I look for a solution in the internet, I never know how to write it, since all the solutions are with ,

For instance, this sentence with SWITCH is wrongin DAX, but I don't know why, Can somebody help me, please?

CascadaRevenue =

VAR SelectBudget =SELECTEDVALUE (Cascada[Categoria])

VAR SelectACTUAL = SELECTEDVALUE(Escalera[Subsidiaria])

Return

SWITCH (SelectBudget;

"Budget";

SWITCH (SelectACTUAL;

"02. GROUP";-1*[VentasTotales];

[BUDVentasTotales]

);

"Actual";

SWITCH (SelectACTUAL;

"02. GROUP";0;

[VentasTotales]

))

This is the tip in Power BI

Many thanks in advance!!

Marina

Re: Why my DAX is with ; instead of ,?

amitchandak — Fri, 30 Sep 2022 12:36:02 GMT

Anonymous , I think that based on the regional setting

check - https://www.officetooltips.com/office_2016/tips/change_the_semicolon_to_a_comma_or_vice_versa.html

Re: Why my DAX is with ; instead of ,?

v-chenwuz-msft — Mon, 03 Oct 2022 07:08:38 GMT

Hi Anonymous ,

Please select recommended DAX separators.

Best Regards

Community Support Team _ chenwu zhu

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Re: Why my DAX is with ; instead of ,?

Anonymous — Tue, 04 Oct 2022 08:07:35 GMT

Many thanks! I think It is working properly now.

Kindest regards,

Marina