Day to day Difference

[Avermaak]

Good day, 

I am trying to calculate the day to day difference based on weekdays only, for my daily banking movement. 

I have would like the table to look as follows:

I used the following formula to calculate the difference but it does not take into account the weekends, how can I change my formula to exclude the weekends from the calculations and only base it on weekdays.

Movement =

VAR __PREV_DAY =

    CALCULATE(

        SUM('BST_INPUT'[Per Collect]),

        DATEADD('BST_INPUT'[Date],1,DAY)

    )

RETURN

    SUM('BST_INPUT'[Per Collect]) - __PREV_DAY

[IIPowerBlog]

Hello. Try adding the WEEKDAY function to your formula, https://learn.microsoft.com/en-us/dax/weekday-function-dax