Forum Discussion
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 = ?
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
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)Many thanks.....
