Forum Discussion
Newbie-Formula for replacing Values (Numbers to text) *Help to get me started with confidence
Hi, please can you tell which formula i can use to replace some numbers with a word.
Example'
'500' = 'Gold'
'200' = 'Siilver'
'100' = 'Bronze'
I havent used formulas for a very long time!!! so I am just slowly coming back to the fold. Your help much appreicated. Thank you
Current Column
Row 1: Spiderman (Status.500)
Row 2: Batwoman (Status.200)
Row 3: Wonderman (Status.100)
New Custom Column to look like this:
Row 1: Gold
Row 2: Silver
Row 3: Bronze
esmerlda There are a few options here. You can use Power Query, click the 'Add Column' tab and choose 'Extract' > 'Text After Delimter' > Custom > type
.
into the box. Click 'OK'.
Then click Transform Column tab > Text before delimiter > Custom > type
)
into the box. Click OK.
Then you can either:
Option A
click Add Column tab >Conditional Column
set that up to look for 500, 200, 100 and replace with Gold, Silver Bronze
Option B
Create a new table that has two columns:
Level Status
500 Gold
200 Silver
100 Bronze
Then use the relationships to connect these two tables.
2 Replies
- AllisonKennedy
Community Champion
esmerlda There are a few options here. You can use Power Query, click the 'Add Column' tab and choose 'Extract' > 'Text After Delimter' > Custom > type
.
into the box. Click 'OK'.
Then click Transform Column tab > Text before delimiter > Custom > type
)
into the box. Click OK.
Then you can either:
Option A
click Add Column tab >Conditional Column
set that up to look for 500, 200, 100 and replace with Gold, Silver Bronze
Option B
Create a new table that has two columns:
Level Status
500 Gold
200 Silver
100 Bronze
Then use the relationships to connect these two tables.
Super Allison! You've shone a light into my journey in using Power Bi. You provided options simply & clearly described them
I Used Option A
Thank you so much!
