Forum Discussion
Measure to Count Consecutive Days
I am hoping someone can help me identify a way to create a measure that can identify the number of consecutive date/time stamps that occur for a given account. I am hoping to create a bar chart that shows the number of accounts for consecutive days. I have reviewed other cases, but I am having trouble editing the dax for what I need. Any assitance that can be provided is appreciated.
| Date/Tm | Account | Number of Consecutive |
| 1/1/2020 16:58:32 | 1334892 | 0 |
| 11/2/2020 7:27:26 | 8317404 | 3 |
| 11/3/2020 6:09:20 | 8317404 | 3 |
| 11/4/2020 7:43:10 | 8317404 | 3 |
| 9/2/2020 7:26:08 | 9083147 | 2 |
| 9/2/2020 19:06:08 | 9083147 | 2 |
| 4/2/2020 7:24:57 | 9873238 | 4 |
| 4/3/2020 6:50:36 | 9873238 | 4 |
| 4/4/2020 7:43:10 | 9873238 | 4 |
| 4/5/2020 8:52:54 | 9873238 | 4 |
3 Replies
chathacc , I have a blog where I approached this a new column for two dates. See if that can help you
I am trying to get the Number of Consecutive column. And then I will use that to make a bar chart.
