Forum Discussion
IF - True statement text
Under regional settings --> Addtional Setting
Check what is the List Seperator defined. Use that one or change it to comma(,)
Folks he said he got the same error with , and with ;
I changed my regional setting as yours and tested the formula and it worked, not sure what else to tell. FarhanAhmed1984 mentioend something for you to take a look, can you check?
Also, can you change your regional settings for "English (USA)" and test it. It is only for testing purpose.
Don't have the Addtional Setting option
Control Panel --> Region ---> Additional Settings --> List Seperator
I've change both system and pbi settings to usa, but still got the same problem
Can you test by changing regional settings to English (USA).
Also, can you create a temporary table in PowerBI and test it. Just trying to rule out all the optionsl . All these seems hit and trial but very hard to find the reason since formula is correct.
Is there a line separator other than , or ;
Don't know why, but when I use this formula, it works a bit wired:
B = if(Movimientos[A]<500,1,0)
It means it has to do with string qualifier.
So how do I go on?
Seems this works, but can't undestand why:
B = if(Movimientos[A]<500,1,"Lower","Higher")
This is weird, can you put a sample data in a pbix file and send it by email, would like to look at my end. I know it seems weird but not sure what else to say?
wow that is strange.
