Forum Discussion
Solved
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 ...
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.
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.