We require different types of cases in different types of reports.
For examples , We would like to have the column headers as ALL CAPITAL or only the first letter as Capital.
In any normal text, we would like to have the first letter as capital.
We may require the proper case. [ First letter of every word in upper case ]
POWER QUERY provides the direct functions to be used to change the case of the text.
THE FOLLOWING PICTURE SHOWS THE OPTIONS AVAILABLE FOR CHANGING THE TEXT CASE
- UPPER CASE – THIS IS THE EXAMPLE OF UPPER CASE.
- LOWER CASE – this is the example of lower case.
- PROPER CASE [ EVERY WORD HAS CAPITAL FIRST LETTER ] – This Is The Example Of Proper Case