Forum Discussion

toball's avatar
toball
Regular Visitor
6 years ago
Solved

Running Total - Two dates - Received and Completed

Hi all,   Looking to replicate the second list in my attachment in Power BI running total or waterfall chart, I just cannot get my head around how to do this but know it must be simple!    Compan...
Need Help
  • Anonymous's avatar
    Anonymous
    6 years ago

    If we exclude those null entries directly in the Work Completed Sum, does that help?

    Work Completed Sum = CALCULATE(
    [Work Received Sum],
    USERELATIONSHIP(JobList[Date Completed], Dates[Date]),
    NOT(ISBLANK(JobList[Date Completed]))
)

    (I don't have my quick sample project, so i haven't tested out this code)

Anonymous's avatar
Anonymous
Not applicable
6 years ago

If we exclude those null entries directly in the Work Completed Sum, does that help?

Work Completed Sum = CALCULATE(
    [Work Received Sum],
    USERELATIONSHIP(JobList[Date Completed], Dates[Date]),
    NOT(ISBLANK(JobList[Date Completed]))
)

(I don't have my quick sample project, so i haven't tested out this code)

toball's avatar
toball
Regular Visitor
6 years ago

Awesome - works great now! Thanks so much Ross - appreciate the quick responses.