Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 years ago
Solved

Retrieve Last Date a Value Changed by Group

Hi everyone,   I've been troubleshooting this issue for a couple hours now to no avail. Let's say I have the following dataset: Group Date Setting A 1/30/23 5.3 A 1/15/23 5.3 A ...
"Need Help"
last change
  • FreemanZ's avatar
    FreemanZ
    3 years ago

    hi Anonymous 

    try like:

    NewColumn =
    VAR _group = [Group]
    VAR _grouptable = 
    FILTER(
         TableName, 
         TableName[Group] = _group
    )
    VAR _lastdate =
    MAXX(
        _grouptable,
       TableName[Date]  
    )
    VAR _lastsetting =
    MAXX(
        FILTER(
             _grouptable,
             TableName[Date]=_lastdate
        ),
       TableName[Setting]  
    )
    RETURN
    MINX(
        FILTER(
             _grouptable,
             TableName[Setting] = _lastsetting
        ),
        TableName[Date]
    )
FreemanZ's avatar
FreemanZ
Super User
3 years ago

hi Anonymous 

try like:

NewColumn =
VAR _group = [Group]
VAR _grouptable = 
FILTER(
     TableName, 
     TableName[Group] = _group
)
VAR _lastdate =
MAXX(
    _grouptable,
   TableName[Date]  
)
VAR _lastsetting =
MAXX(
    FILTER(
         _grouptable,
         TableName[Date]=_lastdate
    ),
   TableName[Setting]  
)
RETURN
MINX(
    FILTER(
         _grouptable,
         TableName[Setting] = _lastsetting
    ),
    TableName[Date]
)
Anonymous's avatar
Anonymous
Not applicable
3 years ago

Thanks FreemanZ ! That amazingly worked. Do you have any idea why this worked and my original method didn't? I've used my original method successfully on a similar case but where the "Setting" wasn't a number, but a "Passed"/"Failed" column.