Forum Discussion

PatrickLamoste's avatar
PatrickLamoste
Helper I
6 years ago
Solved

Max Date and Value

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...
  • az38's avatar
    az38
    6 years ago

    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

    LinkedIn

az38's avatar
az38
Community Champion
6 years ago

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

LinkedIn