Forum Discussion
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...
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.