Forum Discussion
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
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
- AnonymousNot applicable
Hi,
Just put a sample of your 2 tables please it will be easier to help you
- AnonymousNot applicable
Did you link the id on each table ?
- sully343Frequent Visitor
I believe I did...I tried a many to many relationship and a one to many and neither have worked..
- sully343Frequent Visitor
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 [email protected] FALSE 1/2/2022 7:01:12 PM