Forum Discussion
Consecutive status count
I have a table with the status of my clients of all the months, what I would like is to be able to make a measure to calculate how many average months they last with x status, either active or inacti...
but the provided sample data does not reflect this scenario. Please provide relevant sample data thatt reflects different possible scenarios in order to provide appropriate solution
In this case I just want to calculate the active time the id 6 should throw me 3, the id 41 should throw me 3 also although since it is the longer than hard time active and so on.
| idsocio | Status | Partner Type | My | Year |
| 6 | Active | Benef.Familiar - Pri | January | 2022 |
| 6 | Active | February | 2022 | |
| 6 | Active | March | 2022 | |
| 6 | Inactive | Benef.Familiar - Pri | April | 2022 |
| 6 | Active | May | 2022 | |
| 41 | Active | Principa Diplomat | January | 2022 |
| 41 | Active | Benef.Familiar - Pri | February | 2022 |
| 41 | Inactive | Benef.Familiar - Pri | March | 2022 |
| 41 | Active | April | 2022 | |
| 41 | Active | Benef.Familiar - Pri | May | 2022 |
| 41 | Active | Benef.Familiar - Pri | June | 2022 |
| 155 | Active | Benef.Familiar - Pri | April | 2022 |
| 155 | Active | Benef.Familiar - Sec | May | 2022 |
| 248 | Active | Benef.Familiar - Pri | April | 2022 |
| 248 | Inactive | Benef.Familiar - Pri | May | 2022 |
| 301 | Active | Benef.Familiar - Pri | April | 2022 |
| 301 | Active | Benef.Familiar - Pri | May | 2022 |
| 375 | Active | Benef.Familiar - Sec | April | 2022 |
| 375 | Active | Benef.Familiar - Pri | May | 2022 |