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.
VAR __PREV_DAY =
SUM('BST_INPUT'[Per Collect]) - __PREV_DAY