Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

The ultimate Microsoft Fabric, Power BI, Azure AI & SQL learning event! Join us in Las Vegas from March 26-28, 2024. Use code MSCUST for a $100 discount. Register Now

Reply
Anonymous
Not applicable

How do I assign a numeric value to a non-numeric value and then connecting it to another table?

Hi. 


Can somebody please help me with this (I dont want to post the real data): 

 

I have this table A:

 

ID:                                Name: 

2                                  Apple

3                                  Banana 

7                                  Grape

22                                Orange

 

Then I have table B:

Category:

2

3

7

22

 

I would like to convert the numbers in table B "category" into the names from table A. So table B would like this instead:

 

Category:

Apple

Banana 

Grape

Orange

 

Best regards,

Lisa

3 REPLIES 3
ribisht17
Super User
Super User

Anonymous
Not applicable

But it does not let me select different type of data? I need the numbers to be replaced with text. 

Best regards,

Lisa 

Anonymous
Not applicable

Let me try to explain again: 


Main table

Category: 

1

3

5

7

22

18

 

Table A: 

Item-no:                Name: 

1                            Apple

3                            Orange

5                            Strawberry

7                            Lemon

22                          Mango

18                          Banana

 

I would like to merge these tables, so the values in "category" in the main table gets replaced with "name" from Table A. The values are the same in "category" (1, 3, 5 etc.) and in table A under "item-number"(1,3, 5 etc). I would like to see the name for that item-no. in the main table instead of numbers. 

 

I am still a newbie in Power BI, so please give me a dummie explanation 🙂

 

Best regards, 

Lisa

 

 

Helpful resources

Announcements
Fabric Community Conference

Microsoft Fabric Community Conference

Join us at our first-ever Microsoft Fabric Community Conference, March 26-28, 2024 in Las Vegas with 100+ sessions by community experts and Microsoft engineering.

February 2024 Update Carousel

Power BI Monthly Update - February 2024

Check out the February 2024 Power BI update to learn about new features.

Fabric Career Hub

Microsoft Fabric Career Hub

Explore career paths and learn resources in Fabric.

Fabric Partner Community

Microsoft Fabric Partner Community

Engage with the Fabric engineering team, hear of product updates, business opportunities, and resources in the Fabric Partner Community.