Forum Discussion
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 let...
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
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
Dear Anonymous
I didnt think of that, thank you.
