Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

First Time Customer List

Hello Everyone,   I have a column chart where I show a count of new customers by month with "month year" along the x-axis.   Similarly, I would like to create a matrix/list that shows the name of...
Need Help
  • TomMartens's avatar
    TomMartens
    6 years ago
    Hey,

    yes it could be done, but some for effort is necessary ...

    EXCEPT returns a table, instead of using this as the 1st argument of concatenatex store this into a variable.

    Then use something like this

    CONCATENATEX(
    FILTER(ALL('<customertable>')
    , '<customertable>'[customer key] IN tablevariable
    )
    , concatenate all the column values
    , new line separator
    )

    Hopefully this is what you are looking for.

    Regards,
    Tom
  • v-xuding-msft's avatar
    v-xuding-msft
    6 years ago

    Hi Anonymous ,

    Please try to change the comma to "IN" or other operators.

    The syntax of Filter is like below. We need to write a Boolean expression for <filter>. You could reference the document to learn more.

      

    Best Regards,

    Xue Ding

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Anonymous's avatar
Anonymous
Not applicable
6 years ago

Hi Tom,

 

First off, I appreciate your help with this.  I'm still relatively new to PBI and I am trying to learn as much as I can about it, but clearly this last question is above my skill-level.  The first solution you provided works sufficiently for now.

 

My attempt at your latest suggestion is below.  I do not know DAX well enough to troubleshoot the problem with it yet.  If you could help, that would be great, but understood if not.

 

 

All the best,

 

 

Rich

 

 

v-xuding-msft's avatar
v-xuding-msft
Community Support
6 years ago

Hi Anonymous ,

Please try to change the comma to "IN" or other operators.

The syntax of Filter is like below. We need to write a Boolean expression for <filter>. You could reference the document to learn more.

  

Best Regards,

Xue Ding

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

  • Anonymous's avatar
    Anonymous
    Not applicable
    6 years ago

    Hi Everyone,

     

    I send good wishes in this time of Covid-19. 

     

    My apologies for the delay in responding on this tread, but I still face issues.  I believe I have used the IN function properly, but I am still getting an error.  Please see below and assist if possible.

     

     

    Is it problem with the # of items I am trying to concatentate?

     

    Thanks

    Rich