Forum Discussion

Suman8877's avatar
Suman8877
Advocate II
1 year ago
Solved

ON date finding Cummulative Number...

Is there way to calculate cummulative number of occurences based on the date coulmn. For example: In one table i have the information when something was created:     date       |  name 1/1/2025  ...
  • rohit1991's avatar
    rohit1991
    1 year ago

    Hi Suman8877 

    You can do this with a cumulative (running total) measure in DAX. Here’s one simple way:

    1. Make sure you have a proper Date table in your model and relate it to your fact table [Date].

     

    2. Create a base count measure:

    Rows Count =
COUNTROWS ( Events )

     

    3. Then create the cumulative measure:

    Cumulative Names =
CALCULATE (
   [Rows Count],
   DATESYTD ( 'Date'[Date] )
)

     

    4. Put Year and Month Name from your Date table on rows, and use Cumulative Names as the value.

FBergamaschi's avatar
FBergamaschi
Super User
1 year ago

this is very simple,

here is my file for you:

 

https://drive.google.com/drive/folders/1DmxrAG-Ow0X5XuCWUq3f8fGATFqblxfs?usp=sharing

 

 

 

here  is the result based on the below data I invented

 

 

 

 

If this helped, please consider giving kudos and mark as a solution

mein replies or I'll lose your thread

Want to check your DAX skills? Answer my biweekly DAX challenges on the kubisco Linkedin page

Consider voting this Power BI idea

Francesco Bergamaschi

MBA, M.Eng, M.Econ, Professor of BI

Suman8877's avatar
Suman8877
Advocate II
1 year ago

Hi FBergamaschi 

 

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.