DAX Help : Previous 3 Months average

Anonymous 

Average of Previous 3 Full Months = 
VAR _current_date = 'Table'[GRN Date]
VAR _end_point = EOMONTH(_current_date, -1)
VAR _start_point = EOMONTH(_current_date, -4) + 1
VAR _min_date_total = MIN('Table'[GRN Date])
VAR _result = 
    DIVIDE(
        SUMX(
            FILTER(
                'Table',
                'Table'[GRN Date] >= _start_point && 'Table'[GRN Date] <= _end_point
            ),
            'Table'[Lead Time (Days)]
        ),
        3
    ) 
RETURN
    IF(
        EOMONTH(_start_point, -1)  >= EOMONTH(_min_date_total, -1),
        _result
    )

In case it answered your question, please accept the solution to help other members find it. Appreciate Your Kudos.

Showcase Report – Contoso By SpartaBI

Visit SpartaBI website   Visit SpartaBI Linkdin   Visit SpartaBI Facebook

SpartaBI Logo

Anonymous we are not dealing here with best practice stuff, but, as we created the column before you can create this measure to use as the line value:

In case it answered your question, please accept the solution to help other members find it. Appreciate Your Kudos.

Showcase Report – Contoso By SpartaBI

Visit SpartaBI website   Visit SpartaBI Linkdin   Visit SpartaBI Facebook

SpartaBI Logo