Getting correct price per transaction in a day

Hi all,

I want to conduct a price analysis on certain goods which are purchased throughout the month. 

However, there are days in which the same product is bought 2 or more times within the day, and PBI returns sum of price instead of specific price per specfic transaction.

Tried creating an index column to differentiate each transaction but no luck.

I was thinking that it would be possible to differentiate the transaction by creating a Date/time dummy to differentiate the transactions by hours/seconds? The current dataset does not capture hours/seconds only day, so i am not sure how to proceed.

Any ideas?