Forum Discussion

Matren's avatar
Matren
Frequent Visitor
2 years ago
Solved

DAX Last Record Value

Hello Everyone,   How could I write a DAX expression with existing columns (Date, Product, Value) to generate a new column (Last Record)?   Basically, it is taking the last Value for a Product an...
  • lbendlin's avatar
    lbendlin
    Icon for Super User rankSuper User
    2 years ago

    Slight variation:

     

     

     

    Last = SELECTCOLUMNS(INDEX(-1,ALL('DATA'),PARTITIONBY([Product]),MATCHBY([Date])),[Value])

     

     

  • Matren's avatar
    Matren
    Frequent Visitor
    2 years ago

    Hi ThxAlot ,

     

    Thanks! I think this looks right.

     

    I will check out the solution with my implementation and then accept the solution.

     

    Have a good day,

    Matren