Forum Discussion

swebb's avatar
swebb
Icon for Helper II rankHelper II
3 years ago
Solved

Issue 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 ...
  • tamerj1's avatar
    tamerj1
    3 years ago

    Hi swebb 

    please try

    Avg Age =
    AVERAGEX (
    opportunity,
    DATEDIFF ( [createdon], COALESCE ( [actualclosedate], TODAY () ), DAY )
    )

tamerj1's avatar
tamerj1
Icon for Community Champion rankCommunity Champion
3 years ago

Hi swebb 

please try

Avg Age =
AVERAGEX (
opportunity,
DATEDIFF ( [createdon], COALESCE ( [actualclosedate], TODAY () ), DAY )
)

  • swebb's avatar
    swebb
    Icon for Helper II rankHelper II
    3 years ago

    Actually, I think we can mark this resolved. I was looking through the records and have determined the counts are accurate. Thank you!

  • swebb's avatar
    swebb
    Icon for Helper II rankHelper II
    3 years ago

    A bit closer, maybe. Still getting some really odd numbers, in to the thousands.