Forum Discussion

Toune84's avatar
Toune84
Regular Visitor
4 years ago
Solved

Trouble with conditional columns

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

Need Help
  • amitchandak's avatar
    amitchandak
    4 years ago

    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])

2 Replies