Forum Discussion
IF function doesn't 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#M25505If 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 )
