Day to day Difference

Question

Good day,&nbsp;&nbsp;I am trying to calculate the day to day difference based on weekdays only, for my daily banking movement.&nbsp;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.&nbsp;Movement = VAR __PREV_DAY =&nbsp;&nbsp;&nbsp;&nbsp;CALCULATE(&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;SUM('BST_INPUT'[Per Collect]),&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;DATEADD('BST_INPUT'[Date],1,DAY)&nbsp;&nbsp;&nbsp;&nbsp;)RETURN&nbsp;&nbsp;&nbsp;&nbsp;SUM('BST_INPUT'[Per Collect]) - __PREV_DAY

iipowerblog · Answer

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

Forum Discussion

Day to day Difference

1 Reply

Related content

Negative difference in Days

Day to Day average

Data Days | Data Days Your Way

Text Differences from day to day

Data Days | Create