Text.Upper Power Query Function
Text.Upper is a power query function that helps us to convert small letters to upper case. In this article, we tell you how to convert all the letters in a string to capital using Text.Upper function.
Syntax
Text.Upper(Given String)It takes one parameter as a string and returns it in upper case.
Text.upper Example
Let’s create a small table in Power BI using the “Enter data” tab in the Power BI ribbon. as you can see.
We want to convert all the names from small letters to capital letters by using the following formula.
Text.Upper([Name])
It will return the following result, as you can see below.
All the names are in upper case in the new column “Capital Name”.
To learn more, please visit Learn DAX
