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:

     

philouduv's avatar
philouduv
Resolver III
3 years ago

Hello JCK2 ,

If you only want the target create this measure to give you the last value of target:

If you also want the latest date associated create an other measure like this 



Hope it helps you

  • Walt1010's avatar
    Walt1010
    Helper V
    1 year ago

    This (the Related Target calc) looks very promising, but when I try it I get the error "The expression refers to multiple columns. Multiple columns cannot be converted to a scalar value."

     

    Its confusing becasue the condition in my case definitely can only be satisfied by a single Date, and hence a single related value. I tried  dividing it and first retreieving the latest data using LASTDATE, and then using that date to get the value, and it seemed to work.