How to find Latest date from below data

Question

Hi Team,&nbsp;i have table and need to find Latest date&nbsp;Date&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Item ID &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Value18-07-2022&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 200&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 5000$19-07-2022&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 200&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 6500$18-07-2022&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 300&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 3000$19-07-2022&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 300&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 2000$21-07-2022&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 300&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 1000$19-07-2022&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 400&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 2500$21-07-2022&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 400&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 3500$22-07-2022&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 400&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 4000$

migasuke · Answer

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.&nbsp;

dimamd · Answer

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

dimamd · Answer

MSMKM&nbsp; try it

&nbsp;

msmkm · Answer

Hi DimaMD,&nbsp;I Need Measure how can acheive ?&nbsp;

Forum Discussion

How to find Latest date from below data

4 Replies

Related content

Find Latest duplicate

Finding the first record in the latest group

Find Latest date

Find Latest Date

Find the Latest Value