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.
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.
eDNA Forum – Max Invoice Solution.pbix (405.2 KB)
Gotta love Group By
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.