swebbHelper II3 years agoSolvedIssue with DATEDIFF All, PBI newbie here. Maybe I'm missing something, not real sure, but I have a measure that I'm using to calculate the average age of an opportunity from our CRM data. It works when coupled with ...Show Moretamerj13 years agoHi swebb please try Avg Age =AVERAGEX (opportunity,DATEDIFF ( [createdon], COALESCE ( [actualclosedate], TODAY () ), DAY ))
tamerj13 years agoHi swebb please try Avg Age =AVERAGEX (opportunity,DATEDIFF ( [createdon], COALESCE ( [actualclosedate], TODAY () ), DAY ))
tamerj13 years agoHi swebb please try Avg Age =AVERAGEX (opportunity,DATEDIFF ( [createdon], COALESCE ( [actualclosedate], TODAY () ), DAY ))
tamerj1Community Champion3 years agoHi swebb please try Avg Age =AVERAGEX (opportunity,DATEDIFF ( [createdon], COALESCE ( [actualclosedate], TODAY () ), DAY ))
swebbHelper II to tamerj13 years agoActually, I think we can mark this resolved. I was looking through the records and have determined the counts are accurate. Thank you!
Related contentDATEDIFF DAXAveragex issueDATEDIFF Working DaysDateDiff Issue with Month CalculationRelationship Issue
