Forum Discussion

Fraze's avatar
Fraze
Helper I
3 years ago

Running Total (Editor/CalculatedColumn/Measure?) and Average Running Total (Measure?)

Hello,   My current issue is 2-fold. I have figured out how to solve each independently, but none of the approaches I have found solve both simultaneously. Test file attached here   1 - Running T...
General Comment
Need Help
Show and Tell
Tips and Tricks
Anonymous's avatar
Anonymous
Not applicable
3 years ago

Hi Fraze ,

 

Do you want to calculate the average of running total by logic as running total divide days whose netchange not equal to 0?

Here I suggest you to try this code.

Avg = 
VAR _SUMMARIZE =
    SUMMARIZE (
        'Transactions&Date',
        [Date],
        "NetChange", CALCULATE ( SUM ( 'Transactions&Date'[NetChange] ) )
    )
VAR _COUNT_DAY =
    COUNTAX ( FILTER ( _SUMMARIZE, [NetChange] <> 0 ), [Date] )
RETURN
    DIVIDE ( [Running Total], _COUNT_DAY )

In June there are 24 days whose Netchange <>0.

Result is as below.

 

Best Regards,
Rico Zhou

 

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

  • Fraze's avatar
    Fraze
    Helper I
    3 years ago

    Hello,

     

    No, I am looking for the basic average. So if we keep using June as the example, the average Running total is -53,271. So the average calculation formula is very basic, what is challenging is that it is doing it on the running total measure. Which is why I am also curious if the running total should be converted to a calcualted column.