Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
8 years ago
Solved

Assign unique identifier based on multiple attributes

Hello,    I have a set of data that describes case work coming into a support organization, including who owns it during different points over the case lifecycle. What I need to do is describe each...
  • Phil_Seamark's avatar
    Phil_Seamark
    8 years ago

    Hi Anonymous

     

    This calculated table might be close.

     

    Table = 
VAR DistinctValues = SUMMARIZECOLUMNS('Table1'[Case],'Table1'[Team])
VAR Final = SUMMARIZECOLUMNS('Table1'[Case])
RETURN ADDCOLUMNS(
            Final ,
            "Group" , CONCATENATEX(
                            FILTER(DistinctValues,[Case] = EARLIER('Table1'[Case])),
                            [Team],","))

Phil_Seamark's avatar
Phil_Seamark
Icon for Microsoft Employee rankMicrosoft Employee
8 years ago

Hi Anonymous

 

This calculated table might be close.

 

Table = 
VAR DistinctValues = SUMMARIZECOLUMNS('Table1'[Case],'Table1'[Team])
VAR Final = SUMMARIZECOLUMNS('Table1'[Case])
RETURN ADDCOLUMNS(
            Final ,
            "Group" , CONCATENATEX(
                            FILTER(DistinctValues,[Case] = EARLIER('Table1'[Case])),
                            [Team],","))

Anonymous's avatar
Anonymous
Not applicable
8 years ago

Thank you Phil, this has helped open me up to the use of Variables, something I hadn't been familiar with previously. This is a huge help - and I'm finding I can do much more with it now!