Hello All,
I have a requriement to create a measure to calculate the count the accounts which has 2 or more consecutive bill months.
Please help me in getting the total of count of account which has the consective month bills
I would appreciate any help on achieving this. Also, please let me know if you need any further information from my end.
Example:
The total count i expected to get from the table below is 6.
Account 11234 has consective bills in Dec-18 to Jan-19, Mar-19 to Apr 19. This account doesn't have bill in the month of Feb-19
So the count for Account 11234 is 2 (1 for Dec-18 & Jan-19, 1 for Mar-19 & Apr 19).
Account 87239 has consective bills in Dec-18 to Mar-19 , May-19 to Jun-19. This account doesn't have bill in the month of Apr-19
So the count for Account 87239 is 2 (1 for Dec-18 to Mar-19, 1 for May-19 to Jun-19).
Account 54327 has consective bills in Jan-19 to Feb-19 , Apr-19 to Jun-19. This account doesn't have bill in the month of Mar-19
So the count for Account 54327 is 2 (1 for Jan-19 to Feb-19 , 1 for Apr-19 to Jun-19)
| Account | Bill Month |
| 11234 | Dec-18 |
| 11234 | Jan-19 |
| 11234 | Mar-19 |
| 11234 | Apr-19 |
| 87239 | Dec-18 |
| 87239 | Jan-19 |
| 87239 | Feb-19 |
| 87239 | Mar-19 |
| 87239 | May-19 |
| 87239 | Jun-19 |
| 54327 | Jan-19 |
| 54327 | Feb-19 |
| 54327 | Apr-19 |
| 54327 | May-19 |
| 54327 | Jun-19 |
Thank you!!
