This time you would need to generate many columns from a single column sorted through Power Query. The problem has many alphabets in single column and you will need to generate columns of alphabets which are sorted.
Category: Power BI
Power Query Challenge 5 – Generate Multiplication Table
This is 5th in series of Power Query Challenges. Given the height and width, you need to generate the Multiplication Table. In the example. Height is 20 and width is 8, hence multiplication table columns should be from 1 to 8 and each should contain 20 rows.
Power Query Challenge 4 – Extract digits and sum them
This is another interesting Power Query Challenge. Extract the digits from the given string and sum the digits for that extract string in each row.
Power Query Article 1 – NetworkDays using List.Accumulate
This article on Power Query contains one line m-code for calculating NETWORKDAYS.INTL using List.Accumulate. Hence, you can control weekends as well as list of holidays.
Power Query Challenge 3 – Replacement of Words through Lookup Table
There is a table which has Original Text and there is another table which contains the list of words which need to be replaced. Original text should be replaced with words from lookup table.
Power Query Challenge 2 – Count the Frequency of Words
Here comes the challenge. The Subjects table has list of subjects. The words are separated by either comma or space and amount of space is also not uniform. The case of subjects is also not uniform. The count of rows for subjects is needed
Power Query Challenge 1 – Count Number of Words through UI
Here comes the Power Query challenge. The count of words in each row is needed. The challenge is that the solution has to be completely UI (user interface) driven. After loading the table in PQ, you should not press even a single key to come up with the result. You should use only mouse.
Split a Column Dynamically – Power Query – Tips & Tricks 6
Power Query Split a Column Dynamically is a very important tool for PQ practitioners. You can use this to split your column into variable number of columns. This removes limitation of splitting a column on the basis of first time split if result columns are more than first time split columns.
Test for a Number – Power Query – Tips & Tricks 5
Test for a Number is a very important topic in Power Query Suppose, you have a column of values and you need to test whether the value contained is a number or not.
Change Index at discontinuity – Power Query – Tips & Tricks 4
Power Query – Change Index at each discontinuity. Sometimes, you need to insert index but change is needed at when value in left column changes