Rank Dates

Hi, I want to do a Rank function which is based on the columns TableName, Group and DateTime So for the latest DateTime for each TableName that is in the Group I want that to be ranked as 1 e.g...

Need Help

SpartaBI

4 years ago

AvPowerBI

Rank = 
VAR _name = 'Table'[TableName]
VAR _group = 'Table'[Group]
VAR _result = 
RANKX(
    FILTER(
        ALL('Table'),
        'Table'[TableName] = _name
         && 'Table'[Group] = _group
    ),
    'Table'[DateTime],
    ,
    DESC
)
RETURN
    _result

tackytechtom

4 years ago

Hi AvPowerBI ,

Here a solution:

And here the DAX:

TomsRankColumn = 
RANKX ( 
    FILTER ( 
        'Table', 
        'Table'[TableName] = EARLIER ( 'Table'[TableName] ) &&
        'Table'[Group] = EARLIER ( 'Table'[Group] )
    ),
    'Table'[DateTime],
    , DESC
    , DENSE
)

Let me know if this works for you 🙂

/Tom
https://www.tackytech.blog/
https://www.instagram.com/tackytechtom/

TomsRankColumn = RANKX ( FILTER ( 'Table', 'Table'[TableName] = EARLIER ( 'Table'[TableName] ) && 'Table'[Group] = EARLIER ( 'Table'[Group] ) ), 'Table'[DateTime], , DESC , DENSE )

Forum Discussion

Rank Dates

Related content

Duplicate ranking

Dynamic Ranking

Rank with conditions

Ranking KPI card

What are community ranks?