DAX for range input

[Robyrubyjane]

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 tenant, 3rd tenant, 4rd tenant. like this,

TIA

[FreemanZ · Accepted solution]

hi @Robyrubyjane

 try like: 

tenant rank = 

VAR _table=

FILTER(

    TableName, 

    TableName[SiteName] = EARLIER(TableName[SiteName]) 

)

RETURN

RANKX(

    _table,

    TableName[Rental Start],

    ,ASC

)