Forum Discussion

graefs's avatar
graefs
Frequent Visitor
1 year ago
Solved

Custom Column for Unique ID

I am looking to create a column that categorizes each group based on the result of multiple columns.    A: IPC = No; Client = A B: IPC = No;  Client = B Mixed: IPC = No; Client = A and B IPC: IP...
Need Help
Tips and Tricks
  • ryan_mayu's avatar
    ryan_mayu
    1 year ago

    graefs 

    you can try this

     

    Column =
    var _ipc=maxx(FILTER('Table','Table'[Group]=EARLIER('Table'[Group])&&'Table'[IPC]="Yes"),'Table'[IPC])
    var _count =CALCULATE(DISTINCTCOUNT('Table'[Client]),ALLEXCEPT('Table','Table'[Group]))
    return if(_ipc="Yes" && _count>1,"IPC Mixed",if(_ipc="" && _count>1,"Mixed",'Table'[Client]))
     
Kaviraj11's avatar
Kaviraj11
Solution Sage
1 year ago

Hi,

 

Create a new column:

 

Category =
SWITCH(
TRUE(),
'Table'[IPC] = "No" && 'Table'[Client] = "A", "A",
'Table'[IPC] = "No" && 'Table'[Client] = "B", "B",
'Table'[IPC] = "No" && 'Table'[Client] IN {"A", "B"}, "Mixed",
'Table'[IPC] = "Yes" && 'Table'[Client] = "A", "IPC",
'Table'[IPC] = "Yes" && 'Table'[Client] = "B", "IPC Mixed",
BLANK()
)