Finding an AVG of MINX results

[eburg]

Hello, 

Looking for advice on how to get an average of daily minimum results. I have starting times i.e. 5am, 4am, etc. for each day in a table. I can use MINX to find the earliest time starting for each day and it returns the desired results. Now I'm looking to take an average of those MINX results to get the AVG start time across a month, period, etc. Thanks for any help!

[Jihwan_Kim]

Hi, @eburg 

If it is OK with you, please share the sample data or sample pbix file. Then it might help me to understand more clearly and try to create a measure.

Thank you very much.

[eburg]

The data looks like this. So if I create a measure Minx(Table, Start Time) it returns 5:00AM for this date 12/4/2020. So it looks like the same things across all dates. Looking to get an average of each of those Minx results across the month. 

[Jihwan_Kim · Accepted solution]

Hi, @eburg 

Please check the below picture whether I understood correctly.

The first column is the year-quarter-month-week-date hierarchy column

The second column is Minimum time among all dates inside the hierarchy selection. If a date is selected, then it shows the minimum time among the many of a specific date. If a month is selected, then it shows the minimum time among the many of the days in the same month.

The third column is Average of each date's minimum time by shown period.

Min Time by day(s) =

MINX(Data, Data[StartTime])

Avg Min Time by period =

VAR newtable =

SUMMARIZE ( Data, Data[Date], "@mintime", [Min Time by day(s)] )

RETURN

FORMAT ( AVERAGEX ( newtable, [@mintime] ), "h:nn AM/PM" )

Did I answer your question? Mark my post as a solution!
In doing so, you are also helping me. Thank you!