Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago
Solved

AVERAGE

Hi All,   I get two different outputs while using AVERAGE. In excel, i get a different value and in PowerBI a different value. Can I know why that is happening?   I have attached the images belo...
Need Help
  • FarhanAhmed's avatar
    FarhanAhmed
    4 years ago

    If you are creating a

    ABC = 
DIVIDE(AVG2[col1]+AVG2[col2]+AVG2[col3]+AVG2[col4]+AVG2[col5],

IF(ISBLANK(AVG2[col1]),0,1)+
IF(ISBLANK(AVG2[col2]),0,1)+

IF(ISBLANK(AVG2[col3]),0,1)+
IF(ISBLANK(AVG2[col4]),0,1)+

IF(ISBLANK(AVG2[col5]),0,1)
,BLANK())

    calculated column then you may need to use this.

     

     

     

     

Anonymous's avatar
Anonymous
Not applicable
4 years ago

Hi FarhanAhmed ,

Thank you!

When I apply that formula I get 0%.

I have attached the image below:

 

FarhanAhmed's avatar
FarhanAhmed
Community Champion
4 years ago

If you are creating a

ABC = 
DIVIDE(AVG2[col1]+AVG2[col2]+AVG2[col3]+AVG2[col4]+AVG2[col5],

IF(ISBLANK(AVG2[col1]),0,1)+
IF(ISBLANK(AVG2[col2]),0,1)+

IF(ISBLANK(AVG2[col3]),0,1)+
IF(ISBLANK(AVG2[col4]),0,1)+

IF(ISBLANK(AVG2[col5]),0,1)
,BLANK())

calculated column then you may need to use this.

 

 

 

 

  • Anonymous's avatar
    Anonymous
    Not applicable
    4 years ago

    Thanks a lot! FarhanAhmed