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

 

TIA

 

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
    )

     

1 Reply

  • FreemanZ's avatar
    FreemanZ
    Super 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
    )