DAX and Filters

[PhineasT]

I'm a seeking input on 'best practices' for getting to the following -

I have loaded an Excel table to PowerBI desktop.

I've created a few measures (Average Wait Time, Average Number of Incidences).

I've created a Table for time based on  - Solved: Slicer with time - Microsoft Power BI Community

Function Need:
The average wait-time for a day of the week.
       - For example, the wait-time for every Monday for specific month, for quarter, year, year-over-year for four consecutive years.

A filter for average 'Wait-Time' for a specific day.
       - For example, if I want to know the wait-time for every December 31 or a given year, and December 31 looking back over all
         years.

Identify outliers such as holidays, super bowl, that may impact 'Wait-Time'.

I can start with a card with the aveerage 'Wait-Time' in it. I chart/graph is also desired.

[lbendlin]

The beauty of measures is that they work for the "current filter context".  So one measure can cover all these variations.

Please provide sample data that covers your issue or question completely, in a usable format (not as a screenshot).
https://community.powerbi.com/t5/Community-Blog/How-to-provide-sample-data-in-the-Power-BI-Forum/ba-...
Please show the expected outcome based on the sample data you provided.

https://community.powerbi.com/t5/Desktop/How-to-Get-Your-Question-Answered-Quickly/m-p/1447523

[PhineasT]

Please see my new post for additional information on the request.

[lbendlin]

Please include the link.

[PhineasT]

Link -
https://community.powerbi.com/t5/Desktop/Create-Date-Time-and-Shortest-Wait-Time-Measures/m-p/321234...