Forum Discussion

Helper I

6 years ago

IF function doesn't work

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( 'tab...

Super User

6 years ago

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" )

Katerina
Helper I
6 years ago
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:
Calendar= CALENDAR(DATE(2012 ,1 ,1),DATE(2019 ,12 ,31))
Without extra spaces this formula didn't work.

But I can't resolve the issue with IF formule 😞
- Katerina
  Helper I
  6 years ago
  very strange, but this formula is work:
  11 =
  var q = VALUE("0,7")
  RETURN
  IF('Продукты'[Заполненность склада]>q ,"1" ,"2")
  
  But it is not a good idea to add Value function allways when I need to work with Decimal 😞
  - amitchandak
    Super User
    6 years ago
    Under file - >Option and Setting -> Option -> Regional setting
    
    Check that. You can not have, at both place
- amitchandak
  Super User
  6 years ago
  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" )
  - Katerina
    Helper I
    6 years ago
    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.

Related content