Customer Engagement & Dynamics CRM Forum

 View Only
  • 1.  Report Question

    Posted Nov 30, 2021 01:23 PM

    I have a request for a report on products in our product catalog that have not been ordered since go-live.

    The issue I'm encountering is that the order products table contains the product ID's that have been ordered so this is one of my source tables. This data can be merged with Power Query Builder containing the product catalog (my other source table) to identify those products with no associated orders. This will give them what they want and is one approach anyways.

    The problem I am running into is that I don't have a method for only querying the unique product ID on the order product table. Any query on the order product table returns every line item which is far too many rows (talking over 1M). Is there a method for only returning the unique product ID's found on the order line item table and not every line item (i.e. no dupes)? I just need one instance of the product ID from the order product table.

    Hope this makes sense.

    Response much appreciated

    keith courtemanche

If you've found this thread useful, dive deeper into User Group community content by role