Split a string into a list in DAX

Question

Hello,&nbsp;I am trying to split a string to create a list so I can flag all items that are part of my string and are found in the data table. Unfortunately I cannot do this in Power Query, so I'm trying to do this in a DAX measure.&nbsp;&nbsp;As as example, my string [List to Check] = "Strawberry, Grapes".&nbsp;&nbsp;I tried the following measure to split it into a list:&nbsp;Measure =VAR mymeasure =&nbsp; &nbsp; SUBSTITUTE ( [List to Check], ",", "|" )VAR Mylen =&nbsp; &nbsp; PATHLENGTH&nbsp;( mymeasure )VAR mytable =&nbsp; &nbsp; ADDCOLUMNS (&nbsp; &nbsp; &nbsp; &nbsp; GENERATESERIES ( 1, mylen ),&nbsp; &nbsp; &nbsp; &nbsp; "mylist", VALUE ( PATHITEM ( mymeasure, [Value],TEXT ) )&nbsp; &nbsp; )VAR mylist =&nbsp; &nbsp; SELECTCOLUMNS ( mytable, "list", [mylist] )RETURN&nbsp; &nbsp;IF(MAX('Table - List'[Item]) IN mylist, "Yes", "No")&nbsp;Data Table:ItemApplePearOrangeGrapesWatermelonStrawberry&nbsp;I get the following error:&nbsp;I can't figure out what I'm doing wrong! My list is not numerical, I have clearly specified that the value is text. Would anyone know what I'm doing wrong? I'd really appreciate any help!Thank you!

parry2k · Accepted Answer

newpbiuser01&nbsp;why you are using VALUE function here :
&nbsp;
VALUE&nbsp;(&nbsp;PATHITEM&nbsp;(&nbsp;mymeasure,&nbsp;[Value],TEXT&nbsp;) )

Forum Discussion

Split a string into a list in DAX

2 Replies

Related content

DAX formula help splitting string using delimiters

split long string by a varies of string delimiter

How to split strings by a delimiter?

Splitting Column values

Split text string