topic Re: How to get the count of the event upto the current month from. if we have the data only month wise in DAX Commands and Tips https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/How-to-get-the-count-of-the-event-upto-the-current-month-from-if/m-p/3205133#M116709 <P>&nbsp;Hi&nbsp;<a href="javascript:void(0)" data-lia-user-mentions="" data-lia-user-uid="550995" data-lia-user-login="singh_16" class="lia-mention lia-mention-user">singh_16</a>&nbsp; can you elaborate more what you need?</P><P>&nbsp;</P><P>You are after totals, by month of the number of events? Like this?</P><P>&nbsp;</P><P>EG</P><TABLE border="1"><TBODY><TR><TD>Month</TD><TD># events</TD></TR><TR><TD>May</TD><TD>10</TD></TR><TR><TD>June</TD><TD>11</TD></TR></TBODY></TABLE><P>&nbsp;</P><P>Pi</P> Tue, 25 Apr 2023 13:27:50 GMT PiEye 2023-04-25T13:27:50Z How to get the count of the event upto the current month from. if we have the data only month wise https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/How-to-get-the-count-of-the-event-upto-the-current-month-from-if/m-p/3204417#M116652 <P>Here is my data model, and in the dat i have no of events month wise.</P><P>Kindly suggest any solution for this.</P><P><img /></P><P>&nbsp;</P> Tue, 25 Apr 2023 07:14:49 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/How-to-get-the-count-of-the-event-upto-the-current-month-from-if/m-p/3204417#M116652 singh_16 2023-04-25T07:14:49Z Re: How to get the count of the event upto the current month from. if we have the data only month wise https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/How-to-get-the-count-of-the-event-upto-the-current-month-from-if/m-p/3205133#M116709 <P>&nbsp;Hi&nbsp;<a href="javascript:void(0)" data-lia-user-mentions="" data-lia-user-uid="550995" data-lia-user-login="singh_16" class="lia-mention lia-mention-user">singh_16</a>&nbsp; can you elaborate more what you need?</P><P>&nbsp;</P><P>You are after totals, by month of the number of events? Like this?</P><P>&nbsp;</P><P>EG</P><TABLE border="1"><TBODY><TR><TD>Month</TD><TD># events</TD></TR><TR><TD>May</TD><TD>10</TD></TR><TR><TD>June</TD><TD>11</TD></TR></TBODY></TABLE><P>&nbsp;</P><P>Pi</P> Tue, 25 Apr 2023 13:27:50 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/How-to-get-the-count-of-the-event-upto-the-current-month-from-if/m-p/3205133#M116709 PiEye 2023-04-25T13:27:50Z Re: How to get the count of the event upto the current month from. if we have the data only month wise https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/How-to-get-the-count-of-the-event-upto-the-current-month-from-if/m-p/3212738#M117219 <P>Yes , but i want the total to show from the jan month to the (current month - 1), like if the current month is april, i would get the data for jan to march.</P> Sun, 30 Apr 2023 12:12:15 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/How-to-get-the-count-of-the-event-upto-the-current-month-from-if/m-p/3212738#M117219 singh_16 2023-04-30T12:12:15Z