Last row value

[DanielSagaon]

Hello! I would like your help. I am looking to find the last row value per Product. How can I archive that using DAX: 

I want the column desirable result, is the last value from the last row:

Week	Product	Score	Desirable result
Apr 14 - 20, 2019	ASIN2642	61	61
Apr 21 - 27, 2019	ASIN2642	62	61
Apr 28 - May 4, 2019	ASIN2642	61	62
Apr 14 - 20, 2019	AEO12	60	60
Apr 21 - 27, 2019	AEO12	71	60
Apr 28 - May 4, 2019	AEO12	63	63
Apr 14 - 20, 2019	BIG45	65	65
Apr 21 - 27, 2019	BIG45	60	65
Apr 28 - May 4, 2019	BIG45	65	60
Apr 14 - 20, 2019	ZAZ89	69	69
Apr 21 - 27, 2019	ZAZ89	67	69
Apr 28 - May 4, 2019	ZAZ89	64	67

I hope you can help me.

[Nathaniel_C]

Hi @DanielSagaon ,

This doesn't appear to show what you are asking. These three are the same product, and I would expect a 61 in each row.

Week	Product	Score	Desirable result
Apr 14 - 20, 2019	ASIN2642	61	61
Apr 21 - 27, 2019	ASIN2642	62	61
Apr 28 - May 4, 2019	ASIN2642	61	62

Let me know if you have any questions.

If this solves your issues, please mark it as the solution, so that others can find it easily. Kudos are nice too.
Nathaniel

[AlB · Accepted solution]

Hi @DanielSagaon 

I assume this is a calculated column. If so:

NewCol =
VAR PreviousDate_ =
    CALCULATE (
        MAX ( Table1[Week] ),
        Table1[Week] < EARLIER ( Table1[Week] ),
        ALLEXCEPT ( Table1, Table1[Product] )
    )
RETURN
    IF (
        ISBLANK ( PreviousDate_ ),
        Table1[Score],
        CALCULATE (
            DISTINCT ( Table1[Score] ),
            Table1[Week] = PreviousDate_,
            ALLEXCEPT ( Table1, Table1[Product] )
        )
    )

Please mark the question solved when done and consider giving kudos if posts are helpful.

Cheers  

[DanielSagaon]

Hi!! Thank you so much!! this is exactly what I was looking for!!!!

Really helpful!!

Thank you!!