Forum Discussion

sprasad's avatar
sprasad
Helper II
7 years ago
Solved

Working with Custom Column

Hi,   1. I am trying to prepare a bug metrics to check the %age of bug has been fixed till now:   %age of Bug fixed is = Total no of Bugs in Closed State/ (Total bugs in Closed State+Total bugs i...
Need Help
  • PattemManohar's avatar
    PattemManohar
    7 years ago

    sprasad  After performing the steps posted above, then create a new table as below

     

    Test187Final = SUMMARIZE(Test187,Test187[Project],"Custom",MAX(Test187[Custom]))

Zubair_Muhammad's avatar
Zubair_Muhammad
Community Champion
7 years ago

sprasad 

 

As a custom Column, you can use this

 

Please see attached file's query editor

 

ChangedType is the name of previous step

=let  myproject=[Project]
      in
let 
mystates=Table.SelectRows(ChangedType, each [Project]=myproject)[State],

numerator=Table.SelectRows(ChangedType, each [Project]=myproject and [State]="Closed")[CountIssues],

denominator=Table.SelectRows(ChangedType, each [Project]=myproject)[CountIssues] 

in

if List.Contains(mystates,"New") then List.Sum(numerator)/List.Sum(denominator) else 0
sprasad's avatar
sprasad
Helper II
7 years ago

Hi Zubair,

Thanks for your help, Actually i couln't work through your code. where can i get the references or help of the code you worte?

 

Thanks

Sudhir