Forum Discussion
Solved
Hierarchy help!
Hi All, My dataset has two columns (Divison & Department). The normal sequence is from Division to Department (so each Div have multi Dep). I am trying to get a sub-index for the department in po...
Excel worksheet formula is powerful enough to solve this simple question,
Here's a Power Query option that may work for you. See attached PBIX.