Channel: WiseOwlTutorials

Category: Education

Tags: visualizationconcatenateimportstringfree tutorialbasic daxreplacemidtext functionssubstitutedax basicsintroduction to daxsearchbasic expressionlentrimpbixbeginnerif functiondelimiterfinddaxtutorialtextgetting started with daxiftableonline trainingcolumnpower bibasic calculationpower bi desktopconcatrightfree trainingcombine valuesonline tutorialcalculated columnleftpbiwise owldata analysis expressions

Description: By Andrew Gould Download files here 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: youtube.com/channel/UCbi5G5PjWBaQUFy7XU_O7yw/join Or you can click this link 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 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 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!