Forum Discussion
Replace Values - Text & Cell Value
Hello, I am trying to Replace values, where the result would be a concatenation of a text & a cell value. For instance "Transaction Date 12/06/2022", but I am stuck with how to combine "Transacti...
Hi Anonymous ,
Based on your sample data, I reproduced it and you can modify your formula as follows to get your expected result.
= Table.ReplaceValue(#"Changed Type","",each "Transaction Date "&Text.From([Transaction Date]), Replacer.ReplaceValue,{"JE Memo"})Best Regards,
Stephen Tao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Is "Transaction Date" always the same text? What if you add a custom column with formula = "Transaction Date"&[Transaction Date]
This is to create a new column of with Transaction Date 12/6/2022