Forum Discussion

chrisgehm's avatar
chrisgehm
Icon for Helper III rankHelper 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...
parry2k's avatar
parry2k
Icon for Super User rankSuper 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
Icon for Helper III rankHelper III
9 years ago

Yep, numeric

  • parry2k's avatar
    parry2k
    Icon for Super User rankSuper 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 

    • chrisgehm's avatar
      chrisgehm
      Icon for Helper III rankHelper III
      9 years ago

      Windows uses spanish

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

      • parry2k's avatar
        parry2k
        Icon for Super User rankSuper User
        9 years ago

        Can you check regional settings in PowerBI,

         

        -go to menu

        -options and settings

        -options

        -regional settings

         

  • FarhanAhmed1984's avatar
    FarhanAhmed1984
    Icon for Resolver III rankResolver III
    9 years ago

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

    • chrisgehm's avatar
      chrisgehm
      Icon for Helper III rankHelper III
      9 years ago

      Spanish