Forum Discussion

supergallager34's avatar
supergallager34
Frequent Visitor
6 years ago

DAX path calculation

Hi, 

I am trying to calculate DAX path calculation and realized that it requires an additional column for hierarchy purposes. I however, have more than one manager that employees might need to report to in a building. Thus, I am trying to create a column that would bring in more rows for the same employee ID for the different manager ID. The image below is what it looks like now.

 

And this is what I am trying to make it look like

Is there a DAX calculation that would help me to make it look like it?

 

3 Replies