Forum Discussion
Solved
Second to last non blank value in an array?
I have a chart with employees and reporting relationships and am trying to do some analysis by the VP of each department. My data looks like this: Department Employee First Manager Seco...
Could try a big nested if, something like:
if([fourth manager]=null,(similar logic checking the third manager),third manager)
It'll look at each column in turn, and when it finds one that isn't blank, returns the previous column
Abduvali
Skilled Sharer
Skilled SharerHi AGuero,
You need to use Unpivot and then use Group by functions:
Unpivot and Group By Functions in Power BI Desktop
Hope this helps.
Regards
Abduvali