Forum Discussion
Average between Multiple Dates
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!
Anonymous
Create a measure as follows:Average_SQ_PD_PA_Lag = AVERAGE('cr93f_cpsoo'[SQ PD/PA Lag Column])
2 Replies
Anonymous
Create a measure as follows:Average_SQ_PD_PA_Lag = AVERAGE('cr93f_cpsoo'[SQ PD/PA Lag Column])