topic Re: How to generate monthly totals by year in DAX Commands and Tips https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/How-to-generate-monthly-totals-by-year/m-p/3491037#M133668 <P>thank you i have supprime MAX function and tacking only a=total[month] and is ok.</P> Mon, 23 Oct 2023 10:00:51 GMT fredSPE 2023-10-23T10:00:51Z How to generate monthly totals by year https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/How-to-generate-monthly-totals-by-year/m-p/3487848#M133470 <P>How to generate monthly totals by year, for example:<BR />year&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; month&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;value&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;monthlytotals</P><P>2023&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 1&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 2&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;2</P><P>2023&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 3&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 3&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;5</P><P>2023&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 4&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 1&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;6</P><P>2023&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 12&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 8&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;12</P><P>2022&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 2&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 5&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;5</P><P>2022&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 3&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 3&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;8</P><P>2022&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 4&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 7&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;15</P><P>2022&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 11&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 9&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;24</P><P>monthlytotals is what I need to find</P> Fri, 20 Oct 2023 14:09:36 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/How-to-generate-monthly-totals-by-year/m-p/3487848#M133470 fredSPE 2023-10-20T14:09:36Z Re: How to generate monthly totals by year https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/How-to-generate-monthly-totals-by-year/m-p/3488427#M133506 <P>hi,&nbsp;<a href="javascript:void(0)" data-lia-user-mentions="" data-lia-user-uid="634066" data-lia-user-login="fredSPE" class="lia-mention lia-mention-user">fredSPE</a>&nbsp;<BR /><BR />try below&nbsp;<BR /><BR /></P><DIV><DIV><DIV><SPAN>monthlytotal =</SPAN></DIV><DIV><SPAN>var</SPAN> <SPAN>a</SPAN><SPAN> = </SPAN><SPAN>MAX</SPAN><SPAN>(</SPAN><SPAN>total</SPAN><SPAN>[month]</SPAN><SPAN>)</SPAN></DIV><DIV><SPAN>var</SPAN> <SPAN>b</SPAN><SPAN> = </SPAN><SPAN>CALCULATE</SPAN><SPAN>(</SPAN><SPAN>SUM</SPAN><SPAN>(</SPAN><SPAN>total</SPAN><SPAN>[value]</SPAN><SPAN>),</SPAN><SPAN>total</SPAN><SPAN>[month]</SPAN><SPAN>&lt;=</SPAN><SPAN>a</SPAN><SPAN>,</SPAN><SPAN>ALLEXCEPT</SPAN><SPAN>(</SPAN><SPAN>total</SPAN><SPAN>,</SPAN><SPAN>total</SPAN><SPAN>[year]</SPAN><SPAN>))</SPAN></DIV><DIV><SPAN>return</SPAN></DIV><DIV><SPAN>b</SPAN></DIV><DIV>&nbsp;</DIV><DIV>&nbsp;</DIV></DIV></DIV><P><img /></P><P>&nbsp;</P><P><STRONG>If this post&nbsp;helps, then please consider&nbsp;Accepting it as the solution&nbsp;to help the other members find it more quickly. Appreciate your kudos</STRONG></P><P>&nbsp;</P> Fri, 20 Oct 2023 19:01:48 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/How-to-generate-monthly-totals-by-year/m-p/3488427#M133506 Dangar332 2023-10-20T19:01:48Z Re: How to generate monthly totals by year https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/How-to-generate-monthly-totals-by-year/m-p/3491037#M133668 <P>thank you i have supprime MAX function and tacking only a=total[month] and is ok.</P> Mon, 23 Oct 2023 10:00:51 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/How-to-generate-monthly-totals-by-year/m-p/3491037#M133668 fredSPE 2023-10-23T10:00:51Z