Forum Discussion

Helper I

7 months ago

Solved

Day to Day average

Could anyone help me with a measure to find out Day to Day average for Life Total Column in the screenshot below? I' apprecaite your help thanks!

Need Help

cengizhanarslan

6 months ago

Please try the following logic:

Day to Day % =
VAR PrevValue =
    CALCULATE (
        SUM ( 'Table'[Life Total] ),
        DATEADD ( 'Table'[Date Run], -1, DAY )
    )
VAR CurrValue =
    SUM ( 'Table'[Life Total] )
RETURN
IF (
    NOT ISBLANK ( PrevValue ),
    DIVIDE ( CurrValue - PrevValue, PrevValue )
)