Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
9 years ago
Solved

Rolling Grouped By Count Calculated Column

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! :)

Need Help
  • OwenAuger's avatar
    OwenAuger
    9 years ago

    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 :)

1 Reply

  • OwenAuger's avatar
    OwenAuger
    Super User
    9 years ago

    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 :)