Forum Discussion

DanielSagaon's avatar
DanielSagaon
Frequent Visitor
6 years ago
Solved

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:   ...
Need Help
  • AlB's avatar
    AlB
    6 years ago

    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  Datanaut

     

Nathaniel_C's avatar
Nathaniel_C
Community Champion
6 years ago

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.

WeekProductScoreDesirable result
Apr 14 - 20, 2019ASIN26426161
Apr 21 - 27, 2019ASIN26426261
Apr 28 - May 4, 2019ASIN26426162



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