Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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/2016 | abc
12/1/2016 | osks
13/3/2016 | doferf
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....
Month name | Number of names
January | 2
February | 2
March | 3
Is there a wasy to do this?
Thanks!
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] ))))
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
47 | |
24 | |
20 | |
15 | |
12 |
User | Count |
---|---|
55 | |
48 | |
43 | |
19 | |
18 |