Forum Discussion
Newbie-Formula for replacing Values (Numbers to text) *Help to get me started with confidence
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.
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!
