[OLAP],[SSAS] Report on new/departed clients?

Question

data mining

There is a DB of the trading office. There is a list of facts about the sale of goods to customers (with links to customers, type of goods, everything is like in Northwind).
On top of this, an OLAP cube is configured on SSAS , through which managers look at some reports there.
The task is to expand the functionality of the reporting system with the withdrawal of new, old and departed customers.
More precisely, there is even a description of the client state model (new, existing, inactive, returned, gone).
According to the client's tradition, these transitions are tied to months. That is, for example, a client is considered to have returned if he had no orders last month (he was in the INACTIVE status), and at least one appeared this month.
These states must be removed.
I have a few thoughts on where in the architecture to enter this calculation.
* at the data warehouse level, enter a new field in the order. Calculation - in SQL
* set up something in the cube (KPI, Calculated members or something else). I'm digging this thread right now.
* write an MDX query to some kind of cube.
* While I was writing the post, I got the idea to add a generally new calculated table of status changes to the data warehouse.
But I would like to first find out from the community where and how it would be right to do this, so that later it would be convenient for managers to work with these regular OLAP clients (read, Excel)

Answer 1

measured measure

Answer 2

The article closest to the topic of the question I found:
cwebbbi.wordpress.com/2010/10/08/counting-new-and-returning-customers-in-mdx/