Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
9 years ago
Solved

Creating relationships to multiple columns and displaying data

I have imported a SharePoint list IncidentTracker. The "Created By" and "Modified By" columns are displayed as "CreatedByID" and "ModifiedByID" respectively.   I also imported UserInformationList f...
Need Help
  • Vvelarde's avatar
    Vvelarde
    9 years ago

     

     

    CreatedByUser = CALCULATE(VALUES(User[Name]),USERELATIONSHIP(Incident[Createdby],User[User]))

    ModifiedByUser = CALCULATE(VALUES(User[Name]),USERELATIONSHIP(Incident[Modifiedby],User[User]))

     

Vvelarde's avatar
Vvelarde
Icon for Community Champion rankCommunity Champion
9 years ago

 

 

CreatedByUser = CALCULATE(VALUES(User[Name]),USERELATIONSHIP(Incident[Createdby],User[User]))

ModifiedByUser = CALCULATE(VALUES(User[Name]),USERELATIONSHIP(Incident[Modifiedby],User[User]))

 

Anonymous's avatar
Anonymous
Not applicable
5 years ago

Vvelarde 

If i want to use two more relation ships with the userealtionship function can it be possibel 

 

Calculate(count(inc),userelationship(inc[country],user[country]),userelationship(inc[user],user[user])

 

Thanks in advance