Forum Discussion

Helper I

7 years ago

Solved

Create Sequence Number using DAX

Hi, I need create Sequence number using DAX function. Here is an example DEPT NO EMP NO SEQNO 10 100 3 10 200 2 10 300 ...

7 years ago

For calculated column,

SEQNO =
RANKX (
    FILTER ( Table8, Table8[DEPT NO] = EARLIER ( Table8[DEPT NO] ) ),
    Table8[EMP NO],
    ,
    DESC,
    DENSE
)

For measure,

SEQNO measure =
RANKX (
    ALLEXCEPT ( Table8, Table8[DEPT NO] ),
    CALCULATE ( SUM ( Table8[EMP NO] ) ),
    ,
    DESC,
    DENSE
)

Best regards,

Yuliana Gu

Microsoft Employee

7 years ago

For calculated column,

SEQNO =
RANKX (
    FILTER ( Table8, Table8[DEPT NO] = EARLIER ( Table8[DEPT NO] ) ),
    Table8[EMP NO],
    ,
    DESC,
    DENSE
)

For measure,

SEQNO measure =
RANKX (
    ALLEXCEPT ( Table8, Table8[DEPT NO] ),
    CALCULATE ( SUM ( Table8[EMP NO] ) ),
    ,
    DESC,
    DENSE
)

Best regards,

Yuliana Gu