RANX Outflow of Clients

[tomwolswijk]

Hi,

By using the RANX function, I understand how to get the new inflow of clients.

However, I am unable to calculate the outflow in a column using the RANX function.

Calculate inflow over time: 

Rank = 
RANKX(FILTER('Table','Table'[Client ID]=EARLIER('Table'[Client ID])),'Table'[Date],,ASC,Dense)

If a client gets Rank "1", this client is new in the dataset (compared with previous date).

Can I also convert this formula so that I can see the outflow of clients?

So that the client gets Rank "1" when a customer is in the data set for the last time (Rank ouflow)?

Client ID	Date	Rank (inflow)	Rank (outflow)
1	01-2020	1	3
2	01-2020	1	2
1	02-2020	2	2
2	02-2020	2	1
1	03-2020	3	1
3	07-2020	1	2
3	08-2020	2	1

Regards,

Tom

[manikumar34 · Accepted solution]

@tomwolswijk

test the same measurement with DESC as follows.

Rank a 
RANKX(FILTER('Table','Table'[Client ID]-EARLIER('Table'[Client ID])),'Table'[Date],DESC,Dense)

Best regards

Manikumar