Forum Discussion
Last purchase date before last purchase
Super UserHi,
Whom are you replying to? Have you tried my solution? If yes, then where does it fall short of your expectation?
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
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.
Hi Anish,
Here is a link to the pbix https://drive.google.com/file/d/1byfvP-XBn3MdutueaQGZY3bZwc5vJLjS/view?usp=sharing
Thanks for everything.
- Ashish_Mathur
In your previous post, there was an SKU number. In the PBI file, there is no SKU number so i am confused. For the visual that you created on Page1 of the PBI file, show the expected result.