topic Re: Max Date and Value in DAX Commands and Tips

Max Date and Value

PatrickLamoste — Tue, 17 Dec 2019 18:31:04 GMT

Hello,

I am using an SQL table for my data source and I need to display the value on the latest date.

Referencing the screenshot below I need to display in a Card that the hours is 23 withour adding the value on 11/11/2019 (6).

Thank you for your help.

Patrick

Re: Max Date and Value

az38 — Tue, 17 Dec 2019 19:27:56 GMT

hi PatrickLamoste

create a measure

Measure = var maxEffDate = calculate(max('Table'[Effective Date]);all('Table')) return calculate(MAX('Table'[Hours]);all('Table');'Table'[Effective Date]=maxEffDate)

then add this measure to your card visual

do not hesitate to give a kudo to useful posts and mark solutions as solution