Forum Discussion

harshagraj's avatar
harshagraj
Icon for Post Partisan rankPost Partisan
4 years ago
Solved

Excluding Nan in Average calculation

Hello all,

Please see the attached image.

 

I need to calculate the avg of avg in the left side. so i have used the calculation 

Average average per snap_date =
AVERAGEX(
    VALUES('tep_projects'[snap_date]),[Average]).
Now in the above screenshot for B i need to exclude the Nan and calculate the avg for 3 months only.
Kindly help me to modify the calculations. 
amitchandak v-chenwuz-msft 
Need Help

1 Reply

  • amitchandak's avatar
    amitchandak
    Icon for Super User rankSuper User
    4 years ago

    harshagraj ,  Try

     

    AVERAGEX(
    VALUES('tep_projects'[snap_date]),iferror([Average], blank(), [Average]) )