79653329

Date: 2025-06-04 18:44:13
Score: 1.5
Natty:
Report link
Running total = 
CALCULATE(
    SUM('ProjectHours'[ModelHours]),
    FILTER(
        'ProjectHours',
        'ProjectHours'[ConsultantId] = EARLIER('ProjectHours'[ConsultantId]) &&
        'ProjectHours'[WeekStart] <= EARLIER('ProjectHours'[WeekStart])
    )
)
This fixed my issue! 
Reasons:
  • Low length (0.5):
  • Has code block (-0.5):
  • Self-answer (0.5):
  • Low reputation (1):
Posted by: Colin Mulcahy