Fabric is Generally Available. Browse Fabric Presentations. Work towards your Fabric certification with the Cloud Skills Challenge.
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. |
Check out the November 2023 Power BI update to learn about new features.
Read the latest Fabric Community announcements, including updates on Power BI, Synapse, Data Factory and Data Activator.