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 adding the value on 11/11/2019 (6).

 

 

Thank you for your help.

 

Patrick

 
  • 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

1 Reply

  • 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