Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 years ago

Tableau expression into DAX

Hi, I have a Tableau expression that I would like to convert into DAX.   PREVIOUS_VALUE(0)+ MIN( WINDOW_AVG(SUM([values]),-365-[Days Average],-365+[Days Average]), WINDOW_AVG(SUM([values]),-730...
DAX
Tableau
MAwwad's avatar
MAwwad
Icon for Solution Sage rankSolution Sage
3 years ago

Cumulative Rolling Average =

VAR PrevValue =

    CALCULATE(

        SUM([values]),

        FILTER(

            ALLSELECTED(),

            MAX('Table'[Date]) = EARLIER(MAX('Table'[Date]))

        )

    )

RETURN

    PrevValue +

    MINX(

        {

            CALCULATE(

                WINDOWAVG(SUM([values]), -365 - [Days Average], -365 + [Days Average])

            ),

            CALCULATE(

                WINDOWAVG(SUM([values]), -730 - [Days Average], -730 + [Days Average])

            )

        },

        [Cumulative Rolling Average]

    )