Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

RANKX

Hi,

 

I'm using the following formula to perform a ranking:

 

 =RANKX(FILTER('DM FKT_POWERAPP_KPIBYGG_STRATEGIKART','DM FKT_POWERAPP_KPIBYGG_STRATEGIKART'[ORG.CONCAT] = EARLIER('DM FKT_POWERAPP_KPIBYGG_STRATEGIKART'[ORG.CONCAT])),'DM FKT_POWERAPP_KPIBYGG_STRATEGIKART'[REGISTRERT_DATO])

 

The logic behind it is that as a new row gets inserted (Analysis Services, Visual Studio) in the table, the group member associated with that row will get assigned a new sequantial numeric value in descending order. The newest row should have the highest ranking for that particular group member. The current formula gives the newst row the lowest value. How do I account for that?

 

 

Current    What I want 
         
Group memberDatetimeRanking   Group memberDatetimeRanking
         
X2/16/2020 12:263   X2/16/2020 12:261
Y2/16/2020 12:315   Y2/16/2020 12:311
X2/16/2020 12:332   X2/16/2020 12:332
X2/16/2020 12:371   X2/16/2020 12:373
Y2/16/2020 12:384   Y2/16/2020 12:382
Y2/16/2020 12:413   Y2/16/2020 12:413
Y2/27/2020 11:042   Y2/27/2020 11:044
Y2/27/2020 12:141   Y2/27/2020 12:145

 

 

BR Lars

 

Need Help