Forum Discussion

mikeoshields's avatar
mikeoshields
Helper I
7 years ago
Solved

Running Totals

I know there are a plethora of running total posts but I haven't found an answer to my specific issue.  My running totals need to be based on the DateDiff field which is a measure.  Running1 is a cum...
Need Help
  • mikeoshields's avatar
    mikeoshields
    7 years ago

    Actually I found another solution that's a little simpler:

     

    Running1 = CALCULATE(
    SUM(wr_route[DateDiff),
    FILTER(
    ALLSELECTED(wr_route),
    wr_route[wr_lot]=MAX(wr_route[wr_lot]) &&
    wr_route[MaxDate]<=MAX(wr_route[MaxDate])
    )
    )
Ashish_Mathur's avatar
Ashish_Mathur
Super User
7 years ago

You are welcome.  You might as well share the link from where i can download your PBI file.

mikeoshields's avatar
mikeoshields
Helper I
7 years ago

Actually I found another solution that's a little simpler:

 

Running1 = CALCULATE(
SUM(wr_route[DateDiff),
FILTER(
ALLSELECTED(wr_route),
wr_route[wr_lot]=MAX(wr_route[wr_lot]) &&
wr_route[MaxDate]<=MAX(wr_route[MaxDate])
)
)