Trouble with conditional columns

[Toune84]

Hello all!

I have something quite difficult to do for an amateur like me on PowerBI. I am completely stuck on this. I would be really grateful if someone can help me.

Below is my database with 6 columns:

1. date (date of the transaction)

2. txHash (Id of the transaction)

3. nftld (reference of the product)

4. from (seller)

5. to (buyer)

6. price (price of the transaction)

What I want to know is: if I have a buyer (to) that has sold the same reference (nftld) he has previously purchased from a seller (from), how long has he kept the product (in number of days)?

This is too difficult for me. I tried with conditional columns but there is way too much conditions.

Thanks a lot !

Cheers

[Toune84]

Thanks a lot for your answer! I combined your solution with this one: https://community.powerbi.com/t5/Desktop/Calculting-min-max-and-average-depending-on-weeks/m-p/25589...

[amitchandak · Accepted solution]

@Toune84 , You can get last date for same nftld like this , you can add more filters if needed

maxx(filter(Table, [nftld] =earlier([nftld]) && [date] < earlier([date])),[date])