Forum Discussion

JCK2's avatar
JCK2
Icon for Helper III rankHelper 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:

     

FreemanZ's avatar
FreemanZ
Icon for Super User rankSuper User
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:

 

  • FreemanZ's avatar
    FreemanZ
    Icon for Super User rankSuper User
    3 years ago

    it can be further simplified like this:

    Target3 =
    VAR _value = MAX(TableName[ModifiedDate])
    RETURN
    MAXX(
        FILTER(TableName, TableName[ModifiedDate] =_value),
        TableName[Target]
    )
  • Anonymous's avatar
    Anonymous
    Not applicable
    1 year ago

    With this I got What I wanted but one thing when I enable the total values the total the value is coming as Max value of both(in this case 95)  instead of sum of both ( 96) . 
    Can you please help me with that.