Jul 07 2021 10:45 AM
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
Jul 07 2021 11:53 AM
Solution
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
Jul 07 2021 11:54 PM
Jul 07 2021 11:53 AM
Solution
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