Information from Seperate Table

[sully343]

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

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.

[Anonymous]

Hi,

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

[sully343]

PAYMENTS Table:

ID

Ammount

Tip

brrED0RUSJ6lazIQgmMZlFGpvB

9420

47703

VISA

DEBIT

sq-1-hMwpq-fCXsS2epaU5XB-FMQK-yn2LnwhJgnjQkz4x_NkvQrWn6FZUNQtq8sltIr

Captured

brE

null

CARD

Completed

1413

10/1/2022 8:49:20 PM

CUSTOMERS Table:

ID	F Name	L Name		Email
brrED0RUSJ6lazIQgmMZlFGpvB	Anthony	Doe		Adoe@gmail.com	FALSE		1/2/2022 7:01:12 PM

[Anonymous]

Did you link the id on each table ?

[sully343]

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