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],","))

Ashish_Mathur's avatar
Ashish_Mathur
Icon for Super User rankSuper User
8 years ago

Hi,

 

You may refer to my solution here.

 

Hope this helps.

 

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

    Hi Ashish_Mathur

     

    This one had already been answered.