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     🙂

Anonymous's avatar
Anonymous
Not applicable
6 years ago

nandukrishnavs 

 

Hey,

 

Where do I apply that all()?

 

I checked the filters and they are (all)

nandukrishnavs's avatar
nandukrishnavs
Community Champion
6 years ago

Anonymous 

 

Try this measure.

Water TRIFR 12MMA =
AVERAGEX (
    DATESINPERIOD (
        ALL ( 'Calendar'[Date] ),
        LASTDATE ( 'Calendar'[Date] ),
        -12,
        MONTH
    ),
    [Water TRIFR]
)

If you can share the dataset, I can validate it. 



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