By Andrew Gould

Download files here https://www.wiseowl.co.uk/power-bi/videos/dax-powerbi/dax-text-calculated-columns/

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!

This video covers a variety of DAX functions for working with text. You'll learn how to join text together using the Concatenate and CombineValues functions and the concatenation operator. You'll see how to use the Format function to apply standard and custom formats to values. You'll learn how to extract text from the left, right and middle of a string, as well as how to locate the characters you want to extract using the Find or Search functions. You'll find out how to remove extra spaces from a string and how to calculate the length of a string. Finally, you'll see how to use the Replace or Substitute functions to replace one piece of text with another.

The Format Function https://docs.microsoft.com/en-us/dax/format-function-dax

Chapters
00:00 Topic list
00:46 Importing Data
01:28 A Simple Reason for Concatenating Values
03:17 Using the Concatenate Function
04:53 Creating an Index Column
06:40 Nesting Concatenate Functions
08:01 The CombineValues Function
09:17 The Concatenate Operator
11:37 Concatenating a Date with Text
14:12 Concatenating Formatted Columns
15:21 Using the Format Function
18:47 Extracting Text from the Left of a String
21:32 Grouping the Numbers Together
23:12 The Search and Find Functions
25:39 Trimming Text
27:05 Using the Len Function
29:09 Using the Right Function
32:06 Replacing or Substituting Text

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!