https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/List-of-different-products-and-average-of-quantity/m-p/1039502#M13894 <P>Hello!</P><P>&nbsp;</P><P>I have a big dataset that contains multiple purchase records of several customers in a store.</P><P>The table is composed with 7 columns: ClientID, Prod1, Prod1_Qt, Prod2, Prod2_Qt, Prod3, Prod3_Qt.&nbsp;</P><P>In other words, for each client there is a record of 3 products purchased and the respective quantity.</P><P>Is there any way to obtain a table, with two different columns, the list of all products purchased and the average of the quantity?</P><P>Note that products are not always in the same order.</P><P>&nbsp;</P><TABLE border="1"><TBODY><TR><TD>Client</TD><TD>Prod1</TD><TD>Prod1_Qt</TD><TD>Prod2</TD><TD>Prod2_Qt</TD><TD>Prod3</TD><TD>Prod3_Qt</TD></TR><TR><TD>1</TD><TD>clock</TD><TD>2</TD><TD>tracksuit</TD><TD>1</TD><TD>sneakers</TD><TD>3</TD></TR><TR><TD>2</TD><TD>ball</TD><TD>3</TD><TD>sneakers</TD><TD>2</TD><TD>racket</TD><TD>1</TD></TR><TR><TD>3</TD><TD>tracksuit</TD><TD>1</TD><TD>clock</TD><TD>2</TD><TD>ball</TD><TD>4</TD></TR></TBODY></TABLE><P>&nbsp;</P><P>Thank you in advance!<BR />-- Fábio Ferreira</P> Tue, 21 Apr 2020 14:30:24 GMT fabio7xavier 2020-04-21T14:30:24Z https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/List-of-different-products-and-average-of-quantity/m-p/1039502#M13894 <P>Hello!</P><P>&nbsp;</P><P>I have a big dataset that contains multiple purchase records of several customers in a store.</P><P>The table is composed with 7 columns: ClientID, Prod1, Prod1_Qt, Prod2, Prod2_Qt, Prod3, Prod3_Qt.&nbsp;</P><P>In other words, for each client there is a record of 3 products purchased and the respective quantity.</P><P>Is there any way to obtain a table, with two different columns, the list of all products purchased and the average of the quantity?</P><P>Note that products are not always in the same order.</P><P>&nbsp;</P><TABLE border="1"><TBODY><TR><TD>Client</TD><TD>Prod1</TD><TD>Prod1_Qt</TD><TD>Prod2</TD><TD>Prod2_Qt</TD><TD>Prod3</TD><TD>Prod3_Qt</TD></TR><TR><TD>1</TD><TD>clock</TD><TD>2</TD><TD>tracksuit</TD><TD>1</TD><TD>sneakers</TD><TD>3</TD></TR><TR><TD>2</TD><TD>ball</TD><TD>3</TD><TD>sneakers</TD><TD>2</TD><TD>racket</TD><TD>1</TD></TR><TR><TD>3</TD><TD>tracksuit</TD><TD>1</TD><TD>clock</TD><TD>2</TD><TD>ball</TD><TD>4</TD></TR></TBODY></TABLE><P>&nbsp;</P><P>Thank you in advance!<BR />-- Fábio Ferreira</P> Tue, 21 Apr 2020 14:30:24 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/List-of-different-products-and-average-of-quantity/m-p/1039502#M13894 fabio7xavier 2020-04-21T14:30:24Z https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/List-of-different-products-and-average-of-quantity/m-p/1039660#M13902 <P>Hi&nbsp;<a href="javascript:void(0)" data-lia-user-mentions="" data-lia-user-uid="186207" data-lia-user-login="fabio7xavier" class="lia-mention lia-mention-user">fabio7xavier</a>&nbsp;,</P><P>&nbsp;</P><P>Are you brazilian ?</P><P>&nbsp;</P><P>I've created this file as an example:&nbsp;<A title="PBIX" href="https://drive.google.com/file/d/1o6Dwcb37HY0zRCcGhJngmC7EQsB5RuY0/view?usp=sharing" target="_blank" rel="noopener">Download PBIX</A>&nbsp;</P><P>&nbsp;</P><P>I hope it helps,</P><P>&nbsp;</P><P>Ricardo</P> Tue, 21 Apr 2020 15:27:17 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/List-of-different-products-and-average-of-quantity/m-p/1039660#M13902 camargos88 2020-04-21T15:27:17Z