Hi Team,
I have two tables -Input 1 and Input 2 ...Table Input 1 has the membernames mapped to the worklists -every member can be mapped to multiple worklists ; Input 2 table has the contexts mapped to worklists -each worklist can have multiple contexts and a context can repeat across multiple worklists...
Now I am look for the output tab which has the distinct count of contexts at a member level...Can you please help me with a power query/formula for this..
Thanks,
Arun
Bookmarks