Forum Discussion

romovaro's avatar
romovaro
Icon for Responsive Resident rankResponsive Resident
3 years ago
Solved

CONCATENATE different rows

HI Pbix community and Happy Friday,   I need help with a Formula. I have a customer table and every customer has small entitites based in different countries with different CUID number.   ...
Need Help
  • romovaro's avatar
    romovaro
    3 years ago

    HI jgeddes,

     

    NO worries. Tried again with the formulas and now is working. 

    Thanks,

     
    Distinct Countries =
    CONCATENATEX(
    FILTER(
    SUMMARIZE('Weekly Slippage','Weekly Slippage'[Client Name],'Weekly Slippage'[Country]),'Weekly Slippage'[Client Name]=EARLIER('Weekly Slippage'[Client Name])
    ),
    'Weekly Slippage'[Country],
    " & "
    )
     
     
    Distinct CUIDs =
    CONCATENATEX(
    FILTER(
    SUMMARIZE('Weekly Slippage','Weekly Slippage'[Client Name],'Weekly Slippage'[CUID]),'Weekly Slippage'[Client Name]=EARLIER('Weekly Slippage'[Client Name])
    ),
    'Weekly Slippage'[CUID],
    " & "
    )
     

     

     
jgeddes's avatar
jgeddes
Icon for Super User rankSuper User
3 years ago

Can you show me what you mean by the countries and CUIDs are in different rows?

romovaro's avatar
romovaro
Icon for Responsive Resident rankResponsive Resident
3 years ago

HI jgeddes,

 

NO worries. Tried again with the formulas and now is working. 

Thanks,

 
Distinct Countries =
CONCATENATEX(
FILTER(
SUMMARIZE('Weekly Slippage','Weekly Slippage'[Client Name],'Weekly Slippage'[Country]),'Weekly Slippage'[Client Name]=EARLIER('Weekly Slippage'[Client Name])
),
'Weekly Slippage'[Country],
" & "
)
 
 
Distinct CUIDs =
CONCATENATEX(
FILTER(
SUMMARIZE('Weekly Slippage','Weekly Slippage'[Client Name],'Weekly Slippage'[CUID]),'Weekly Slippage'[Client Name]=EARLIER('Weekly Slippage'[Client Name])
),
'Weekly Slippage'[CUID],
" & "
)