Query Editor - Add Column Magic

[Phil_Seamark]

I hope this isn't an April Fool joke, but if this feature coming in the April release is half as good as it sounds, it will be fantastic!

“Add Column From Examples” allows users to define new columns of data within the Query Editor by providing one or more sample values for the new column. Based on those values, Power BI Desktop will automatically detect the most suitable data transformation to extract and combine data from other columns in the table in order to achieve the desired output specified by the user.

This new and innovative approach for defining new columns in the Query Editor makes it easier for users in a couple of ways:

1. In cases where users know the data result that they would like to get, but they don’t know what data transformation (or combination of them) should be applied.
2. When users know what data transformations need to be applied, but they don’t know where they can be found within the Query Editor UI.
3. Finally, this new feature also helps users in the case that they needed to specify the data transformations via a Custom Column expression in M, because one or more of those transformations are not exposed in the Query Editor UI.

[Eric_Zhang]

@Phil_Seamark

Thanks for sharing, the new feature would make it more easier to use Power Query.