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

Compete to become Power BI Data Viz World Champion! First round ends August 18th. Get started.

Reply
sully343
Frequent Visitor

Information from Seperate Table

for my visualization, I have a table that shows sales. This uses information from 2 tables:

 

 

Payments: (which contains information on the actual sale such as amount, tip, credit card information vs cash, and ID). The ID is unique to that transaction.

 

Customers: Contains information like name, email, ect. This also has the ID column that is unique to their transaction. 

 

 

For my visulization I have total, tip, Full name (which is a created column in customers which combines first and last name), and date.

 

However, it doesn't display "full name". I'm guessing this is because I need some type of DAX that tells it to tie each row in each table together

Screenshot 2022-10-08 094933.png

 

How do I make it so it knows that it should pull the full name based of the ID in both tables? I've tried a one to many and a many to many relationship, neither seem to work.

4 REPLIES 4
Anonymous
Not applicable

Hi,

 

Just put a sample of your 2 tables please it will be easier to help you

 

PAYMENTS Table:

 

IDAmmount           Tip 
brrED0RUSJ6lazIQgmMZlFGpvB942047703VISADEBITsq-1-hMwpq-fCXsS2epaU5XB-FMQK-yn2LnwhJgnjQkz4x_NkvQrWn6FZUNQtq8sltIrCaptured brE nullCARDCompleted141310/1/2022 8:49:20 PM

 

CUSTOMERS Table:

 

IDF Name

L Name

 Email   
brrED0RUSJ6lazIQgmMZlFGpvBAnthonyDoe Adoe@gmail.comFALSE 1/2/2022 7:01:12 PM
Anonymous
Not applicable

Did you link the id on each table ?

I believe I did...I tried a many to many relationship and a one to many and neither have worked..

Helpful resources

Announcements
August Power BI Update Carousel

Power BI Monthly Update - August 2025

Check out the August 2025 Power BI update to learn about new features.

August 2025 community update carousel

Fabric Community Update - August 2025

Find out what's new and trending in the Fabric community.