Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

Average - But need to sum first

Hi,   Third time I write this topic.. Website is not helping me out today, haha. Hopefully you guys can 🙂 I need to calculate the average after a sum of the invoices. Sample below:   Amount...
Need Help
  • amitchandak's avatar
    amitchandak
    6 years ago

    Anonymous , Try like

    averageX(summarize(Table,table[Invoice Number], "_1",sum(Table[Amount])),[_1])

amitchandak's avatar
amitchandak
Super User
6 years ago

Anonymous , Try like

averageX(summarize(Table,table[Invoice Number], "_1",sum(Table[Amount])),[_1])

Anonymous's avatar
Anonymous
Not applicable
6 years ago

Hi amitchandak ,

 

Thanks! Works like a charm. Can you explain what the _1 is and why it works like that?

  • amitchandak's avatar
    amitchandak
    Super User
    6 years ago

    Anonymous , it is new column name inside summarize