Showing results for 
Search instead for 
Did you mean: 
Frequent Visitor

Average days in Phase

I have the tablex with the columns date (daily), name_id and phases. Each row corresponds a day, name_id and phase. I would like to create a measure that counts how many days on average a name_id stays in a phase (important to calculate just for the ones who have more than one phase registered).

In the sample bellow it should calculated for name_id  "d567" from the phase "Middle" until the first day "Premium" appears.


Thank you 

Community Champion
Community Champion

hi @Priscila_Gr 

average can be very different. please help post some sample data with expected result to help those who might help you. 

Thank you. I edited 

hi @Priscila_Gr 

Great. And what about the result? How will it look like?

In this case 2 days, so 2 as result. When I have several name_id that progressed badges the average time among them

hi @Priscila_Gr 

not sure if fully get you, you may try to plot a visual with name and phase column with a measure like:


Helpful resources

Join Arun Ulag at MPPC23

Join Arun Ulag at MPPC23

Get a sneak peek into this year's Power Platform Conference Keynote.

PBI Sept Update Carousel

Power BI September 2023 Update

Take a look at the September 2023 Power BI update to learn more.

Learn Live

Learn Live: Event Series

Join Microsoft Reactor and learn from developers.

Dashboard in a day with date

Exclusive opportunity for Women!

Join us for a free, hands-on Microsoft workshop led by women trainers for women where you will learn how to build a Dashboard in a Day!

Top Solution Authors
Top Kudoed Authors