Atlanta Business Intelligence Group

Please login or click SIGN UP FOR FREE to create your PowerBIUG account to join this user group.
 View Only

How to Access last dat info

  • 1.  How to Access last dat info

    Posted May 16, 2017 11:46 AM
    Hi,
    I have a table (query) with four columns.
    1 CustID
    2 Date (s) of purchase
    3 Name of product
    4 Number of products ordered

    I created a new table with a unique CustIDs column. I need to add  the remaining 3 columns, however, I only need the last purchase date, along with the last product name and the number of products ordered of the last product ordered. Any assistance would be much appreciated.

    Jose

    ------------------------------
    Jose Hernandez
    IT Special Program's Database Manager
    New York NY
    212-316-8357
    ------------------------------