Forum Discussion

Robyrubyjane's avatar
Robyrubyjane
Frequent Visitor
3 years ago
Solved

DAX for range input

hi guys, so i have data like this, in tenant rank column i want to rank each siteID based on the oldest date, so if there is 4 same siteID&SiteName in tenant rank will be rank 1st tenant, 2nd ...
Need Help
  • FreemanZ's avatar
    FreemanZ
    3 years ago

    hi Robyrubyjane

     

     try like: 

    tenant rank = 
    VAR _table=
    FILTER(
        TableName, 
        TableName[SiteName] = EARLIER(TableName[SiteName]) 
    )
    RETURN
    RANKX(
        _table,
        TableName[Rental Start],
        ,ASC
    )

     

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

hi Robyrubyjane

 

 try like: 

tenant rank = 
VAR _table=
FILTER(
    TableName, 
    TableName[SiteName] = EARLIER(TableName[SiteName]) 
)
RETURN
RANKX(
    _table,
    TableName[Rental Start],
    ,ASC
)