Help with PowerQuery/Formula to calculate the distinct count of contexts per member


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..


2 Replies
best response confirmed by Arun Chandramouli (Contributor)

@Arun Chandramouli 


You should check your Input1 Table, there are some type errors I think. otherwise it would not fit with your expected output.

please find a result in the attached file