Forum Discussion
Help With Visuals from Unpivot
Hoping someone can help.
I have the following fact table
Title | Attribute | Value |
Project A | Project Lead | Staff1 |
Project A | Supporting Lead | Staff2 |
Project B | Project Lead | Staff3 |
Project B | Supporting Lead | Staff2 |
Project C | Project Lead | Staff2 |
Project C | Supporting Lead | Staff3 |
and the below dimension table
StaffID | StaffName |
Staff1 | John |
Staff2 | Mary |
Staff3 | Andrew |
How can I produce the below visual when I have only one field to work on the dimension table?
Project Name | Project Lead | Supporting Lead |
Project A | John | Mary |
Project B | Andrew | Mary |
Project C | Mary | Andrew |
One way is to pull in the dimension attribute into the fact table as a calculated column
see attached
Hi lennardsomera ,
First of all thank you lbendlin for the quick reply and solution.
Apart from that you can also try the following calculation column:StaffName = LOOKUPVALUE('Dimension'[StaffName],'Dimension'[StaffID],'Fact'[Value])Best Regards,
Neeko Tang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
2 Replies
One way is to pull in the dimension attribute into the fact table as a calculated column
see attached
Hi lennardsomera ,
First of all thank you lbendlin for the quick reply and solution.
Apart from that you can also try the following calculation column:StaffName = LOOKUPVALUE('Dimension'[StaffName],'Dimension'[StaffID],'Fact'[Value])Best Regards,
Neeko Tang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.