Forum Discussion

asamr's avatar
asamr
Helper I
4 years ago
Solved

Column written in CAPS-lock

Dear PBI Community

 

I want to make a new Column.

 

If Company Name is written with FULL CAPS LOCK then then write the company name in a new column.

 

Company Name can contains numbers, all letters needs to be caps lock.

 

How can I achieve this?

 

Need Help
  • Anonymous's avatar
    Anonymous
    4 years ago

    Click the "Add Column" button, name the new column whatever, and in the box, type:

     

    if [Company Name] = Text.Upper([Company Name]) then [Company Name] else null

     

    --Nate

2 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable
    4 years ago

    Click the "Add Column" button, name the new column whatever, and in the box, type:

     

    if [Company Name] = Text.Upper([Company Name]) then [Company Name] else null

     

    --Nate

    • asamr's avatar
      asamr
      Helper I
      4 years ago

      Dear Anonymous 

      I didnt think of that, thank you.