RankX Filter Earlier

[rsj88]

Hi,

I have the below data set

Date	Group	Name	Rank
01/01/19	A	Tim	1
02/01/19	A	Tim	2
04/01/19	A	Dave	1
05/01/19	A	Peter	1
04/01/19	C	Tim	1
07/01/19	A	Dave	2
07/01/19	B	Tim	1
03/01/19	A	Tim	3

I trying to do a Rankx Filter Earlier to rank the name by group by the earlierst date. (Rank above is how it should be). Any Ideas?

Thanks in advance

 

[JustynaMK]

Hi,

You might want to try to use this calculated column -

cRank = 
    var ThisGroup = TableRank[Group]
    var ThisName = TableRank[Name]
    var ThisDate = TableRank[Date]
    var t = FILTER(TableRank, 
                TableRank[Group] = ThisGroup 
                && TableRank[Name] = ThisName
                && TableRank[Date] < ThisDate)
return
    COUNTROWS(t) + 1

 

[rpadminserver]

Hi,

You might want to try to use this calculated column -

cRank =
    var ThisGroup = TableRank[Group]
    var ThisName = TableRank[Name]
    var ThisDate = TableRank[Date]
    var t = FILTER(TableRank,
                TableRank[Group] = ThisGroup
                && TableRank[Name] = ThisName
                && TableRank[Date] < ThisDate)
return
    COUNTROWS(t) + 1

View attachment 12082

Hi.....JustynaMK

This is almost exactly what I need. Your code above is ranking the date in ASC order, What do I have to change to rank in DESC order
Thank

 

[JustynaMK]

Hi, sure - as far as I remember, the purpose of the first table was to rank Name & Group by a Date field. For example, Tim in group A (I have added a column that combines these two together) has three records, and they are ranked by date (from oldest to newest).

In order to rank from newest to oldest, you literally just need to change "<" to ">":

 

[rpadminserver]

THANKS, that did it