The ultimate Fabric, Power BI, SQL, and AI community-led learning event. Save €200 with code FABCOMM.
Get registeredCompete to become Power BI Data Viz World Champion! First round ends August 18th. Get started.
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.
Hi,
Just put a sample of your 2 tables please it will be easier to help you
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 | |||||
brrED0RUSJ6lazIQgmMZlFGpvB | Anthony | Doe | Adoe@gmail.com | FALSE | 1/2/2022 7:01:12 PM |
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..
User | Count |
---|---|
16 | |
8 | |
7 | |
6 | |
6 |
User | Count |
---|---|
26 | |
13 | |
12 | |
8 | |
8 |