Forum Discussion

sully343's avatar
sully343
Frequent Visitor
3 years ago

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

  • Anonymous's avatar
    Anonymous
    Not applicable

    Hi,

     

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

     

    • Anonymous's avatar
      Anonymous
      Not applicable

      Did you link the id on each table ?

      • sully343's avatar
        sully343
        Frequent Visitor

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

    • sully343's avatar
      sully343
      Frequent Visitor

      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 [email protected]FALSE 1/2/2022 7:01:12 PM