Forum Discussion
Solved
Replace Text.Rage result with a value from another table
Hi I filter a string out of a text with: = try if Text.StartsWith([Product_Number], "P-") then Text.Range([Product_Number],11,2) else "NoService" otherwise "NoService" that works fine solar and...
HI,@adieball
After my research, you can do these follow my steps:
Step1:
Use your formula to add a custom column
Step2:
Step3:
Expand the table
Step4:
add a conditional colum:
Result:
You can also remove unnecessary column
Best Regards,
Lin
HI,@adieball
After my research, you can do these follow my steps:
Step1:
Use your formula to add a custom column
Step2:
Step3:
Expand the table
Step4:
add a conditional colum:
Result:
You can also remove unnecessary column
Best Regards,
Lin