Create a new index column base on two columns

[Rigoleto]

Need some DAX code to build a new Index column, as the screen shoot shown, I need use the column "NAME" and "Index' to build the new one.

Thanks in advance for your help

[RMDNA]

Hi @Rigoleto,

What's the logic here? I don't see a pattern in the new index.

[Rigoleto]

Sorry,

Basically the logic is this, notice that the column name has two diferences descriptions, "UNIR HOMBROS" and "UNIR HOMBRO 1", and every sigle descrition has they own sub division, "AVERAGE", "GOAL" and "MAX", I need to build something like the sceenshot shown

[Zubair_Muhammad]

@Rigoleto

Try this technique

First Add another Index Column from Query Editor

Then may be this calculated column will do the job

Column =
VAR Counts =
    CALCULATE (
        COUNT ( Table1[NAME] ),
        FILTER ( Table1, [NAME] = EARLIER ( [NAME] ) )
    )
RETURN
    IF (
        Counts = 1,
        RANKX (
            FILTER (
                Table1,
                CALCULATE (
                    COUNT ( Table1[NAME] ),
                    FILTER ( Table1, [NAME] = EARLIER ( [NAME] ) )
                )
                    = 1
            ),
            [NAME],
            ,
            DESC,
            DENSE
        ),
        RANKX ( FILTER ( Table1, [NAME] = EARLIER ( [NAME] ) ), [Index],, ASC, DENSE )
    )

[Zubair_Muhammad · Accepted solution]

@Rigoleto

Please see attached file

[Rigoleto]

Thanks a lot for this input guys,

I did add the logic but, I getting this error, any comments about this issue?

[Rigoleto]

Sorry guys,

Ignore my previous post, I did have a lapsus stupidus, 🙂

[v-juanli-msft]

Hi 

So Zubair_Muhammad's solution really helps you, right?

After testing, the solution turns out to be correct.

Could you kindly mark the answer as a solution?

Best Regards

Maggie