Calculate with previous Rank

[HeartFoundation]

Hi! I have not been able to find a solution to this (or maybe I didn't understand the solutions correctly), so please help me 🙂

I have a table with all client subscription transactions and a column to calculate the payment month since first payment (Betalingsmnd), based on the Date-column (BogDato).

And a matrix which shows the sales (Beloeb) of all acquisition months (x) and the following months of sales standardized for easy comparison by the rank in Betalingsmnd (y).

I would like to calculcate the percentage sales change since last month, which current rank (e.g. 4) means compared to the last rank (e.g. 3), and for each row of acquisition months. But I simply cannot get it to work. I have tried using measures such as this:

CALCULATE ( SUM ( Beloeb ) , FILTER ( Transactions [Betalingsmnd] ; Betalingsmnd - 1 ) )

And MAX, Previousmonth, DATEADD etc.

Thank you very much 🙂

[v-kelly-msft · Accepted solution]

Hi @HeartFoundation ，

Try modifying your measure as below:

Measure =CALCULATE ( SUM ( Beloeb ) , FILTER ( ALL('Transactions'); [Betalingsmnd]=MAX([Betalingsmnd]) - 1 ) )

See an example as below:

Best Regards,
Kelly

Did I answer your question? Mark my post as a solution!