IF - True statement text

[chrisgehm]

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 column.

ie:

Column A has numeric values, from 0 to 1000.

So I need to put in column B:

If Column A is lower than 500, put "Lower than 500", else "Higher than 500"

What I use is:

B = IF(Table[A]<500,"Lower than 500","Higher than 500")

But it doesn't work.

Any idea why?

[v-shex-msft]

Hi @chrisgehm

Did you use the direct query mode to connect the datasource? If Dax formula still has the issue, I'd like to suggest you use power query formula.

#"Added Custom" = Table.AddColumn(#"Changed Type", "Custom", each if [Column] >5 then "Greate than 5" else "Less than 5")

Regards,

Xiaoxin Sheng

[Sean]

@chrisgehm

Are you getting an error message? Can you elaborate a little more.

Because there's nothing wrong with the formula as you've described it.

[chrisgehm]

[Sean]

@chrisgehm

I'm guessing your regional setting may require ; instead of ,

try this instead

B = IF ( Table[A] < 500; "Lower than 500"; "Higher than 500" )

Hope this helps!

[chrisgehm]

Still having the same problem

[parry2k]

What is the data type for  your column 'A', is it number? Can you check in your data mode? Just make sure it is not treated as Text

[chrisgehm]

Yep, numeric

[FarhanAhmed1984]

What is the language setting that you are using in Windows ?

[chrisgehm]

Spanish

[parry2k]

Seems like it is related to your regional settings, can you check what regional setting you have ? Not sure double quotes need to be change to single quote 

[chrisgehm]

Windows uses spanish

I've tried with single quotes, but also didn't work

[parry2k]

Can you check regional settings in PowerBI,

-go to menu

-options and settings

-options

-regional settings

[FarhanAhmed1984]

Under regional settings --> Addtional Setting

Check what is the List Seperator defined. Use that one or change it to comma(,)

[Sean]

Folks he said he got the same error with , and with ;

[parry2k]

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.

[chrisgehm]

I've change both system and pbi settings to usa, but still got the same problem

[Sean]

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]

Seems this works, but can't undestand why:

B = if(Movimientos[A]<500,1,"Lower","Higher")