In this short video, I have explained how to use Add column by example inside Power Query, to add some column without using other UI tools for data transformation or using split, also this is good when you want to transform data but not sure which UI features you need to use.