Forum Discussion

chrisgehm's avatar
chrisgehm
Helper III
9 years ago

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...
Sean's avatar
Sean
Community Champion
9 years ago

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! :smileyhappy:

chrisgehm's avatar
chrisgehm
Helper III
9 years ago

Still having the same problem

  • parry2k's avatar
    parry2k
    Super User
    9 years ago

    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's avatar
      chrisgehm
      Helper III
      9 years ago

      Yep, numeric

      • parry2k's avatar
        parry2k
        Super User
        9 years ago

        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