Need help in DAX Code for CALCULATED Column

[AyanMazumder]

Hello Guru's,

I have a table below -

I am planning to write DAX code for a CALCULATED Column which should give the following output mentioned in the table below.

Can you please help me to write the DAX code for calculated column Revised_WBS = ?

[lbendlin · Accepted solution]

Revised_WBS = 
var v=Table[WBS]
var i=Table[Index]
var c=COUNTROWS(FILTER(Table,Table[Index]<i && Table[WBS]=v))
return v & REPT("0",c)

[AyanMazumder]

Many thanks.....