Filtering Sales Data Between Friday 5pm - Monday 4am

Hi bmccaslin please check this

Create a calculated column

Hi bmccaslin,
Thank you for reaching out to the Microsoft fabric community forum. Thank you techies, for your inputs on this issue.

Calculated Column:

IsWeekendSalesWindow =

VAR WeekdayNumber = WEEKDAY(Sales[SalesDateTime], 2)  -- Monday=1, Sunday=7

VAR TimeOnly = TIME(HOUR(Sales[SalesDateTime]), MINUTE(Sales[SalesDateTime]), SECOND(Sales[SalesDateTime]))

RETURN

    SWITCH(TRUE(),

        -- Friday after 5 PM

        WeekdayNumber = 5 && TimeOnly >= TIME(17,0,0), TRUE,

        -- Saturday anytime

        WeekdayNumber = 6, TRUE,

        -- Sunday anytime

        WeekdayNumber = 7, TRUE,

        -- Monday before 4 AM

        WeekdayNumber = 1 && TimeOnly < TIME(4,0,0), TRUE,

        FALSE

    )

Dax Measure:

SalesOutsideWeekendWindow =
CALCULATE(
SUM(Sales[SalesAmount]),
FILTER(
Sales,
NOT (
VAR WeekdayNumber = WEEKDAY(Sales[SalesDateTime], 2)
VAR TimeOnly = TIME(HOUR(Sales[SalesDateTime]), MINUTE(Sales[SalesDateTime]), SECOND(Sales[SalesDateTime]))
RETURN
SWITCH(TRUE(),
WeekdayNumber = 5 && TimeOnly >= TIME(17,0,0),
TRUE(),
WeekdayNumber = 6,
TRUE(),
WeekdayNumber = 7,
TRUE(),
WeekdayNumber = 1 && TimeOnly < TIME(4,0,0),
TRUE(),
FALSE()
)
)
)
)

If this post helps, then please give us ‘Kudos’ and consider Accept it as a solution to help the other members find it more quickly.

Thank you for using Microsoft Community Forum.