Microsoft is giving away 50,000 FREE Microsoft Certification exam vouchers. Get Fabric certified for FREE! Learn more
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 'Jurisdiction' rows are blank and therefore I would like to include in my code the condition to ignore the empty Jurisdiction rows and only make concatenation when values appear, e.g. instead of " & Isle of Man" it say just "Isle of Man" if one is blank.
Could anyone please indicate where should I include this part in my code?
Solved! Go to Solution.
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. |
Thanks a lot! It worked!
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. |
User | Count |
---|---|
96 | |
67 | |
57 | |
47 | |
46 |