Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago
Solved

Sum column values by same row value

Hi there,   I have a table which reflects my itemised sales data and includes the following:   Order Number Item Code Item Description Qty Total Sale The same order number can be present o...
Need Help
  • Anonymous's avatar
    Anonymous
    7 years ago

    Hi Daniel,

     

    I found the error I made, there was a single ")" I missed in the formlua which was difficult to spot...

     

    However, I found that the correct formula was in fact to use EARLIER and not MAX.

     

    Thanks,

    Paul

Ashish_Mathur's avatar
Ashish_Mathur
Super User
7 years ago

Hi,

 

In your Table visual, drag Order Number and write this measure

 

=SUM(Data[Total Sale])

 

Hope this helps.