Use Case - Sometimes there will be a need to extract domain names from given URLs. Hence http://www.microsoft.com should give microsoft. Below are some sample cases and the results expected.

How to perform a ‘split and merge’ on columns to change (a) into (b)?

Budget allocation with seasonality In Power BI is made easy with Power Query.

Use Case - There are scenarios where you will be required to find the first/last non null value in a row. For example, to answer the questions:

1. What was the first sales amount done by a sales person? - This means that you will have to find first non-null from 2017 to 2022. For example, for Greg this is 688.

2. What was the last sales amount done by a sales person - This means that you will have to find last non-null from 2017 to 2022. Hence for Laura, this is 753.

Of course, if more years are added in the beginning or end, the formula should support the flexibility of Power Query i.e. if more columns are added, the result should include those columns as well.

Use case - Somebody asked me if the cell is not showing complete content then how he can see the complete content of a cell and copy the cell content from there.  You know something is there as at the end as ... (3 dots) will be there when you see the cell content.

I believe this problem many may be facing, hence it is worthwhile to share the tip here.

Basically, I had advised the person how to see SQL statement when Query folding is happening. And he wanted to copy the SQL statement but display was not showing complete SQL statement.

Use Case - Excel doesn't provide LTRIM and RTRIM but Power Query M Language does provide Text.TrimStart and Text.TrimEnd. Here, Power Query M Language scores over Excel. Both Excel and Power Query M Language provide Trim functions. Excel's Trim is documented here (TRIM) and M language's Trim is documented here (Text.Trim).