Calculating Sum between 2 dates excluding weekends

Hi Grimfandango227 ,

I'm sorry I misunderstood you before, your requirement is to calculate the value of 7 consecutive working days, for not the value of 7 consecutive days that are working days. Let's start again.

My date today is March 7th.

The Table data is shown below:

Please follow these steps:
1. Use the following DAX expression to create a table named ‘Table’

Table = CALENDAR(DATE(2024,1,1),DATE(2024,12,31)) 

2. Use the following DAX expression to create a column named ‘IsWeekend’ in ‘Table’

IsWeekend = IF(WEEKDAY('Table'[Date],2)>5,TRUE(),FALSE())

3. Use the following DAX expression to create a table named ‘Table2’

Table 2 = FILTER('Table','Table'[IsWeekend] = FALSE())

4. Use the following DAX expression to create a column named ‘Column’ in ‘Table2’

Column = COUNTROWS('Table 2') - RANKX(ALL('Table 2'), 'Table 2'[Date],,DESC) + 1

5. Use the following DAX expression to create a table named ‘Table3’

Table 3 = FILTER('Table 2','Table 2'[Date] >= TODAY() )

6. Use the following DAX expression to create a table named ‘Table4’

Table 4 = FILTER('Table 3','Table 3'[Column] = MINX('Table 3',[Column] + 6))

7. Use the following DAX expression to create a measure named ‘SevenWorkDay’

SevenWorkDay = 
VAR StartDate = TODAY()
VAR EndDate = MAXX(FILTER('Table 3','Table 3'[Column] = MINX('Table 3',[Column] + 6)),[Date])
RETURN 
CALCULATE(SUM('DOMO_Sales_Line'[Outstanding]),'Table'[Date] >= StartDate && 'Table'[Date] <= EndDate,'Table'[IsWeekend] = FALSE())

8. The model relationships are as follows:

9. Fianl output

I've uploaded my test file so you can check it out.

Best Regards,
Wenbin Zhou
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.