DAX to Split Text using delimeter.

Hi yodha 

try

Column = 
var _start = SEARCH("""Type", [Column1])
var _finish = SEARCH(",", [Column1], _start)
RETURN
MID([Column1], _start, _finish - _start)

yodha , seem like a json data check

https://www.youtube.com/watch?v=ipI6mrWLQKA

https://www.mssqltips.com/sqlservertip/4621/using-power-bi-with-json-data-sources-and-files/

Hi yodha 

Can you not do it in Power Quer?

Hi yodha 

With Power Query is as simple as selecting your string column, follow the below.

and expand Type,

Please see the attached for ref.