Forum Discussion

AyanMazumder's avatar
AyanMazumder
New Member
6 years ago
Solved

Need help in DAX Code for CALCULATED Column

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 = ?

 

DAX
  • lbendlin's avatar
    lbendlin
    6 years ago
    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)

2 Replies

  • lbendlin's avatar
    lbendlin
    Super User
    6 years ago
    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)