Flash Fill for Power BI Desktop (Query Editor)
In the April update of Power BI Desktop there will be a feature called "Add Column from Examples" which the Office team found a more "flashy" name for in Excel: Flash Fill... But it's a very efficient new feature and a giant step towards real self-service ETL...nice job Miguel Llopis and his team! See video here