Microsoft Fabric Community Conference 2025, March 31 - April 2, Las Vegas, Nevada. Use code FABINSIDER for a $400 discount.
Register nowThe Power BI DataViz World Championships are on! With four chances to enter, you could win a spot in the LIVE Grand Finale in Las Vegas. Show off your skills.
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
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
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:
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount!
Check out the February 2025 Power BI update to learn about new features.
User | Count |
---|---|
25 | |
12 | |
9 | |
9 | |
9 |
User | Count |
---|---|
21 | |
14 | |
14 | |
13 | |
13 |