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
leisay
Frequent Visitor

Syntax for 'ROUNDDOWN' is incorrect when putting it into if function

I am trying to add a calculated column using the if function combined with rounddown function inside. I tested the runddown function, it was working. But when I put it into the if function and calculating with the result from the rounddown founction I get the error - The syntax for 'ROUNDDOWN' is incorrect. I don't know why this is incorrect. Any hint for me? Annotation 2020-06-07 142957.jpg

 

 

 

 

Thank you!

1 ACCEPTED SOLUTION

Thank you both for the help. Now I found where the problem is. It is because of the reginal setting on my computer. Now I changed it to english (united states). Now the syntax error is not showing anymore. 😀

View solution in original post

4 REPLIES 4
harshnathani
Community Champion
Community Champion

Hi @leisay ,

 

Use the formula

 

ttire per pal =
IF (
Masterdata[Tireoo_mm] > 750,
DIVIDE (
1250,
ROUNDDOWN (
Masterdata[DeflatedTire Width(494)],
0
)
) * 2,
DIVIDE (
1250,
ROUNDDOWN (
Masterdata[DeflatedTire Width(494)],
0
)
) * 4
)

 

 

Regards,

Harsh Nathani

Dear @harshnathani ,

 

Thanks for the quick reply. Actually I want to round down the results of 1250 divided by MasterData[Deflated Tire Width], then multiply it by 2 or 4, depending on the result from the if condition. 

I tested in steps:

 

First I only use ROUNDDOWN(1250/MasterData[Deflated Tire Width(494)],0), it works out fine. 

Then I added the if function, then it is shows the syntax incorrect error. 

 

I just start to use powerBI. This formel seems quite simple and works in excel. But in PowerBI I keep getting this syntax error. This is a bit frastrating. 

Try saving, closing and then re-opening the file, I recreated the same formula in my file and it showed no errors.

Thank you both for the help. Now I found where the problem is. It is because of the reginal setting on my computer. Now I changed it to english (united states). Now the syntax error is not showing anymore. 😀

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.