The ultimate Fabric, Power BI, SQL, and AI community-led learning event. Save €200 with code FABCOMM.
Get registeredCompete to become Power BI Data Viz World Champion! First round ends August 18th. Get started.
Hello,
I have a table which contains data for people travelling together. I am trying to produce a table visual which combines the email addresses of all persons on the same trip on one line. I have one working, BUT, if a traveller does not have an email address, it comes back null and includes a semicolon. I would like them ignored completely.
Below is a screenshot of my measure and how it is currently performing. The green circled items are what I would like to avoid.
Sample Data:
Trip Code | |
123456 | amanda@gmail.com |
123456 | |
123456 | earnest@gmail.com |
987654 | bertha@gmail.com |
987654 | patrick@gmail.com |
987654 | ashley@gmail.com |
Goal Result:
Trip Code | Emails |
987654 | bertha@gmail.com;patrick@gmail.com;ashley@gmail.com; |
123456 | amanda@gmail.com;earnest@gmail.com |
Hi @apmulhearn ,
I think you can try code as below to create a measure.
EmailLis =
VAR _COMBINE =
CONCATENATEX (
FILTER ( 'Table', 'Table'[Email] <> BLANK () ),
'Table'[Email],
";"
)
RETURN
IF ( _COMBINE = ";", BLANK (), _COMBINE )
Best Regards,
Rico Zhou
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.