show specific rows as % all others as text

[jcastr02]

I have a table of store details (which I had to pivot and stack all into rows vs. columns) for other purposes.  However, now I'd like to just convert some of values to show as %.  Is there a way to create a new column but say column XYZ and column ABC - show as %, all others show as text.  See below ones in yellow I need as %.

[Daniel29195 · Accepted solution]

@jcastr02 

output : column Custom

try this : 

if [Column3] = "pct" then Text.Combine({"%" ,Text.From(Decimal.From([Column2]))},"") else [Column2]

first you convert it into decimal, then you add the % to it. 

NB : 

you need to specify  which rows are pct and need to be converted ( check column3  ) 

If my answer helped sort things out for you, feel free to give it a thumbs up and mark it as the solution! It makes a difference and might help someone else too. Thanks for spreading the good vibes! 👍🤠