Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago
Solved

If contains then yes

Hi all,   I have a visual (table) with columns from different linked data tables in the background in my PBI file. Now I want to create a DAX that would be like this:   Look in the "Warehouse"[Li...
Need Help
  • v-angzheng-msft's avatar
    v-angzheng-msft
    5 years ago

    Hi Anonymous 

     

    You can try to create a calculate column using CONTAINSSTRINGEXACT or FIND function

     

    If contains then yes (CONTAINSSTRINGEXACT) =
IF ( CONTAINSSTRINGEXACT ( 'Table'[Aisle_list], 'Table'[Aisle] ), "Yes", "No" )

     

    Or

     

    If contains then yes (Find) =
IF (
    ISBLANK ( FIND ( 'Table'[Aisle], 'Table'[Aisle_list], 1, BLANK () ) ),
    "No",
    "Yes"
)

     

    Sample data:

    Result:

    Is this the result you want? Hope this is useful to you

    Please feel free to let me know if I misunderstand your question

     

    Best Regards,
    Community Support Team _ Zeon Zheng

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

tex628's avatar
tex628
Icon for Community Champion rankCommunity Champion
5 years ago

Hi Anonymous , 

Try creating a calculated column in the Warehouse table using the CONTAINSSTRING(<within_text>, <find_text>) syntax. 

Something like this:
Column = IF( CONTAINSTRING (  Warehouse[Place] , Warehouse[List] ) , "Yes" , "No" )

Hope this helps,

Br, 
J

Anonymous's avatar
Anonymous
Not applicable
5 years ago

Hi J

 

don´t work. Get an error.

Please see my screenshot. If Aisle information is in Aisle_list then yes, if not no.

CK is in CD,CE...CJ,CK...  = yes

CK is in FB = no

 

With Containsstring i can not find the columne in the measure.

 

BR

Mary 

 
 

 

 

 

 

 

  • tex628's avatar
    tex628
    Icon for Community Champion rankCommunity Champion
    5 years ago

    Dont create a measure, create a calculated column in the table. 

    / J