How to find Latest date from below data

[MSMKM]

Hi Team,

i have table and need to find Latest date

Date      Item ID               Value

18-07-2022        200        5000$

19-07-2022        200        6500$

18-07-2022        300        3000$

19-07-2022        300        2000$

21-07-2022        300        1000$

19-07-2022        400        2500$

21-07-2022        400        3500$

22-07-2022        400        4000$

[MSMKM]

Hi DimaMD,

I Need Measure how can acheive ?

[DimaMD]

@MSMKM  try it

[Migasuke]

Hi @MSMKM ,

If you just want simple last date, you can use following syntax with "LASTDATE" function:

Last Date = LASTDATE('Table'[Date])
result:

In case you want value for the last date, you can adjust the formula:

Last Date Value = CALCULATE(SUM('Table'[Value]),LASTDATE('Table'[Date]))
result:

Just be sure, you have Date column as a Date data type and not text. The same applies for Value column. Be sure you have number instead of text.

[DimaMD]

hi, @MSMKM Do you need the latest date on your ID? Should it be a measure or a calculated column?