Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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?
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
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
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
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
111 | |
95 | |
77 | |
68 | |
54 |
User | Count |
---|---|
144 | |
105 | |
102 | |
89 | |
63 |