Forum Discussion
Helper IIIIF - True statement text
Super UserI 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.
Helper IIII've change both system and pbi settings to usa, but still got the same problem
SeanCommunity Champion
Is there a line separator other than , or ;
- chrisgehm
Don't know why, but when I use this formula, it works a bit wired:
B = if(Movimientos[A]<500,1,0)
- parry2k
It means it has to do with string qualifier.
- chrisgehm
So how do I go on?
- chrisgehm
Seems this works, but can't undestand why:
B = if(Movimientos[A]<500,1,"Lower","Higher")
- parry2k
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?
- parry2k
wow that is strange.