Add the most recent exclusive records

[Anonymous]

I have a table with the key field (CHAVE), values and dates.
I would like an expression to add only the unique records based on the most recent date.

For example, for KEY XXX I would just like to add the value 10, for YYY just add 40....  and then put the sum of these unique records in a table by date.

and in the end I would like to be able to add a table as follows:

AAA   10

BBB    30

CCC   40

XXX   10

YYY  40

ZZZ   90

total  220

[harshnathani]

Hi @Anonymous ,

Try this measure.

Last Value =  LASTNONBLANKVALUE('Table'[DATA],MAX('Table'[Peso]))

Regards,

Harsh Nathani

[mahoneypat]

Please try this measure expression, replacing Table with your actual table name.

Sum of Latest Values =
VAR summary =
    ADDCOLUMNS (
        VALUES ( Table[CHAVE] ),
        "@value", CALCULATE ( LASTNONBLANKVALUE ( Table[Date], MAX ( Table[Peso] ) ) )
    )
RETURN
    SUMX ( summary, [@value] )

If this works for you, please mark it as the solution.  Kudos are appreciated too.  Please let me know if not.

Regards,

Pat

[lbendlin]

Does it have to be in DAX, and can you provide the sample data in usable form?