previous 3 month average including january,february,march months of current year

[Anonymous]

Hello ,

I am trying to find previous 3 months of average.

I have tried below measure but I want january, february and march data aswell without selecting month and year

Measure-

 Last 3 Months =

var last_month= CALCULATE(sum(Tsales[sales]),MONTH(DimDate[Date])=MONTH(TODAY())-1)

var second_last_month=CALCULATE(sum(Tsales[sales]),

MONTH(DimDate[Date])=MONTH(TODAY())-2)

var third_last_month=CALCULATE(sum(Tsales[sales]),

MONTH(DimDate[date])=MONTH(TODAY())-3)

var total= (last_month+second_last_month+third_last_month)

var last3m_avg= (total)/3

return total

[Anonymous]

Time Intelligence in Power BI Desktop - SQLBI

Time Intelligence calculations with Power BI | Community Webinars - YouTube

[Cristian_Angyal]

Hello @Anonymous ,

Asuming you have a Dimension Calendar Table you could use this:

Prev 3 Month Average =
CALCULATE (
    AVERAGE ( Tsales[sales] ),
    DATESINPERIOD (  

       'Calendar'[Date],
        EOMONTH ( MIN ( 'Calendar'[Date] ),  -1 ),   //the last day of last month.
        -3,
        MONTH
    )
)

[wdx223_Daniel]

calculate(averagex(values(dimdate[yearmonth]),calculate(sum(tsales[sales]))),datesinperiod(eomonth(today(),-1),-3,MONTH))