Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
Hi all!
I meet a strange error in my PBI file. This file was created last year and all worked perfect. Today I opened it and see the error in following function:
11 = var q = 0,7 RETURN IF( 'table'[Column] > q, "1", "2" )
The error is: "The following system error occurred:". Without any details.
I'm using the latest version of Power BI Desktop. Regional settings - English. Windows language - Engling.
Can anybody help me please?
Thanks in advance!
Seems like . or , or ; issue
Try like
11 = var q = 0.7
RETURN IF( 'table'[Column] > q, "1", "2" )
OR
11 = var q = 0,7
RETURN IF( 'table'[Column] > q; "1"; "2" )
@amitchandak Hi!
I've tried this, but it didn't help 😞
I had simmilar error in my Calendar function and resolve this issue by adding spaces before coma in the formula:
This was
11 = var q = 0,7
RETURN IF( 'table'[Column] > q, "1", "2" )
have tried like
11 = var q = 0.7
RETURN IF( 'table'[Column] > q, "1", "2" )
My Power BI Desktop does'n accept 0.7
If I put with dot - PBI change it to comma. If I again put dot - PBI mark it with red.
I use comma in PBI. For an example in the Column with decimal I see 6,0 etc.
very strange, but this formula is work:
Under file - >Option and Setting -> Option -> Regional setting
Check that. You can not have, at both place
Application language and Model language - English (United States)
I think @amitchandak is right, it's because of regional settings. My guess is that you don't have standard list and decimal separator, and they are both set to "," (I strongly recommend changing it, especially if you work with csv files), similar to the post here:
https://community.powerbi.com/t5/Power-Query/IF-with-text-and-numbers/m-p/763520/highlight/true#M255...
If that's the case this code may work (added space after q)
11 =
var q = 0,7
RETURN IF( 'table'[Column] > q , "1", "2" )
as well as this one if you need numbers and not text - with the same decimal and list separator this is actually valid DAX, but you can see it's very confusing (1,0 is actually considered 1 in this case)
11 =
var q = 0,7
RETURN IF( 'table'[Column] > q , 1,0 , 2,0 )
Ahh! Yes. I Found. In my Windows settings the decimal and list separators was "," - for both.
I changed decimal separator to "." and now all is work!
Thank you very much!
Glad to hear it worked - can you please mark the topic as solved?
User | Count |
---|---|
103 | |
87 | |
77 | |
70 | |
69 |
User | Count |
---|---|
113 | |
99 | |
97 | |
72 | |
68 |