Rolling Grouped By Count Calculated Column

[Anonymous]

Hello.

I need help in figuring out the calculation to get the following results:

I need it in a calculated column to be able to use it as an axis for my visuals.

Appreciate your help! 🙂

[OwenAuger · Accepted solution]

Hi @Anonymous

Have a look at this article on SQLBI - they recommend a pattern using RANKX:

How to compute index numbers at top speed

In your case, the DAX for the calculated column could look something like this:

Customer Transaction Index =
RANKX (
    FILTER (
        Transactions,
        Transactions[Customer] = EARLIER ( Transactions[Customer] )
    ),
    Transactions[Transaction],
    ,
    ASC,
    DENSE
)

Regards,

Owen 🙂