Solved: Exploring Social Network graph Usage - Page 4

Anonymous · ‎11-20-2017

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.

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

Anonymous · ‎11-23-2017

Dear @Anonymous, @Abduvali,

Ok, I'll share with step by step:

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.

Exploring Social Network graph Usage