Discussion Betreff: Help with PowerQuery/Formula to calculate the distinct count of contexts per member in Excel
https://techcommunity.microsoft.com/t5/excel/help-with-powerquery-formula-to-calculate-the-distinct-count-of/m-p/2524529#M105895
<P><LI-USER uid="216929"></LI-USER> </P><P> </P><P>You should check your Input1 Table, there are some type errors I think. otherwise it would not fit with your expected output.</P><P>please find a result in the attached file</P>Wed, 07 Jul 2021 18:53:05 GMTGerman_Chris2021-07-07T18:53:05ZHelp with PowerQuery/Formula to calculate the distinct count of contexts per member
https://techcommunity.microsoft.com/t5/excel/help-with-powerquery-formula-to-calculate-the-distinct-count-of/m-p/2524311#M105885
<P><SPAN>Hi Team,</SPAN><BR /><BR /><SPAN>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...</SPAN><BR /><BR /><SPAN>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..</SPAN><BR /><BR /><SPAN>Thanks,</SPAN><BR /><SPAN>Arun</SPAN></P>Wed, 07 Jul 2021 17:45:04 GMThttps://techcommunity.microsoft.com/t5/excel/help-with-powerquery-formula-to-calculate-the-distinct-count-of/m-p/2524311#M105885Arun Chandramouli2021-07-07T17:45:04ZBetreff: Help with PowerQuery/Formula to calculate the distinct count of contexts per member
https://techcommunity.microsoft.com/t5/excel/help-with-powerquery-formula-to-calculate-the-distinct-count-of/m-p/2524529#M105895
<P><LI-USER uid="216929"></LI-USER> </P><P> </P><P>You should check your Input1 Table, there are some type errors I think. otherwise it would not fit with your expected output.</P><P>please find a result in the attached file</P>Wed, 07 Jul 2021 18:53:05 GMThttps://techcommunity.microsoft.com/t5/excel/help-with-powerquery-formula-to-calculate-the-distinct-count-of/m-p/2524529#M105895German_Chris2021-07-07T18:53:05ZBetreff: Help with PowerQuery/Formula to calculate the distinct count of contexts per member
https://techcommunity.microsoft.com/t5/excel/help-with-powerquery-formula-to-calculate-the-distinct-count-of/m-p/2526851#M105957
Thank you so much German_chris!..Thu, 08 Jul 2021 06:54:19 GMThttps://techcommunity.microsoft.com/t5/excel/help-with-powerquery-formula-to-calculate-the-distinct-count-of/m-p/2526851#M105957Arun Chandramouli2021-07-08T06:54:19Z