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.