Thank you for posting your query onto the Forum.
Firstly, I’d set up a Date Table in your model. Below is the screenshot provided for the reference -
And then here’s the formula that I’ve used to calculate the “Total Actual Revenue” for weekly sales.
Total Actual Non Weekend Days =
VAR WeekendCheck = SELECTEDVALUE( Dates[Day Type] ) = "Weekend"
VAR WorkdayCheck = SELECTEDVALUE( Dates[DayOfWeekName] ) = "Monday"
IF( WeekendCheck = TRUE, BLANK(),
IF( WorkdayCheck = FALSE,
CALCULATE( [Total Actual],
FILTER( ALL( Dates ),
Dates[Date] > MIN( Dates[Date] ) - 3 && Dates[Date] <= MIN( Dates[Date] ) ) ) ) )
Below is the screenshot of the result provided for the reference -
I’m also attaching the working of the PBIX file for the reference. Also providing the link of a video below where Sam has covered this concept.
Hoping you find this useful and meets your requirements.
Thanks and Warm Regards,
RECEIVABLES TEST DASH.pbix (258.0 KB)