Forum Discussion

gdelvecchio's avatar
gdelvecchio
Regular Visitor
7 years ago
Solved

Can't filter a table before calculating Average

Average Account Life 2:= 　 AVERAGEX (   FILTER (     'Facts', [Close Date] > [Open Date]),       DATEDIFF([Open Date], [Close Date], MONTH))   The measure above gives me an error saying the DA...
Need Help
  • v-frfei-msft's avatar
    v-frfei-msft
    7 years ago

    Hi gdelvecchio,

     

    One sample for your refernce. Using the fomula as below, everything worked well.

     

    Measure = AVERAGEX(FILTER(Facts,Facts[Open Date]<Facts[Close Date]),DATEDIFF(Facts[Open Date],Facts[Close Date],MONTH))

     

    For more details, please check the pbix as attached.

     

    Regards,

    Frank

Anonymous's avatar
Anonymous
Not applicable
7 years ago

Try to work with following formula 

Measure = AVERAGEX(FILTER(Facts, 
Facts[Open Date] < Facts[Close Date]), 
DATEDIFF(Facts[Open Date], 
Facts[Close Date], MONTH))

Hop it will give correct answer.