Forum Discussion
Getting value in a different column by filtering and max
Hi Everyone, I am trying to get the staff name for different category, based on max total training hours. Eg. Expected result = Staff A, after i filter Cat 1 and MAX of total training hours ...
Hi, Anonymous
I am not sure whether I understood your question correctly, but check the below.
https://www.dropbox.com/s/hm87mfz1ektwp1z/myhyasin.pbix?dl=0
Hi, My name is Jihwan Kim.
If this post helps, then please consider accept it as the solution to help other members find it faster, and give a big thumbs up.
Linkedin: linkedin.com/in/jihwankim1975/
Twitter: twitter.com/Jihwan_JHKIM
Hi amitchandak , I tried this too but what about the filter for the category?
This will also return the training hours but i want it to return the name of staff