topic Define Last Purchase Before the Last Purchase in DAX Commands and Tips

Define Last Purchase Before the Last Purchase

guvhahsya — Mon, 20 Feb 2023 08:05:25 GMT

Hi guys I need some help with this problem. Username A bought our products on the written dates in the picture (including 16 August). Is there a DAX so that "Last Purchase Date" shows 8 August and not 16 August (2nd last purchase date)? Thanks so much!
This is my DAX for now

Last Purchase Date =

CALCULATE(

MAX(SHOPEE[Waktu Pembayaran Dilakukan]),

FILTER(

SHOPEE,

SHOPEE[Username] = EARLIER(SHOPEE[Username]) &&

SHOPEE[Waktu Pembayaran Dilakukan] < EARLIER(SHOPEE[Username])

)

Re: Define Last Purchase Before the Last Purchase

ValtteriN — Mon, 20 Feb 2023 08:06:15 GMT

Hi,

Here is one way to do this:

Last purchase = var _date = MAX('Table (30)'[Purchase Date]) return

CALCULATE(MAX('Table (30)'[Purchase Date]),ALL('Table (30)'[Purchase Date]),'Table (30)'[Purchase Date]<_date)

End result:

I hope this post helps to solve your issue and if it does consider accepting it as a solution and giving the post a thumbs up!

My LinkedIn: https://www.linkedin.com/in/n%C3%A4ttiahov-00001/

Re: Define Last Purchase Before the Last Purchase

guvhahsya — Mon, 20 Feb 2023 10:27:42 GMT

Thanks a lot! its work