cancel
Showing results for
Did you mean:

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Frequent Visitor

## Last row value

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.

1 ACCEPTED SOLUTION
Super User

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

3 REPLIES 3
Super User

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

Proud to be a Super User!

Super User

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

Frequent Visitor

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

Thank you!!