Forum Discussion

fbostan1's avatar
fbostan1
Helper I
6 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's avatar
    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 )
)
cengizhanarslan's avatar
cengizhanarslan
Super User
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 )
)
fbostan1's avatar
fbostan1
Helper I
6 months ago

cengizhanarslan Hi, 

your dax formula worked, how can I fill the empty spots. I know why its empty but I don't know how to tweek the dax to get percentage for Monday and Friday.