This was also included in the query editor of Microsoft's Power BI in the release a month or two ago. First you select the columns to be used as a source then s

This was also included in the query editor of Microsoft's Power BI in the release a month or two ago. First you select the columns to be used as a source then start writing example values to the new column to be generated. It also shows the generated M/PowerQuery expression. It can't do miracles, but this is time saving in many cases like when you want to concatenate values from different columns in a new format into a single column and so on.