Forum Discussion

Boycie92's avatar
Boycie92
Resolver I
8 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
Boycie92's avatar
Boycie92
Resolver I
8 years ago

Hi v-yulgu-msft

 

Apologies for the delay in responding.

 

Your solution would work but within my column I have other values that I need to use. (A) Is just an example.

So if I was to create another column I would need to somehow tell it if you see A show me A1 or A2 etc. However if the other values in the original column are not A the show me blank

 

Now I could use a custom column to do this, the problem I have is telling it to split the A values?

 

Thanks for the help,

Boycie92

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