Skip to main content
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 

The Power BI Data Visualization World Championships is back! Get ahead of the game and start preparing now! Learn more

Reply
Syndicate_Admin
Administrator
Administrator

Consecutive status count

‎06-24-2022 05:40 AM

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 inactive and that only brings me the largest number of months not a sum over time

dventura_0-1656074358654.png

Message 1 of 9
679 Views
0
8 REPLIES 8
tamerj1
Super User
Super User

‎06-25-2022 09:30 AM

Sorry @dventura 
I got little confused. Would you please provide the expected reaults out of the same sample data?

Message 6 of 9
629 Views
0
Syndicate_Admin
Administrator
Administrator
In response to tamerj1

‎07-11-2022 09:09 AM

For example, if I have an active client for 5 months but only 3 of those were consecutive i.e. (January, February, March, July and August) the result I expect is 3.

Message 7 of 9
600 Views
tamerj1
Super User
Super User
In response to Syndicate_Admin

‎07-11-2022 08:37 PM

@Syndicate_Admin , @dventura 

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 

Message 8 of 9
591 Views
0
Syndicate_Admin
Administrator
Administrator
In response to tamerj1

‎07-13-2022 05:37 AM

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.

idsocioStatusPartner TypeMyYear
6ActiveBenef.Familiar - PriJanuary2022
6Active February2022
6Active March2022
6InactiveBenef.Familiar - PriApril2022
6Active May2022
41ActivePrincipa DiplomatJanuary2022
41ActiveBenef.Familiar - PriFebruary2022
41InactiveBenef.Familiar - PriMarch2022
41Active April2022
41ActiveBenef.Familiar - PriMay2022
41ActiveBenef.Familiar - PriJune2022
155ActiveBenef.Familiar - PriApril2022
155ActiveBenef.Familiar - SecMay2022
248ActiveBenef.Familiar - PriApril2022
248InactiveBenef.Familiar - PriMay2022
301ActiveBenef.Familiar - PriApril2022
301ActiveBenef.Familiar - PriMay2022
375ActiveBenef.Familiar - SecApril2022
375ActiveBenef.Familiar - PriMay2022
Message 9 of 9
587 Views
0
tamerj1
Super User
Super User

‎06-24-2022 05:46 AM

Hi Admin @Syndicate_Admin  Hi @dventura 
Please provide sample dummy data to work with. Thank you

Message 2 of 9
672 Views
0
Syndicate_Admin
Administrator
Administrator
In response to tamerj1

‎06-24-2022 06:03 AM
idsocioStatusPartner TypeDateMy
6InactiveBenef.Familiar - PriSaturday, May 30, 2022April
11Inactive Saturday, May 30, 2022April
22Inactive Saturday, May 30, 2022April
24InactiveBenef.Familiar - PriSaturday, May 30, 2022April
31Inactive Saturday, May 30, 2022April
41InactiveDiplomat PrincipaSaturday, May 30, 2022April
42InactiveBenef.Familiar - PriSaturday, May 30, 2022April
45InactiveBenef.Familiar - PriSaturday, May 30, 2022April
70Inactive Saturday, May 30, 2022April
76InactiveBenef.Familiar - PriSaturday, May 30, 2022April
104InactiveBenef.Familiar - PriSaturday, May 30, 2022April
155ActiveBenef.Familiar - PriSaturday, May 30, 2022April
222ActiveBenef.Familiar - SecSaturday, May 30, 2022April
248ActiveBenef.Familiar - PriSaturday, May 30, 2022April
287ActiveBenef.Familiar - PriSaturday, May 30, 2022April
301ActiveBenef.Familiar - PriSaturday, May 30, 2022April
316ActiveBenef.Familiar - PriSaturday, May 30, 2022April
335ActiveBenef.Familiar - SecSaturday, May 30, 2022April
375ActiveBenef.Familiar - PriSaturday, May 30, 2022April

@Syndicate_Admin

Message 5 of 9
663 Views
0
dventura
Frequent Visitor
In response to tamerj1

‎06-24-2022 06:01 AM
idsocioEstatusTipo SocioFechaMes
6InactivoBenef.Familiar - PriSaturday, May 30, 2022April
11Inactivo Saturday, May 30, 2022April
22Inactivo Saturday, May 30, 2022April
24InactivoBenef.Familiar - PriSaturday, May 30, 2022April
31Inactivo Saturday, May 30, 2022April
41InactivoDiplomatico PrincipaSaturday, May 30, 2022April
42InactivoBenef.Familiar - PriSaturday, May 30, 2022April
45InactivoBenef.Familiar - PriSaturday, May 30, 2022April
70Inactivo Saturday, May 30, 2022April
76InactivoBenef.Familiar - PriSaturday, May 30, 2022April
104InactivoBenef.Familiar - PriSaturday, May 30, 2022April
155ActivoBenef.Familiar - PriSaturday, May 30, 2022April
222ActivoBenef.Familiar - SecSaturday, May 30, 2022April
248ActivoBenef.Familiar - PriSaturday, May 30, 2022April
287ActivoBenef.Familiar - PriSaturday, May 30, 2022April
301ActivoBenef.Familiar - PriSaturday, May 30, 2022April
316ActivoBenef.Familiar - PriSaturday, May 30, 2022April
335ActivoBenef.Familiar - SecSaturday, May 30, 2022April
375ActivoBenef.Familiar - PriSaturday, May 30, 2022April

@Syndicate_Admin 

Message 3 of 9
667 Views
tamerj1
Super User
Super User
In response to dventura

‎06-24-2022 06:06 AM

Thank you @dventura 
Sorry I have to leave now as already late afternoon over here. I will get back to you max by Monday morning.

Message 4 of 9
662 Views
0

Helpful resources

Announcements
Power BI DataViz World Championships

Power BI Dataviz World Championships

The Power BI Data Visualization World Championships is back! Get ahead of the game and start preparing now!

December 2025 Power BI Update Carousel

Power BI Monthly Update - December 2025

Check out the December 2025 Power BI Holiday Recap!

FabCon Atlanta 2026 carousel

FabCon Atlanta 2026

Join us at FabCon Atlanta, March 16-20, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.

View All