topic Re: Average days in Phase in DAX Commands and Tips

Average days in Phase

Anonymous — Thu, 02 Mar 2023 09:48:26 GMT

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

Re: Average days in Phase

FreemanZ — Thu, 02 Mar 2023 09:38:13 GMT

hi Anonymous

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

Re: Average days in Phase

Anonymous — Thu, 02 Mar 2023 09:48:45 GMT

Thank you. I edited

Re: Average days in Phase

FreemanZ — Thu, 02 Mar 2023 10:30:32 GMT

hi Anonymous

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

Re: Average days in Phase

Anonymous — Thu, 02 Mar 2023 10:39:57 GMT

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

Re: Average days in Phase

FreemanZ — Thu, 02 Mar 2023 12:12:37 GMT

hi Anonymous

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