cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Hell-1931
Helper I
Helper I

Replacing data in the field with the new value in Power BI Desktop

Hi,

I am re-building Data Model in Power BI Desktop

I have [City] text type field, in ClientsDetails table (8K records), like this:

Capture.JPG

After I'll create a dimension table:

City

city_id  city_name

1          Mt View

2          San Jose

3          Santa Barbara

4          Redwood City 

5          South San Francisco

 

I will need to rename [city] to [city_id] and replace text values to numeric in the ClientDetails table, as

city

2

3

1

4

5

2

2

 

Is there any way to do this in Power BI Desktop?

Creating a new [city_id] column, perhaps? Using DAX language?

 

Please, advice!

Thanks, as always

 

 

0 REPLIES 0

Helpful resources

Announcements
PBI User Groups

Welcome to the User Group Public Preview

Check out new user group experience and if you are a leader please create your group!

MBAS on Demand

Microsoft Business Applications Summit sessions

On-demand access to all the great content presented by the product teams and community members! #MSBizAppsSummit #CommunityRocks

MBAS Attendee Badge

Claim Your Badge & Digital Swag!

Check out how to claim yours today!

secondImage

Are You Ready?

Test your skills now with the Cloud Skills Challenge.

Top Solution Authors