Forum Discussion
Helper IIILink tables with different columns
I have data on two tables similar to this:
DATE, PART, MACHINE
DATE, PART
I need the values for the machine and I need to be able to chart/graph and use those values. I can't get anything to work.
I'm not very experienced with PowerBI so I could be overlooking something simple.
Any suggestions?
Thanks.
I figured out something that seems to work.
I deleted all relationships in the model. I then used RELATEDTABLE and it gave the desired result.
Thanks!
4 Replies
- amitchandak
Super User
Locco , what is the difference between the two tables. if the second table is a unique date and part
you can create a key on both tables like this and join and analyze
key = [part] & [Date]
LoccoBoth tables have more columns than just those 3. The tables only share DATE and PART columns though.
The tables are not unique, DATE and PART on table 1 are the same as DATE and PART on table 2.
- Locco
Cannot get LOOKUPVALUES to work, cannot get merge queries to work, other codes are not working either (column = tableA[value]).
Really not understanding why something so simple will not work and why what works for others isn't working for me.
- Locco
I figured out something that seems to work.
I deleted all relationships in the model. I then used RELATEDTABLE and it gave the desired result.
Thanks!
