topic Re: Information from Seperate Table in DAX Commands and Tips

Information from Seperate Table

sully343 — Sat, 08 Oct 2022 13:50:44 GMT

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.

Re: Information from Seperate Table

Anonymous — Sat, 08 Oct 2022 15:09:51 GMT

Hi,

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

Re: Information from Seperate Table

Anonymous — Sat, 08 Oct 2022 15:10:45 GMT

Did you link the id on each table ?

Re: Information from Seperate Table

sully343 — Sat, 08 Oct 2022 22:58:03 GMT

PAYMENTS Table:

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

Re: Information from Seperate Table

sully343 — Sun, 09 Oct 2022 13:22:29 GMT

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