topic Re: DAX Group by on column but only display latest date budget in DAX Commands and Tips

DAX Group by on column but only display latest date budget

giordafrancis — Wed, 29 Jul 2020 16:32:12 GMT

Consider the below table

I'm looking to create a measures

Desired output is a table as below

Thank you in advance

amitchandak — Wed, 29 Jul 2020 17:01:50 GMT

giordafrancis , use this for budget

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

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

Anonymous — Wed, 29 Jul 2020 17:27:26 GMT

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