Forum Discussion

Babycakes_00's avatar
Babycakes_00
Helper I
1 year ago
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...
Need Help
  • p45cal's avatar
    p45cal
    1 year ago

    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

     

     

p45cal's avatar
p45cal
Solution Supplier
1 year ago

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