Forum Discussion

michael_knight's avatar
michael_knight
Icon for Post Prodigy rankPost Prodigy
5 years ago
Solved

Previous 3 Months Average

Hi,   I'm trying to create a measure which will display the average of the last 3 months     This is what I want is have as a average over the last 3 months. For example, April's % will be...
Need Help
  • Jihwan_Kim's avatar
    Jihwan_Kim
    5 years ago

    Hi, michael_knight 

     

    Pleases try the below measure.

     

    3 Month Rolling Average Fall Through =
    IF (
    ISBLANK ( [Confirmed] ),
    BLANK (),
    CALCULATE (
    AVERAGEX ( VALUES ( 'Date'[Month/Year] ), [Fall Through %] ),
    DATESINPERIOD ( 'Date'[Full Date], LASTDATE ( 'Date'[Full Date] ), -3, MONTH )
    )
    )

     

     

    Hi, My name is Jihwan Kim.

    If this post helps, then please consider accept it as the solution to help other members find it faster, and give a big thumbs up.

Jihwan_Kim's avatar
Jihwan_Kim
Icon for Super User rankSuper User
5 years ago

Hi, michael_knight 

 

Pleases try the below measure.

 

3 Month Rolling Average Fall Through =
IF (
ISBLANK ( [Confirmed] ),
BLANK (),
CALCULATE (
AVERAGEX ( VALUES ( 'Date'[Month/Year] ), [Fall Through %] ),
DATESINPERIOD ( 'Date'[Full Date], LASTDATE ( 'Date'[Full Date] ), -3, MONTH )
)
)

 

 

Hi, My name is Jihwan Kim.

If this post helps, then please consider accept it as the solution to help other members find it faster, and give a big thumbs up.