locked
Power Bi Query RRS feed

  • General discussion

  • How to perform the average of 5 columns in power bi desktop  when the data in the table is

    Feb Mar April May June
    2 4
    1 3
    2
    3 4 5 2
    • Edited by smiletime Friday, January 29, 2016 1:24 PM
    Friday, January 29, 2016 1:21 PM

All replies

  • It depends:

    1) Do you want to show the averages in an additional column (so a row-wise calculation) or column-wise (so average for each month) or one figure for all 5 columns at once

    2) Do you have blanks in your table or is this just due to poor formatting?

    3) How shall the blanks be handled? Shall these field be ignored or considered as 0? (Say there are 4 rows, then average for Feb would be 2 if blanks are ignored or 1 if considered as 0)


    Imke Feldmann TheBIccountant.com

    Friday, January 29, 2016 2:02 PM
  • Hi

    I want to show the average in an additional column (a row wise calculation) for all 5 column at once.

    The blanks are included and they are considered null on each of its occurence like for ex the average should result like the below column of AVG.(AVG=Sum/count of columns with data)

    Feb Mar April May June         AVG
    2 4 3
    1 3 2
    2 2
    3 4 5
    3.5

    Friday, January 29, 2016 2:14 PM
  • That's better :-)

    List.Average({[Feb], [Mar], [April], [May], [June]})


    Imke Feldmann TheBIccountant.com


    Friday, January 29, 2016 2:21 PM
  • Thanks Imke! Its working..
    Friday, January 29, 2016 2:32 PM