Average of a measure

[dpeacockTHH]

I'm hoping that I'm just completely missing something obvious here.  

I want to be able to pull an average of the last 5 days of CPD (which equals spend/download).  

I'm pulling my hair out as this should be so simple but I cannot figure it out!  It looks like averages can only be done on a column.  The spend and download numbers come from 2 different tables:  Spend[spend] and Downloads[downloads].  The common fields that connect the tables are App and Date.

Any help would be appreciated as my brain is done.  I can't believe I can't figure out how to do an average.  SMH.

[VahidDM · Accepted solution]

Hi @dpeacockTHH 

Try this measure:

Average CPD 5 Last Days = 
Var _Date = LASTDATE(Spend[Date])-4
Var _FT = FILTER(Spend,Spend[Date]>=_Date)
Var _New_Table = ADDCOLUMNS(_FT,"D",RELATED(Downloads[downloads]),"CPD",[Spend]/RELATED(Downloads[downloads]))
return
AVERAGEX(_New_Table,[CPD])

The sample file attached.

If this post helps, please consider accepting it as the solution to help the other members find it more quickly.
Appreciate your Kudos!!
LinkedIn: www.linkedin.com/in/vahid-dm/