Forum Discussion

Icon for Helper I rank

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!

cengizhanarslan

7 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 )
)

Icon for Super User rank

Super User

7 months ago

I am assuming Life Total is a DAX measure, am I correct?

Can you please explain what you mean by "Day to Day average" ?

Thanks

If this helped, please consider giving kudos and mark as a solution

@me in replies or I'll lose your thread

Want to check your DAX skills? Answer my biweekly DAX challenges on the kubisco Linkedin page

Consider voting this Power BI idea

Francesco Bergamaschi

MBA, M.Eng, M.Econ, Professor of BI

Icon for Helper I rank

Helper I

7 months ago

Yes DAX measure,

I want to get (Day 2 - Day 1)/Day 1 for the column Life Total.