Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

AVERAGEX Problems

Hello all,   I am pulling my hair out with an AVERAGEX formula Water TRIFR 12MMA = AVERAGEX( DATESINPERIOD ( 'Calendar'[Date], LASTDATE ( 'Calendar'[Date] ), -12, MONTH ), [Water TRIFR] ...
Need Help
  • nandukrishnavs's avatar
    nandukrishnavs
    6 years ago

    Anonymous 

     

    Try this 

     

    Water TRIFR 12MMA =
VAR monthrange = 12
VAR result =
    DIVIDE (
        SUMX (
            DATESINPERIOD (
                'Calendar'[Date],
                LASTDATE ( 'Calendar'[Date] ),
                -1 * monthrange,
                MONTH
            ),
            [Water TRIFR]
        ),
        monthrange,
        BLANK ()
    )
RETURN
    result

     



    Did I answer your question? Mark my post as a solution!
    Appreciate with a kudos     🙂

nandukrishnavs's avatar
nandukrishnavs
Community Champion
6 years ago

Anonymous 

 

Try this 

 

Water TRIFR 12MMA =
VAR monthrange = 12
VAR result =
    DIVIDE (
        SUMX (
            DATESINPERIOD (
                'Calendar'[Date],
                LASTDATE ( 'Calendar'[Date] ),
                -1 * monthrange,
                MONTH
            ),
            [Water TRIFR]
        ),
        monthrange,
        BLANK ()
    )
RETURN
    result

 



Did I answer your question? Mark my post as a solution!
Appreciate with a kudos 🙂

Anonymous's avatar
Anonymous
Not applicable
6 years ago

nandukrishnavs 

 

My hero!