Forum Discussion

omarh's avatar
omarh
Frequent Visitor
6 years ago

Last purchase date before last purchase

Hi,   I want to show the last date an item was bought before the last invoice and the days between the 2 purchases    
Need Help
Ashish_Mathur's avatar
Ashish_Mathur
Icon for Super User rankSuper User
6 years ago

Hi,

You may download my PBI file from here.

Hope this helps.

omarh's avatar
omarh
Frequent Visitor
6 years ago
This doesnt work, I want to show invoiceDate, invoice number, quantity, price, and last date of last invoice where item was bought....
  • Ashish_Mathur's avatar
    Ashish_Mathur
    Icon for Super User rankSuper User
    6 years ago

    Hi,

    Whom are you replying to?  Have you tried my solution?  If yes, then where does it fall short of your expectation?

    • omarh's avatar
      omarh
      Frequent Visitor
      6 years ago

      I tried both solutions and they dont work for my case.

      I want to show the actual data of the purchase the date sky quantity and price, and next to them i want to show the last date the item was purchased and at what price and what quantity. All the data is in the same table so for example for product set-600 in order 3 we purchased 400 pieces at $10 the last time we purchased was in Order 1 i want to show the date of order 1 and the quantity and price of that item the last time we bought it.

       

      Sorry for the late reply, hope this clarifies my question.

      • Ashish_Mathur's avatar
        Ashish_Mathur
        Icon for Super User rankSuper User
        6 years ago

        Hi,

        So the last 3 columns are what you want to generate via measures.  Share the link from where i can download your PBI file.