topic Re: Group multiple columns in DAX Commands and Tips https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Group-multiple-columns/m-p/2806781#M88594 <P><a href="javascript:void(0)" data-lia-user-mentions="" data-lia-user-uid="406948" data-lia-user-login="CamillaDiPassio" class="lia-mention lia-mention-user">CamillaDiPassio</a>&nbsp;</P> <OL> <LI>Create a Month column:&nbsp;Month = FORMAT([Date],"mmmm")</LI> <LI>Create a MonthSort column:&nbsp;MonthSort = MONTH([Date])</LI> <LI>Set Sort By for Month to be MonthSort</LI> <LI>Put Code in a Matrix visual (rows)</LI> <LI>Put Month in the Matrix visual (column)</LI> <LI>Put Alert in the Matrix visual (values, sum aggregation)</LI> </OL> Thu, 29 Sep 2022 15:33:41 GMT Greg_Deckler 2022-09-29T15:33:41Z Group multiple columns https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Group-multiple-columns/m-p/2806741#M88590 <P>Hello everyone,&nbsp;<BR />I have a problem with a set of data. I have three different columns and I would like to know for each Code per month the sum of the Alert.&nbsp;<BR />For example: for the code <STRONG>9765</STRONG> I have <STRONG>3</STRONG> alerts in <STRONG>January</STRONG>.&nbsp;<BR />This is the set of date:&nbsp;<BR /><BR /></P><TABLE><TBODY><TR><TD>Code</TD><TD>Alert</TD><TD>Date</TD></TR><TR><TD>9930</TD><TD>1</TD><TD>05/01/2022</TD></TR><TR><TD>301973</TD><TD>1</TD><TD>05/01/2022</TD></TR><TR><TD>9765</TD><TD>1</TD><TD>10/01/2022</TD></TR><TR><TD>9765</TD><TD>1</TD><TD>10/01/2022</TD></TR><TR><TD>9765</TD><TD>1</TD><TD>10/01/2022</TD></TR><TR><TD>13447</TD><TD>1</TD><TD>11/01/2022</TD></TR><TR><TD>21745</TD><TD>1</TD><TD>12/01/2022</TD></TR><TR><TD>9776</TD><TD>1</TD><TD>14/01/2022</TD></TR><TR><TD>9300</TD><TD>1</TD><TD>19/01/2022</TD></TR><TR><TD>21745</TD><TD>1</TD><TD>25/01/2022</TD></TR><TR><TD>9776</TD><TD>1</TD><TD>25/01/2022</TD></TR><TR><TD>301973</TD><TD>1</TD><TD>26/01/2022</TD></TR><TR><TD>4823</TD><TD>1</TD><TD>27/01/2022</TD></TR><TR><TD>9851</TD><TD>1</TD><TD>28/01/2022</TD></TR><TR><TD>9851</TD><TD>1</TD><TD>28/01/2022</TD></TR><TR><TD>301973</TD><TD>1</TD><TD>28/01/2022</TD></TR><TR><TD>9765</TD><TD>1</TD><TD>02/02/2022</TD></TR><TR><TD>9765</TD><TD>1</TD><TD>03/02/2022</TD></TR><TR><TD>301973</TD><TD>1</TD><TD>04/02/2022</TD></TR><TR><TD>9765</TD><TD>1</TD><TD>04/02/2022</TD></TR><TR><TD>10072</TD><TD>1</TD><TD>04/02/2022</TD></TR><TR><TD>9851</TD><TD>1</TD><TD>04/02/2022</TD></TR><TR><TD>18861</TD><TD>1</TD><TD>07/02/2022</TD></TR><TR><TD>9765</TD><TD>1</TD><TD>08/02/2022</TD></TR><TR><TD>9300</TD><TD>1</TD><TD>08/02/2022</TD></TR><TR><TD>9851</TD><TD>1</TD><TD>08/02/2022</TD></TR><TR><TD>9851</TD><TD>1</TD><TD>10/02/2022</TD></TR><TR><TD>9851</TD><TD>1</TD><TD>15/02/2022</TD></TR><TR><TD>9851</TD><TD>1</TD><TD>15/02/2022</TD></TR><TR><TD>21745</TD><TD>1</TD><TD>15/02/2022</TD></TR><TR><TD>302986</TD><TD>1</TD><TD>16/02/2022</TD></TR><TR><TD>9300</TD><TD>1</TD><TD>17/02/2022</TD></TR><TR><TD>301973</TD><TD>1</TD><TD>21/02/2022</TD></TR><TR><TD>21732</TD><TD>1</TD><TD>23/02/2022</TD></TR><TR><TD>9851</TD><TD>1</TD><TD>25/02/2022</TD></TR><TR><TD>21732</TD><TD>1</TD><TD>02/03/2022</TD></TR><TR><TD>5376</TD><TD>1</TD><TD>04/03/2022</TD></TR><TR><TD>10109</TD><TD>1</TD><TD>14/03/2022</TD></TR><TR><TD>4823</TD><TD>1</TD><TD>15/03/2022</TD></TR><TR><TD>9300</TD><TD>1</TD><TD>17/03/2022</TD></TR><TR><TD>9851</TD><TD>1</TD><TD>17/03/2022</TD></TR><TR><TD>21732</TD><TD>1</TD><TD>17/03/2022</TD></TR><TR><TD>21732</TD><TD>1</TD><TD>17/03/2022</TD></TR><TR><TD>9300</TD><TD>1</TD><TD>21/03/2022</TD></TR><TR><TD>21732</TD><TD>1</TD><TD>22/03/2022</TD></TR><TR><TD>9300</TD><TD>1</TD><TD>23/03/2022</TD></TR><TR><TD>301973</TD><TD>1</TD><TD>25/03/2022</TD></TR><TR><TD>21745</TD><TD>1</TD><TD>25/03/2022</TD></TR><TR><TD>9300</TD><TD>1</TD><TD>29/03/2022</TD></TR><TR><TD>21745</TD><TD>1</TD><TD>31/03/2022</TD></TR></TBODY></TABLE><P>&nbsp;</P><P>Thank you for the support!!!</P> Thu, 29 Sep 2022 15:04:02 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Group-multiple-columns/m-p/2806741#M88590 CamillaDiPassio 2022-09-29T15:04:02Z Re: Group multiple columns https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Group-multiple-columns/m-p/2806781#M88594 <P><a href="javascript:void(0)" data-lia-user-mentions="" data-lia-user-uid="406948" data-lia-user-login="CamillaDiPassio" class="lia-mention lia-mention-user">CamillaDiPassio</a>&nbsp;</P> <OL> <LI>Create a Month column:&nbsp;Month = FORMAT([Date],"mmmm")</LI> <LI>Create a MonthSort column:&nbsp;MonthSort = MONTH([Date])</LI> <LI>Set Sort By for Month to be MonthSort</LI> <LI>Put Code in a Matrix visual (rows)</LI> <LI>Put Month in the Matrix visual (column)</LI> <LI>Put Alert in the Matrix visual (values, sum aggregation)</LI> </OL> Thu, 29 Sep 2022 15:33:41 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Group-multiple-columns/m-p/2806781#M88594 Greg_Deckler 2022-09-29T15:33:41Z