Showing rows that are above or below a average time stamp.

[Ratso]

Hi,

I hope someone can help me as I have been playing around with this for a couple of weeks now to no avail.

I have a measure that works out the average time of a start and end time from a column called TIME_STAMP

Average Time_Stamp = FORMAT(AVERAGE(Sheet1[TIME_STAMP]),"hh:mm:ss")

I also have another column called FIRST_LAST which has the comment FIRST INVOICE for the first invoice of the day and LAST INVOICE when it is the last invoice of the day

This is then displayed on a table visual with a filter that  hides the blanks

What I am trying to achieve is to add a new measure that will populate a new table visualisation for anything exceeding the average of a FIRST INVOICE and less than the average of LAST INVOICE.

I kind of got this far with FIRST INVOICE but it is showing me everything that has FIRST INVOICE in the adjacent column when I only want to see data that is greater than the average FIRST INVOICE time stamp

Filter_First =

VAR FirstInvoice=

CALCULATE(

    [Average Time_Stamp],

    Sheet1[FIRST_LAST]="FIRST INVOICE"  

)

RETURN

FirstInvoice

I have also applied a filter to show the FIRST INVOICE only

So in theroy, I only want the visual to show the below as it exceeds the FIRST INVOICE average time 08:34:11

I also need the same for LAST INVOICE below the average LAST INVOICE time of 15:17:54.

Can this be done?

Apologies for the long winded explanation, I'm pretty wet behind the ears regarding DAX and Power query as I am old school excel and VBA.

Any help would be greatly appreciated.

[lbendlin]

Please provide sample data that covers your issue or question completely, in a usable format (not as a screenshot).

Do not include sensitive information or anything not related to the issue or question.

If you are unsure how to upload data please refer to https://community.fabric.microsoft.com/t5/Community-Blog/How-to-provide-sample-data-in-the-Power-BI-...

Please show the expected outcome based on the sample data you provided.

Want faster answers? https://community.fabric.microsoft.com/t5/Desktop/How-to-Get-Your-Question-Answered-Quickly/m-p/1447...