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
    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 Hernandez
    IT Special Program's Database Manager
    New York NY