https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/measure-to-sum-sales-for-specific-months/m-p/2000348#M44402 <P><a href="javascript:void(0)" data-lia-user-mentions="" data-lia-user-uid="148838" data-lia-user-login="amitchandak" class="lia-mention lia-mention-user">amitchandak</a>I don't want to use a slicer. I need to create a measure with DAX since I want to add that with another measure in the future.</P> Thu, 05 Aug 2021 13:24:09 GMT ArashZ 2021-08-05T13:24:09Z https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/measure-to-sum-sales-for-specific-months/m-p/1998574#M44364 <P>Hi,</P><P>&nbsp;</P><P>I want to create a measure to calculate the total sales for specific months. For example, in this example, from Feb to March.</P><TABLE border="0" cellspacing="0" cellpadding="0"><TBODY><TR><TD>Date</TD><TD>Sales</TD></TR><TR><TD>02-Feb</TD><TD>3</TD></TR><TR><TD>02-Feb</TD><TD>2</TD></TR><TR><TD>03-Mar</TD><TD>6</TD></TR><TR><TD>03-Mar</TD><TD>6</TD></TR><TR><TD>23-Apr</TD><TD>8</TD></TR><TR><TD>24-Apr</TD><TD>8</TD></TR><TR><TD>24-Apr</TD><TD>9</TD></TR><TR><TD>01-May</TD><TD>1</TD></TR></TBODY></TABLE><P>In fact, the measure should show this: (Excluding April and May)</P><TABLE border="0" cellspacing="0" cellpadding="0"><TBODY><TR><TD>Sale</TD><TD>5</TD><TD>12</TD></TR><TR><TD>Month</TD><TD>Feb</TD><TD>March</TD></TR></TBODY></TABLE><P>&nbsp;</P> Wed, 04 Aug 2021 20:57:17 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/measure-to-sum-sales-for-specific-months/m-p/1998574#M44364 ArashZ 2021-08-04T20:57:17Z https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/measure-to-sum-sales-for-specific-months/m-p/1999214#M44386 <P><a href="javascript:void(0)" data-lia-user-mentions="" data-lia-user-uid="290199" data-lia-user-login="ArashZ" class="lia-mention lia-mention-user">ArashZ</a> , Use a date /month slicer.&nbsp; Is that not working?</P> Thu, 05 Aug 2021 05:51:23 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/measure-to-sum-sales-for-specific-months/m-p/1999214#M44386 amitchandak 2021-08-05T05:51:23Z https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/measure-to-sum-sales-for-specific-months/m-p/2000348#M44402 <P><a href="javascript:void(0)" data-lia-user-mentions="" data-lia-user-uid="148838" data-lia-user-login="amitchandak" class="lia-mention lia-mention-user">amitchandak</a>I don't want to use a slicer. I need to create a measure with DAX since I want to add that with another measure in the future.</P> Thu, 05 Aug 2021 13:24:09 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/measure-to-sum-sales-for-specific-months/m-p/2000348#M44402 ArashZ 2021-08-05T13:24:09Z