Forum Discussion

taralouise123's avatar
taralouise123
Helper I
3 years ago
Solved

CONCATENATE BUT IGNORE BLANKS

I have the following code, in which I am creating a new column with the purpose of combining variables with different jurisdictions together to use with a slicer filter.   However, some of the 'Ju...
General Comment
Need Help
  • AlB's avatar
    AlB
    3 years ago

    Hi taralouise123 

    Just filter out the blanks on the table you are passing as first argument to CONCATENATEX

    FILTER(VALUES('Lead'[Juristiction]),  NOT ISBLANK('Lead'[Juristiction]))

    or

    FILTER(VALUES('Lead'[Juristiction]),  'Lead'[Juristiction] <> "")

    if it's not actual blanks but empty strings

     

    		 Please accept the solution when done and consider giving a thumbs up if posts are helpful. 

    Contact me privately for support with any larger-scale BI needs, tutoring, etc.

     

AlB's avatar
AlB
Community Champion
3 years ago

Hi taralouise123 

Just filter out the blanks on the table you are passing as first argument to CONCATENATEX

FILTER(VALUES('Lead'[Juristiction]),  NOT ISBLANK('Lead'[Juristiction]))

or

FILTER(VALUES('Lead'[Juristiction]),  'Lead'[Juristiction] <> "")

if it's not actual blanks but empty strings

 

 Please accept the solution when done and consider giving a thumbs up if posts are helpful. 

Contact me privately for support with any larger-scale BI needs, tutoring, etc.