Forum Discussion
How to change columns based on another column
Hi, I am trying to get from here: To here: In other words, I would like to use Code to adjust Name and Active, yet count should be just summed up. Any idea how to do it?
Anonymous
How to get the name? Do you want to get the name which active is "yes"?
if so, you can try this.
Table 2 = SUMMARIZE('Table','Table'[CODE],"COUNT",SUM('Table'[COUNT]),"NAME",MAXX(FILTER('Table','Table'[ACTIVE]="Yes"),'Table'[Name]),"Active","Yes")
ryan_mayu
Super User
Super UserAnonymous
How to get the name? Do you want to get the name which active is "yes"?
if so, you can try this.
Table 2 = SUMMARIZE('Table','Table'[CODE],"COUNT",SUM('Table'[COUNT]),"NAME",MAXX(FILTER('Table','Table'[ACTIVE]="Yes"),'Table'[Name]),"Active","Yes")