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
v-yulgu-msft's avatar
v-yulgu-msft
Microsoft Employee
8 years ago

Hi Boycie92,

 

Have you achieved your desired result? If yes, would you please accept the helpful reply as an answer or share your solution?

 

Best regards,
Yuliana Gu

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