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

Anonymous's avatar
Anonymous
Not applicable
7 years ago

Hi Daniel,

 

I used your formula but PBI is giving me an error stating there are too few arguments for the FILTER function and it requires a minimum of 2?

 

Remembering that I need this to be a New Column and not a Measure, would that make a difference with the formula required?

 

Sorry, still very new to DAX and trying to get my head around it all.

 

Thanks,

Paul

v-danhe-msft's avatar
v-danhe-msft
Microsoft Employee
7 years ago

Hi Anonymous,

Could you please offer me a sample file and post your desired result if possible? So I could test for your desied result.

 

Regards,

Daniel He