Latest Enterprise DNA Initiatives

Highest Invoice Value

I would like to get the highest value invoice per customer in the sales data, which has all the invoices for all products from all customers. Thank you.

@melaneelee ,

This can be done through DAX Or Power Query, but I prefer the latter. All you need to do is group the data this way, hit OK and expand the results:


I hope this is helpful. Full solution file attached below, along with a video that delves further into this technique.

  • Brian

eDNA Forum ā€“ Max Invoice Solution.pbix (405.2 KB)

1 Like

Gotta love Group By :smiling_face_with_three_hearts: :heart_eyes:

1 Like

Hi @melaneelee, did the response provided by @BrianJ help you solve your query? If not, how far did you get and what kind of help you need further? If yes, kindly mark as solution the answer that solved your query. Thanks!

Iā€™m currently traveling and will be able to on the 24th. Thank you for your help, I promise to give feedback.

1 Like