Carriage returns from Sharepoint List

[BrianJ]

@radley,

Try using unichar(10) as your delimiter, and make sure you have the word wrap option turned on.

Here’s a recent post where I used that trick in a card visual to return multiple lines of text:

Except, distinct, and filter?

@brixmitch, See if this does the trick: ExceptMgmt = VAR vTable = FILTER( TableB, TableB[resource type] = "Mgmt" ) VAR ADistinctID = DISTINCT( TableA[userid] ) VAR BDistinctID = SUMMARIZE( vTable, TableB[userid] ) VAR ExceptAB = EXCEPT( ADistinctID, BDistinctID ) RETURN CONCATENATEX( ExceptAB, TableA[userid], UNICHAR(10) ) [image] (Note: I’m confused by your initial example, since if you want Table B to include only records where resource type equa…

Hope this is helpful.

• Brian