Power Query Editor-->Add Column: we have 7 types

Hi Anonymous 

I would suggest you have a look at below articles to understand them.

1-Column From Examples

https://docs.microsoft.com/en-us/power-bi/desktop-add-column-from-example

2-Custom Column

https://docs.microsoft.com/en-us/power-bi/desktop-add-custom-column

3-Invoke Custom Function

https://blog.crossjoin.co.uk/2016/10/01/using-the-invoke-custom-function-button-in-power-bi/

4-Conditional Column
6-Index Column
7-Duplicate Column

https://www.tutorialgateway.org/add-conditional-column-in-power-bi/

https://www.c-sharpcorner.com/article/conditional-column-index-column-and-duplicate-column-in-power-bi/

For 3rd party Links:

Please understand that this link is provided “AS IS” with no warranties or guarantees of content changes, and confers no rights.

Regards