Search text string within a column

[Anno2019]

Hi Guru's

I have two data sources

1.  Shipment Level Data - Data is at a shipment level and contains a column for Order Number - sometimes multiple order numbers exist in the Order number field.

2.  Order Number Level Data  - Data at an order number level - Order Number field only contains 1 order number

I need to create a calculated column in the 'Order Number Level Data' that returns some of the fields in the 'Shipment Level Data' using the Order number as the lookup reference.  The problem is that the 'Shipment Level Data' [Order Number] field contains multiple order numbers.  

I need to know how to search the 'Shipment Level Data' [Order Number] field to find the shipment that contains the relevant order number.

Can anyone help?

[v-piga-msft]

Hi @Anno2019 ,

Sorry for the reply.

It seems that your link has been expired. If it is convenient, could you share it again? Please do mask sensitive data before uploading.

Best  Regards,

Cherry

[Anno2019]

Hi Cherry https://www.dropbox.com/s/3j7dhxs2nzjkafp/TEST%20File.pbix?dl=0 

[v-piga-msft]

Hi @Anno2019 ,

Thanks for your sharing firstly.

However, I cannot find the Shipment Level Data' [Order Number] and  the Order Number field in Order Number Level Data  which mentioned in your first post.

In addition, what is your desired output?

Best Regards,

Cherry

[Anno2019]

Think i might have given you the incorrect link....try this one please.

https://www.dropbox.com/home/Power%20BI%20Search%20Text%20in%20Multiple%20Columns

[v-piga-msft]

Hi @Anno2019 ,

To understand your scenario better, please share some data sample which could reproduce your Shipment Level Data,Order Number Level Data and your desired output so that we could help further on it.

Best Regards,

Cherry

[Anno2019]

Hi 

Please let me know if this link works.  Not sure if I did this correctly.

https://www.dropbox.com/home/Power%20BI%20Search%20TEXT?preview=TESTING+FILE_search+text.pbix