Average between Multiple Dates

[Anonymous]

Hello All,

I needed to find the days between two dates, Physical Date and Price Approved Date, so I created a Calculated Column with this logic:

SQ PD/PA Lag Column = DATEDIFF('cr93f_cpsoo'[Physical Date], cr93f_cpsoo[PriceApproved.date],DAY)

Now I am needing to find the average of this. Any formula I have tried seems to just not work.

@Dangar332 Any ideas?

Thank you!

[Fowmy · Accepted solution]

@Anonymous 

Create a measure as follows:

Average_SQ_PD_PA_Lag = AVERAGE('cr93f_cpsoo'[SQ PD/PA Lag Column])

[Anonymous]

Thank you! I marked as solution.