Forum Discussion

Katerina's avatar
Katerina
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...
Need Help
amitchandak's avatar
amitchandak
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's avatar
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's avatar
    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's avatar
      amitchandak
      Super User
      6 years ago

      Under file - >Option and Setting  -> Option -> Regional setting

      Check that. You can not have, at both place

      • Katerina's avatar
        Katerina
        Helper I
        6 years ago

        Application language and Model language - English (United States)

         

  • amitchandak's avatar
    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's avatar
      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.