Forum Discussion

carlosyanez's avatar
carlosyanez
Frequent Visitor
3 years ago
Solved

Dynamically filter row based on dates and ID

Hi,   I'm currently working on a Dashboard where I need to pick the latest value for one category, with the ability to use a time slicer and then get the latest value within the range of the filter...
  • FreemanZ's avatar
    FreemanZ
    3 years ago

    hi carlosyanez 

     

    try to created two measures and plot a visual table with them. 

     

    the code:

    DateLatest := MAX(TableName[Date])
    ValueLatest :=
    VAR DateLatest = MAX(TableName[Date])
    RETURN
    CALCULATETABLE(
        VALUES(TableName[Value]),
        TableName[Date] = DateLatest
    )
     
    I tried and it worked like this:

     

     

FreemanZ's avatar
FreemanZ
Super User
3 years ago

hi carlosyanez 

 

try to created two measures and plot a visual table with them. 

 

the code:

DateLatest := MAX(TableName[Date])
ValueLatest :=
VAR DateLatest = MAX(TableName[Date])
RETURN
CALCULATETABLE(
    VALUES(TableName[Value]),
    TableName[Date] = DateLatest
)
 
I tried and it worked like this: