Forum Discussion
Solved
Question to identify discrepancies
Hi THere A little vague but hoping you can assist. I have a data set with Customer ID, Customer Name which is the core list of customers. On my other sheet is Customer Orders by date. I...
You've posted this in the Power Query section so here's a PQ offering:
If a date doesn't appear in the Date slicer, no-one's placed any orders.
re: "I want to see that customer 1 did not make an order etc etc"
If you're not bothered about the customer name then a direct pivot from the Orders table is possible; see pivot at cell H27.
The workbook: https://app.box.com/s/qqgqq8hwpfz8gickojhdhftsay70cdo1
Hi Babycakes_00 , Just wanted to know if your issue is solved. If not please share the details, so that we can work together to solve it. If it is solved, then please consider marking it 'Accept as Solution' so others with similar queries may find it easily.