Count of Repeated ID

[nguyendaithang]

I. QUESTION

I am looking for a DAX formula that return me the number of ID which appear in 2,3,4......consecutive months

ID    Month

A1       1/1/2018

A2      1/3/2018     

A3      1/15/2018

A4      2/1/2018

A1      2/4/2018

A5      2/14/2018  

A3       2/15/2018

A1       3/1/2018

A4       1/3/2018

II. RESULT

So the result I want as belows:

1. The number of ID which appear in 2 consecutive months: 1 & 2/2018 is 2 (A1 & A3)

ID         Month

A1       1/1/2018

A3      1/15/2018

A1      2/4/2018

A3       2/15/2018

2. The number of ID which appear in 3 consecutive months: 1, 2 & 3/2018 is 1 (A1)

ID         Month

A1       1/1/2018

A1      2/4/2018

A1       3/1/2018

[v-chuncz-msft]

@nguyendaithang,

You may check if the following post helps.

https://community.powerbi.com/t5/Desktop/Find-min-date-where-continuous-8-rows-of-data-in-the-calcul...