Measure to Count Consecutive Days

[chathacc]

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

[Fowmy]

@chathacc 

Can you provide the expected outcome based on the sample data you have shown?

________________________

If my answer was helpful, please click Accept it as the solution to help other members find it useful

Click on the Thumbs-Up icon if you like this reply 🙂

Website YouTube  LinkedIn

[chathacc]

I am trying to get the Number of Consecutive column. And then I will use that to make a bar chart. 

[amitchandak]

@chathacc , I have a blog where I approached this a new column for two dates. See if that can help you

https://community.powerbi.com/t5/Community-Blog/Power-BI-Continuous-Streak-With-One-Day-Break/ba-p/1...