Forum Discussion
Resolver IIIProblem With Decimals in Calculated Column with If >=
Solved! (Though I may have created further headaches later on.)
So I think the problem was that the region settings on my previous laptop were different. I imported the data from an Oracle database on the previous machine. And I started cleaning and structuring the data and creating the report on that machine. That machine crashed, and I do not remember the region settings.
The new machine has been running with Windows set to English (US). I downloaded Power BI Desktop to my new machine and opened the pbix file wthout taking regions into consideration. Everything worked fine for several weeks until I included a decimal in a function.
To solve the problem, I have been messing around with various combinations of region settings across Windows and PowerBi.
This is the combination that finally worked:
1) Dates and numbers are formatted for Central Europe in the database.
2) The file is set to Italian (Italy) in PowerBI.
3) The global application language is set to Windows default..
4) The global model language is set to English (US).
5) Windows is set to Engish (US).
6) But I have customized the number format for Windows to match European format.
I do not know why, but setting the region for Windows to Italian (Italy) did not do the trick. I had to keep it set to English (US) and then customize the number format for Europe.
Oh, and here is the real kicker. After doing all of this, I have to type "0.745" in the function. But thee column results for decimals appear with the European commas. And in my visuals, it is back to US formatting.
I am satisfied with this result. But I am very scared to open some of my Excel files and find out how they are responding to the new number format. Perhaps I will have to keep switching it depending on which application/files I open.
Resolver IIIGreg_Deckler I will be sure to accept your reply as the solution once I figure this out.
Community ChampionSo what happens if you use this:
Column = IF('Table'[Column] >= 0.745; "Yes"; BLANK())
?
Also, are you positive that this is a numeric column (right justified and italic) Probably if 1 works. Going to be a difficult one for me to recreate with the different regional settings going on.
- MJEnnis
I've tried ">=0.745" and it simply replaces the period with comma once I hit enter. And the data type is definitely set as decimal number. Perhaps I should also mention that it is a calculated table with 9 other columns, all calculated off data in this table or others in the model. But all other formulas work properly (some producing decimals). This is the only one that has a decimal in the function, though.
The sourcel column is also a calculated column, with decimals, obviously. But it works when I use ">=1".
- Greg_Deckler
It's very strange. I would report this to Microsoft and have then take a look at it. There is an issues forum here:
https://aka.ms/PBI_Comm_Issues
And if it is not there, then you could post it.
If you have Pro account you could try to open a support ticket. If you have a Pro account it is free. Go to https://support.powerbi.com. Scroll down and click "CREATE SUPPORT TICKET".Again, I'd like to help more but the regional settings stuff is just too difficult to troubleshoot. Seems like there is something definitely confusing Power BI though, some combination of OS regional settings, Power BI regional settings, etc. What are the regional settings for you OS and for Power BI?
- MJEnnis
Thanks a lot! I will wait and see if anyone else replies here and then try the Issues page and/or sending a ticket.