Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Enhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.

Reply
Anonymous
Not applicable

Why my DAX is with ; instead of ,?

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 

Marina_MA_0-1664541131729.png

Many thanks in advance!!

Marina 

 

1 ACCEPTED SOLUTION
v-chenwuz-msft
Community Support
Community Support

Hi @Anonymous ,

 

Please select recommended DAX separators.

vchenwuzmsft_0-1664780861729.png

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.

View solution in original post

3 REPLIES 3
v-chenwuz-msft
Community Support
Community Support

Hi @Anonymous ,

 

Please select recommended DAX separators.

vchenwuzmsft_0-1664780861729.png

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
Not applicable

Many thanks! I think It is working properly now.

 

Kindest regards,

Marina

amitchandak
Super User
Super User

@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

Share with Power BI Enthusiasts: Full Power BI Video (20 Hours) YouTube
Microsoft Fabric Series 60+ Videos YouTube
Microsoft Fabric Hindi End to End YouTube

Helpful resources

Announcements
July 2025 community update carousel

Fabric Community Update - July 2025

Find out what's new and trending in the Fabric community.

July PBI25 Carousel

Power BI Monthly Update - July 2025

Check out the July 2025 Power BI update to learn about new features.