Forum Discussion
IF - True statement text
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.
I've change both system and pbi settings to usa, but still got the same problem
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.
