Forum Discussion

Dan_Machen's avatar
Dan_Machen
Frequent Visitor
8 years ago
Solved

Sequentially concatenating row values

Hi, I have a table that looks like this   ACCOUNT Attempt CH_ATTEMPT_STATUS 00000001 1 S 00000001 2 N 00000002 1 S 00000002 2 N 00000002 3 N 00000003 1 F 00000...
  • Vvelarde's avatar
    Vvelarde
    8 years ago

    Dan_Machen

     

    Hi, try with this calculated column

     

    CH-PAT = CONCATENATEX(FILTER(Table1,Table1[ACCOUNT]=EARLIER(Table1[ACCOUNT]) && Table1[Attempt]<=EARLIER(Table1[Attempt])),Table1[CH_ATTEMPT_STATUS],,Table1[Attempt],ASC)

    Regards

     

    Victor

    Lima - Peru

  • Zubair_Muhammad's avatar
    Zubair_Muhammad
    8 years ago

    Dan_Machen

     

    This Calculated Column will also get you the desired RESULTS :smileywink:

     

    Column =
CONCATENATEX (
    TOPN (
        TableName[Attempt],
        FILTER ( TableName, TableName[ACCOUNT] = EARLIER ( TableName[ACCOUNT] ) )
    ),
    TableName[CH_ATTEMPT_STATUS],,
    TableName[Attempt]
)

     

     

Vvelarde's avatar
Vvelarde
Icon for Community Champion rankCommunity Champion
8 years ago

Dan_Machen

 

Hi, try with this calculated column

 

CH-PAT = CONCATENATEX(FILTER(Table1,Table1[ACCOUNT]=EARLIER(Table1[ACCOUNT]) && Table1[Attempt]<=EARLIER(Table1[Attempt])),Table1[CH_ATTEMPT_STATUS],,Table1[Attempt],ASC)

Regards

 

Victor

Lima - Peru

  • Zubair_Muhammad's avatar
    Zubair_Muhammad
    Icon for Community Champion rankCommunity Champion
    8 years ago

    Dan_Machen

     

    This Calculated Column will also get you the desired RESULTS :smileywink:

     

    Column =
CONCATENATEX (
    TOPN (
        TableName[Attempt],
        FILTER ( TableName, TableName[ACCOUNT] = EARLIER ( TableName[ACCOUNT] ) )
    ),
    TableName[CH_ATTEMPT_STATUS],,
    TableName[Attempt]
)

     

     

    • Dan_Machen's avatar
      Dan_Machen
      Frequent Visitor
      8 years ago

      Brilliant, thanks!