topic previous 3 month average including january,february,march months of current year in DAX Commands and Tips

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

Anonymous — Tue, 11 May 2021 07:12:07 GMT

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

wdx223_Daniel — Tue, 11 May 2021 07:51:21 GMT

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

Cristian_Angyal — Tue, 11 May 2021 07:51:53 GMT

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
    )
)

Anonymous — Tue, 11 May 2021 07:56:50 GMT