You must have heard about the word POWER QUERY if you are acquainted with EXCEL or POWER BI.
POWER QUERY IS A DATA SHAPING TOOL WHERE WE CAN BRING THE DATA THROUGH A CONNECTION FROM VARIOUS SOURCES, DO SOME SHAPING SUCH AS REMOVING ROWS, COLUMNS, CHANGING DATA TYPES, TRIMMING THE DATA ETC. AND GET IT FINALLY FOR THE ANALYSIS IN OUR MAIN SOFTWARE SUCH AS MICROSOFT EXCEL OR MICROSOFT POWER BI .
Power Query tool, in fact, has immense powers to shape up the data in the way we want.
We’ll cover a lot of practical problems to sort them with the help of the POWER QUERY.
IN THIS ARTICLE, WE ‘LL LEARN TO CHANGE THE CASE IN POWER QUERY
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
Let us try to find out the steps to the problem of converting any case [ lower or mixed] to upper case using power query.
Let us try to find out the steps to the problem of converting any case [ upper or mixed] to lower case using power query.
Let us try to find out the steps to the problem of converting any case [ upper or lower or mixed] to PROPER case using power query.
Proper Case Is The Way Of Writing The Text When The First Letter Of Every Word Is Capital. [ Just Like This Sentence.
STEPS TO CONVERT LOWER OR MIXED CASE TO UPPER CASE IN POWER QUERY
OTHER WAYS TO REACH THIS ARTICLE
YOU MAY LIKE