topic ON date finding Cummulative Number... in DAX Commands and Tips

topic ON date finding Cummulative Number... in DAX Commands and Tips https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/ON-date-finding-Cummulative-Number/m-p/4809018#M183910 <P>Is there way to calculate cummulative number of occurences based on the date coulmn.</P><P>For example:</P><P>In one table i have the information when something was created:</P><P>    date       |  name</P><P>1/1/2025    |  abc</P><P>12/1/2025  |  osks</P><P>13/3/2025  |   doferf</P><P>and in the second one i want to have a number of "names" by month name (lets assume i have a Date table with month names related with the first table). So if to names were created in january the sum i 2, if no names were created in february total number is still 2, one was created in march so total number now is 3, and so on....</P><P>Month name | Number of names</P><P>      January     |  2</P><P>      February   |  2</P><P>      March       |  3</P><P>Is there a wasy to do this?</P><P>Thanks!</P> Wed, 27 Aug 2025 10:44:12 GMT Suman8877 2025-08-27T10:44:12Z ON date finding Cummulative Number... https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/ON-date-finding-Cummulative-Number/m-p/4809018#M183910 <P>Is there way to calculate cummulative number of occurences based on the date coulmn.</P><P>For example:</P><P>In one table i have the information when something was created:</P><P>    date       |  name</P><P>1/1/2025    |  abc</P><P>12/1/2025  |  osks</P><P>13/3/2025  |   doferf</P><P>and in the second one i want to have a number of "names" by month name (lets assume i have a Date table with month names related with the first table). So if to names were created in january the sum i 2, if no names were created in february total number is still 2, one was created in march so total number now is 3, and so on....</P><P>Month name | Number of names</P><P>      January     |  2</P><P>      February   |  2</P><P>      March       |  3</P><P>Is there a wasy to do this?</P><P>Thanks!</P> Wed, 27 Aug 2025 10:44:12 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/ON-date-finding-Cummulative-Number/m-p/4809018#M183910 Suman8877 2025-08-27T10:44:12Z Re: ON date finding Cummulative Number... https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/ON-date-finding-Cummulative-Number/m-p/4809023#M183912 <P>Hi <a href="javascript:void(0)" data-lia-user-mentions="" data-lia-user-uid="1339716" data-lia-user-login="Suman8877" class="lia-mention lia-mention-user">Suman8877</a> <BR /><BR /></P> <P>You can do this with a cumulative (running total) measure in DAX. Here’s one simple way:</P> <P>1. Make sure you have a proper Date table in your model and relate it to your fact table [Date].</P> <P> </P> <P>2. Create a base count measure:</P> <LI-CODE lang="markup">Rows Count = COUNTROWS ( Events )</LI-CODE> <P> </P> <P>3. Then create the cumulative measure:</P> <LI-CODE lang="markup">Cumulative Names = CALCULATE ( [Rows Count], DATESYTD ( 'Date'[Date] ) )</LI-CODE> <P> </P> <P>4. Put Year and Month Name from your Date table on rows, and use Cumulative Names as the value.</P> <P><LI-WRAPPER></LI-WRAPPER></P> Wed, 27 Aug 2025 10:48:58 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/ON-date-finding-Cummulative-Number/m-p/4809023#M183912 rohit1991 2025-08-27T10:48:58Z Re: ON date finding Cummulative Number... https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/ON-date-finding-Cummulative-Number/m-p/4809029#M183913 <P>this is very simple,</P><P>here is my file for you:</P><P> </P><P><A href="https://drive.google.com/drive/folders/1DmxrAG-Ow0X5XuCWUq3f8fGATFqblxfs?usp=sharing" target="_blank">https://drive.google.com/drive/folders/1DmxrAG-Ow0X5XuCWUq3f8fGATFqblxfs?usp=sharing</A></P><P> </P><P> </P><P> </P><P>here  is the result based on the below data I invented</P><P> </P><P><img /></P><P> </P><P> </P><P><img /></P><P> </P><P>If this helped, please consider giving kudos and mark as a solution</P><P><STRONG><a href="javascript:void(0)" data-lia-user-mentions="" data-lia-user-uid="273" data-lia-user-login="me" class="lia-mention lia-mention-user">me</a>in replies or I'll lose your thread</STRONG></P><P>Want to check your DAX skills? <A href="https://www.linkedin.com/company/kubisco/" target="_blank" rel="noopener">Answer my biweekly DAX challenges on the kubisco Linkedin page</A></P><P>Consider voting <A href="https://community.fabric.microsoft.com/t5/Fabric-Ideas/Power-BI-Filter-Pane-as-an-icon-on-the-right-side-bar-in-on/idi-p/4728588" target="_blank" rel="noopener">this Power BI idea</A></P><P><STRONG>Francesco Bergamaschi</STRONG></P><P>MBA, M.Eng, M.Econ, Professor of BI</P> Wed, 27 Aug 2025 10:51:59 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/ON-date-finding-Cummulative-Number/m-p/4809029#M183913 FBergamaschi 2025-08-27T10:51:59Z Re: ON date finding Cummulative Number... https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/ON-date-finding-Cummulative-Number/m-p/4809062#M183914 <P>Hi <a href="javascript:void(0)" data-lia-user-mentions="" data-lia-user-uid="1287762" data-lia-user-login="FBergamaschi" class="lia-mention lia-mention-user">FBergamaschi</a> </P><P> </P><P>The solution posted just shows count of names per month (Jan = 2, Mar = 3, Apr = 1, etc.). That’s only a monthly count, not cumulative.</P> Wed, 27 Aug 2025 11:23:00 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/ON-date-finding-Cummulative-Number/m-p/4809062#M183914 Suman8877 2025-08-27T11:23:00Z Re: ON date finding Cummulative Number... https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/ON-date-finding-Cummulative-Number/m-p/4809091#M183915 <P>Updated, sorry I forgot the YTD part</P><P> </P><P><A href="https://drive.google.com/drive/folders/1DmxrAG-Ow0X5XuCWUq3f8fGATFqblxfs?usp=sharing" target="_blank">https://drive.google.com/drive/folders/1DmxrAG-Ow0X5XuCWUq3f8fGATFqblxfs?usp=sharing</A></P><P> </P><P><img /></P><P> </P><P>If this helped, please consider giving kudos and mark as a solution</P><P><STRONG><a href="javascript:void(0)" data-lia-user-mentions="" data-lia-user-uid="273" data-lia-user-login="me" class="lia-mention lia-mention-user">me</a> in replies or I'll lose your thread</STRONG></P><P>Want to check your DAX skills? <A href="https://www.linkedin.com/company/kubisco/" target="_blank">Answer my biweekly DAX challenges on the kubisco Linkedin page</A></P><P>Consider voting <A href="https://community.fabric.microsoft.com/t5/Fabric-Ideas/Power-BI-Filter-Pane-as-an-icon-on-the-right-side-bar-in-on/idi-p/4728588" target="_blank">this Power BI idea</A></P><P><STRONG>Francesco Bergamaschi</STRONG></P><P>MBA, M.Eng, M.Econ, Professor of BI</P> Wed, 27 Aug 2025 12:06:29 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/ON-date-finding-Cummulative-Number/m-p/4809091#M183915 FBergamaschi 2025-08-27T12:06:29Z