Power BI has this awesome feature that allows you to perform data transformations without writing any M or DAX code! You can create a "Column from Examples" simply by typing the result that you want to see and Power BI will do the rest.
Enroll in my introductory or advanced Power BI courses:
https://training.bielite.com/
Elite Power BI Consulting:
https://bielite.com/
Data Insights Tools:
https://www.impktful.com/