Channel: WiseOwlTutorials

Category: Education

Tags: visualizationconcatenateimportfree tutorialbasic daxdax basicsintroduction to daxbasic expressionpbixbeginnerdaxdividetutorialgetting started with daxtablecommentsonline trainingcolumnpower bibasic calculationpower bi desktopfree trainingintonline tutorialdata typecalculated columnpbidecimalwise owldata analysis expressions

Description: By Andrew Gould Download files here wiseowl.co.uk/power-bi/videos/dax-powerbi/calculated-columns-dax 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 explains how to create calculated columns in DAX. You'll learn about the important concept of Row Context and a variety of ways to reference a column in a DAX expression. You'll see how to add comments and lay out your code for readability. You'll learn about the order of operation and how to control it and how to use some basic DAX functions. You'll also see how DAX adjusts the data type of a column as you make changes to the expression. Finally, you'll learn how to concatenate multiple values to create a longer value. Chapters 00:00 Topic list 00:47 Importing the Sample Data 02:17 Calculated Columns and Row Context 03:53 Creating a Simple Calculated Column 08:04 Alternative Ways to Reference Columns 11:25 Comments and Multiple Lines 15:01 Using Calculated Columns in Report Visuals 16:42 Controlling the Order of Operation 19:33 Referring to Existing Calculated Columns 20:28 Using a Function to Divide Values 24:11 Implicit Data Type Conversion 26:53 Converting a Decimal to a Whole Number 30:15 Concatenating Text 31:37 Calculating the Remainder of a Division 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!