Filter on last day starting from 6AM till 6AM

[Hyperchef1969]

Hi,

I have a column with start dates and times. I want to create a page filter which always shows the start times of the last 24 hours, starting from 6AM previous day, till 6AM current day. Every day I need to send an autmatic email at 7 AM with the related lines of the previous 24 hours. Any assistance? I am working on direct query mode.

[Anonymous · Accepted solution]

@Hyperchef1969 ,

Create a calcualated column in your table

Check = 
IF (
    AND (
        Table1[DateTime]
            >= (
                TODAY () + TIME ( 6, 0, 0 ) - 1
            ),
        Table1[DateTime]
            <= (
                TODAY () + TIME ( 6, 0, 0 ) - 1
            ) + 1
    ),
    1,
    0
)

Use this as Page Level Filter 

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.