Create Sequence Number using DAX

Question

Hi,&nbsp;I need create Sequence number using DAX function.&nbsp; Here is an example&nbsp;DEPT NO&nbsp;&nbsp;&nbsp;EMP NO&nbsp;&nbsp; SEQNO10&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 100&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 310&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 200&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 210&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 300&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 120&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 400&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 320&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;500&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;220&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 600&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 1&nbsp;I tried using Rankx&nbsp; but could not get it right.&nbsp;Thanks&nbsp;

v-yulgu-msft · Accepted Answer

Hi&nbsp;dp106,
&nbsp;
For calculated column,
SEQNO =
RANKX (
    FILTER ( Table8, Table8[DEPT NO] = EARLIER ( Table8[DEPT NO] ) ),
    Table8[EMP NO],
    ,
    DESC,
    DENSE
)

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

&nbsp;
Best regards,
Yuliana Gu

Forum Discussion

Create Sequence Number using DAX

2 Replies

Related content

Week Number Sequence

Sequence Row number 1,2,3

Sequence number

Sequencing Numbering within a Group Based off Unique Values

column number sequence reversal