The ultimate Microsoft Fabric, Power BI, Azure AI, and SQL learning event! Join us in Stockholm, Sweden from September 24-27, 2024.
2-for-1 sale on June 20 only!
Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started
Hello everyone,
I hope you're doing great! I'm trying to look up a value in certain column and replace it with identical value in different row. Can someone please recommend how to do so?
Whenever a PO is #/# I would like to search in Document Text for identical column and replace the #/# with the PO matching in the new found row!
Sounds a bit complicated but I tried using Custom If column, but couldn't make the lookup function properly.
Bestr regards,
Omar
Thanks for the reply from @Uzi2019 , please allow me to provide another insight:
Hi @OmarAl ,
Here are the steps you can follow:
1. In Power Query – Add Column – Custom Column.
2. Enter the following code .
if [PO] = "#/#" then [Document] else [Custom]
3. Result:
Best Regards,
Liu Yang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly
Hi Liu, I appreciate your help! But I would really like to replace the #/# with a PO number that is in dfifferent row. In example , the first #/# would ideally be replaced by 400500600 because it's matched witht the same text of Columne Document Text in row 2
Hi @OmarAl
Try below post for reference
https://community.fabric.microsoft.com/t5/Power-Query/Power-Query-Lookup/m-p/2016427
I hope above post may resolves your issue!
Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.
Check out the June 2024 Power BI update to learn about new features.
User | Count |
---|---|
99 | |
94 | |
85 | |
69 | |
65 |
User | Count |
---|---|
244 | |
128 | |
119 | |
82 | |
78 |