Forum Discussion
mlmagl14
Helper I
Helper IDAX to Count Sales
Hello, I have a table in which the receipt ID represents a customer, so the receipt ID can occur multiple times if the customer purchases multiple items from the store per day. It also shows the...
In power query , group by Date , Receipt Id and Add aggregation for sum of total retail price.
Add another conditional column for 95+ based on the aggregated column.
Regards
DI
Did I answer your question? Mark my post as a solution, this will help others!
Kudos are also welcome.
darshaningale
Resolver II
Resolver IIprovide sample data in excel and then i can send you steps/pbix file.
mlmagl14Helper I
Helper II actually figured it out using your suggestions. Thank you so much for help. I really appreciate it!