Forum Discussion

IvanMislav's avatar
IvanMislav
Icon for Helper I rankHelper I
9 years ago

Cummulative number based on the date

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/...
gareta's avatar
gareta
Frequent Visitor
9 years ago

I'm still learning and believe this can be done w/ powerbi's date functions like EARLIER and PAST. But in my case I needed a to do this with a non-date type so I came to something like this:

 

Measure = IF( HASONEVALUE( Table1[date] ), CALCULATE( DISTINCTCOUNT([name]), FILTER( ALLSELECTED(Table1[date]), [date] <= VALUES( Table1[date] ))))