Column written in CAPS-lock

[asamr]

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?

[Anonymous · Accepted solution]

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]

Dear @Anonymous 

I didnt think of that, thank you.