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
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 😞
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.