By Andrew Gould

Download files here https://www.wiseowl.co.uk/power-bi/videos/dax-powerbi/concatenatex-function/

If you'd like to help fund Wise Owl's conversion of tea and biscuits into quality training videos you can join this channel to get access to perks:
https://www.youtube.com/channel/UCbi5G5PjWBaQUFy7XU_O7yw/join

Or you can click this link https://www.wiseowl.co.uk/donate?t=1 to make a donation. Thanks for watching!

See the full DAX for Power BI playlist here https://youtube.com/playlist?list=PLNIs-AWhQzclPj5BGcckuyrOVqRD-7rIX

In this video you'll learn how to use the ConcatenateX function to join values from a column into a single string. You'll learn how to create delimiters including new line characters, and how to sort the items in the concatenated string. You'll see how to insert conditional statements and emojis into the string and how to filter the items using functions like FILTER and TOPN. You'll also see how to create dynamic visual titles which is useful when combined with the Sync Slicers feature. Finally, you'll see how to use the ISFILTERED and ISCROSSFILTERED functions to help control the length of the concatenated list.

Chapters
00:00 Topic list
00:47 The Basic Setup
01:45 The ConcatenateX Function
03:44 Inserting Delimiters
05:44 Sorting the List
08:16 Adding More Information
09:54 Inserting Emojis
13:31 Filtering the Table
15:30 Showing Top N Items
17:25 Basic Sync Slicers
19:51 Dynamic Visual Titles
21:58 Using Cards for Titles
22:41 Checking if a Column is Filtered
24:22 Detecting Cross Filters
29:25 Limiting the Number of Items

Visit https://www.wiseowl.co.uk for more online training resources in Microsoft Excel, Microsoft Power BI, DAX, VBA, Python, Visual C#, Microsoft SQL Server, SQL Server Reporting Services SSRS, SQL Server Integration Services SSIS, Microsoft Access and more!