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

Good Morning,

Using your formula I end up with

I am not sure that I understand where your issue is occuring. Can you elaborate as to what issue(s) you are seeing?

 

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

HI Jgeddes

 

I was just trying to provide an example of what I am looking for. The last formula is one you gave to me and it works perfectly. The concatenate formula is proving with all the services (all the services are in one row).

 

My problem now is that CUIDs and Countries are in different rows and the formula is not working.

You can forget about the last part with the "concatenate formula". it was just an example

 

Thnaks