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
