Why my DAX is with ; instead of ,?

[Anonymous]

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 

[v-chenwuz-msft · Accepted solution]

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.

[Anonymous]

Many thanks! I think It is working properly now.

Kindest regards,

Marina

[amitchandak]

@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