Show me everything between Saturday & Sunday dates.

[JayTG123]

Hi all,

I have start and end dates in my raw data. I am looking for a way in which Power Bi can show me everything that took place between weekends (a Saturday & Sunday). Is this achiveable  ? I need to get totals.

Screenshot attached is raw data with start and end dates. Everything that hasnt had a start or end date is showing in Power Bi as 01/01/9999 - these all need to be excluded. 

Any help is appreciated.

Jay.

[v-kkf-msft · Accepted solution]

Hi @JayTG123 ,

I am not sure if I understood your question correctly. If you want to calculate that the start and end dates fall within the same week and on weekends, then please try the following calculated column.

IsInWeekends = 
IF (
    WEEKDAY ( [actual_start_date], 1 )
        IN { 6, 7 }
            && WEEKDAY ( [actual_end_date], 1 )
                IN { 6, 7 }
                    && DATEDIFF ( [actual_start_date], [actual_end_date], DAY ) <= 1
                    && [actual_start_date] <> dt"9999-1-1",
    1
)

If the problem is still not resolved, please provide detailed error information or the expected result you expect. Let me know immediately, looking forward to your reply.
Best Regards,
Winniz
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[JayTG123]

Thank you so much @v-kkf-msft !! this has worked!!!! 

Apologies for the late response... I have been on paternity leave. 

Thanks again.
Jay

[Arul]

@JayTG123 ,

try this in measure and let me know,

Total on Weekends = 
CALCULATE(SUM(financials[ Sales]),
OR(WEEKDAY(actual_start_date)=6,WEEKDAY(actual_start_date)=7),
OR(WEEKDAY(actual_end_date)=6,WEEKDAY(actual_end_date)=7))

Thanks,

Arul