Forum Discussion

Boycie92's avatar
Boycie92
Resolver I
9 years ago

Replace Values

Hi,   I was wondering if someone could help.   I know with power query you can mass replaces values. I was wondering if it was possible to do this for individual values?   For instance, I have ...
Need Help
Tips and Tricks
v-yulgu-msft's avatar
v-yulgu-msft
Microsoft Employee
8 years ago

Hi Boycie92,

 

Could you try this:

=if [Column2]="A" then [Column2]&Text.From([Column3]) else null

Please pay attention the case sensitive. For more advice, please share more sample data and show us your expected output.

 

Regards,
Yuliana Gu

Boycie92's avatar
Boycie92
Resolver I
8 years ago

Hi v-yulgu-msft

 

I am sorry when i said "However if the other values in the original column are not A the show me blank"

 

What I actually wanted was show me the original values within the original column if it’s not A. If it is A show me the values from the new column (A1, A2, etc)

 

Sorry again, I hope that makes much more sense!

 

Thanks,

Boycie92