Forum Discussion
IF - True statement text
Hi everyone! I'm just starting to work with Power BI. In the desktop version, I've create new column (Calculated) So what I need is to create a new column and put values acording to the first col...
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.
