Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
8 years ago
Solved

Exploring Social Network graph Usage

Hello All,

 

I am using the Lookupvalue function for the first time.

I am trying to find out the values in a way that,

 

I have table as below.

 Employee NameSupervisorProject ManagerDelivery Manager Name
Meeta JangdeVenkat ReddyManoj MoneMandar Marulkar
Prashant PandeyVenkat ReddyManoj MoneMandar Marulkar
Abhijeet BehareVenkat ReddyVijay VenkatachalamManoj Mone
Abhijeet BehareVenkat ReddyManoj MoneMandar Marulkar
Prithviraj SawantVenkat ReddyVijay VenkatachalamManoj Mone
Maulik PatilVenkat ReddyVijay VenkatachalamManoj Mone
Mohan VankudothVenkat ReddyManoj MoneMandar Marulkar
Supriya DhekaleVenkat ReddyManoj MoneMandar Marulkar
SHRADDHA NALKARVenkat ReddyManoj MoneMandar Marulkar
Radhika MantriVenkat ReddyManoj MoneMandar Marulkar

 

Now I would like to get the values as,

For Emp Name--> Meeta Jangde

It should return as,

 

Meeta Jangde --> Venkat Reddy --> Manoj Mone --> Mandar Marulkar

 

 

How can i get it using lookupvalue funtion.

Or is there any way to get it using DAX.

 

Any help,

 

Thanks,

Mohan V

General Comment
Interesting Links
Need Help
Show and Tell
Tips and Tricks
Tutorial Requests
  • Anonymous's avatar
    Anonymous
    8 years ago

    Dear Anonymous, Abduvali,

     

    Ok, I'll share with step by step:

    • Create 4 new colum:

    Path = PATH(Employees[EmployeeName],Employees[ManagerName]) 

    Level 1 = PATHITEM(Employees[Path],1)

    Level 2 = PATHITEM(Employees[Path],2)

    Level 3 = PATHITEM(Employees[Path],3)

     

    • Create new "Emp Hierarchy" on Level 1. Then get Level 2 and 3 into this Hierarchy.
    • Download the Journey Chart. Put "Emp Hierarchy" in "Category Data", Salary in "Measure Data"
    • Make sure your Filter Emp with Level 3.

    That's it!

     

    If you need some help, don't be hesitate tag my name in your topic. I'll try if i can.

    Regards,

    ManNVSM.

     

39 Replies

  • Greg_Deckler's avatar
    Greg_Deckler
    Community Champion
    8 years ago

    Perhaps multiple LOOKUPVALUE's along with a CONCATENATE or CONCATENATEX?

    • Anonymous's avatar
      Anonymous
      Not applicable
      8 years ago

      thanks for the reply Greg_Deckler.

       

      Can you give a example.

       

      I really thankful for your help.

      • Greg_Deckler's avatar
        Greg_Deckler
        Community Champion
        8 years ago

        Not entirely sure how you want to return these, but something along the lines of:

         

        MyLookup = CONCATENATE(
                       CONCATENATE(
                                    LOOKUPVALUE([Supervisor],[Employee Name],"Meeta Jangde"),
                                    "--->"
                                  ),
               LOOKUPVALUE([Project Manager],[Employee Name],"Meeta Jangde")
                     )
  • Abduvali's avatar
    Abduvali
    Skilled Sharer
    8 years ago

    Hi Anonymous,

     

    Can you share original table view please to get a better understanding (screenshot or sample data)

     

     

    Regards

    Abduvali

    • Anonymous's avatar
      Anonymous
      Not applicable
      8 years ago

      Thanks for the quick reply Abduvali

       

      here is the sample screenshot