DAX Group by on column but only display latest date budget

[giordafrancis]

Consider the below table

id	date	budget
101	01/06/2020	50
101	01/07/2020	100
103	01/06/2020	50
103	01/07/2020	50
103	01/08/2020	20

I'm looking to create a measures

1. that groups by on the id col
2. but only presents the latest entry based on date

Desired output is a table as below

	last date	budget
101	01/07/2020	100
103	01/08/2020	20

Thank you in advance

[harshnathani · Accepted solution]

Hi @giordafrancis ,

You can use this for Last Date

Last Date = CALCULATE(LASTNONBLANK('Table'[date],1) ,FILTER(ALL('Table'[id]), 'Table'[id] = MAX('Table'[id])))

and the above mentioned measure for Last Budget.

Last Budget = 
lastnonblankvalue('Table'[date],sum('Table'[budget]))

 Regards,

Harsh Nathani

[amitchandak]

@giordafrancis , use this for budget

lastnonblankvalue(Table[date],max(Table[budget]))

or

lastnonblankvalue(Table[date],sum(Table[budget]))