DAX to Split Text using delimeter.

[yodha]

I need help to Split this text based on delimeter "Comma"

can anyone help me with "DAX"?

Thanks in Advance

[Mariusz]

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.

Best Regards,
Mariusz

If this post helps, then please consider Accepting it as the solution.

Please feel free to connect with me.
LinkedIn

[Mariusz]

Hi @yodha 

Can you not do it in Power Quer?

Best Regards,
Mariusz

If this post helps, then please consider Accepting it as the solution.

Please feel free to connect with me.
LinkedIn

[yodha]

@Mariusz : no, i need to use DAX, the above DAX is looking fine but it's just giving me error because few rows in my table doen't have "Type", thank you.

[amitchandak]

@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/

[az38]

Hi @yodha 

try

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

[yodha]

@az38 : Thank you so much for the response but this is giving me error because few rows doesn't contain "Type" in my Table, can you tell me how to modify this DAX ?  

[az38 · Accepted solution]

@yodha

try

Column =

var _start = SEARCH("""Type", [Column1],,0)

var _finish = SEARCH(",", [Column1], _start)

RETURN

IF(_start > 0, MID([Column1], _start, _finish - _start), BLANK() )