Forum Discussion
Solved
Display multiple fields that reference 1 master table
I have 2 tables Customer Table Company Sales Mgr Acc Mgr Support Mgr Comp A 1 4 4 Comp B 2 3 3 Comp C 1 4 3 Staff Table ID Name 1 James H 2 Tan KK 3...
Thanks. Unpivot does the trick !
Hi, gancw1
I'm not sure I understand it correctly. But what I am guessing is that mngrAcc and MngrSupport are the IDs that match the IDs in the Staff table, right?
If yes, and you do not want to merge, then you should create a relationship using the three key columns in the customer and Staff tables. One will be active, and the other two will be inactive.
Then, in DAX you have use UseRelationship DAX func to utilize the relationship and get the result.
refer: USERELATIONSHIP with TEXT - Microsoft Fabric Community
for this method do I use UseRelationship to create new computed columns ?