Forum Discussion
Search text string within a column
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?
6 Replies
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
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
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
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
