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.
Community ChampionHmm, interesting... You know, I'd never thought about it quite like that before. This has changed my entire perspective on things. I appreciate you going into such a lengthy description and explanation of your experiences.
MJEnnisGreg_Deckler I will be sure to accept your reply as the solution once I figure this out.
- Greg_Deckler
Sorry, was being sarcastic because all I could see was the title of your post and nothing in the actual post itself. I'll read through it now that I see something! 🙂
- MJEnnis
Greg_DecklerYeah, it was my first post and I clicked "post" before I wrote it! Thanks for taking a look!
- Greg_Deckler
So 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".