Forum Discussion

JCK2's avatar
JCK2
Helper III
3 years ago
Solved

Get latest value based on max date

Hello!!!   I want to get the latest target based on the latest date and for the date format has time also, so basically the latest value based on max date and time.   The expeted output of this i...
DAX
  • FreemanZ's avatar
    FreemanZ
    3 years ago

    hi JCK2 

     

    try to plot a visual table with a measure of this:

    Target2 =
    VAR _value = MAXX(TableName, TableName[ModifiedDate])
    RETURN
    MAXX(
        FILTER(TableName, TableName[ModifiedDate] =_value),
        TableName[Target]
    )
     
    i tried and it worked like this:

    the dataset:

     

latimeria's avatar
latimeria
Solution Specialist
3 years ago

Hi JCK2 ,

 

Something like this:

//get max date for 1 project
VAR MaxDate = calculate( max('table'[Modified Date]), allexcept('table, 'table'[project name]))
RETURN

//get target for max date for the project. Instead of max, you can use min as you retrieve only 1 value

//assumpton: you have a relationship between table date & project date
calculate( max('table'[Target]), datetable[date] = MaxDate)