Channel: WiseOwlTutorials

Category: Education

Tags: &&||visualizationimportfree tutoriallogical testbasic daxor functiondax basicsintroduction to daxbasic expressionpbixbeginnerif functionanddaxtutorialgetting started with daxiftableand functioncommentsorinonline trainingcolumnpower bibasic calculationpower bi desktopfree trainingonline tutorialcalculated columnpbinested ifwise owldata analysis expressions

Description: By Andrew Gould This video shows you how to create calculated columns using the If function in DAX. You'll learn how to write basic logical tests, how to create columns to use as categories or values and how to write nested If functions. You'll also find out how to use the And function and && operator, as well as the Or function and || operator. Finally, you learn how to use the In operator in 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! Download the source data here wiseowl.co.uk/power-bi/videos/dax-powerbi/if-function-dax Chapters 00:00 Topic list 00:53 Importing the Sample Data 01:42 Creating a Basic If Expression 05:10 Using the Results in a Visual 06:22 Creating a Value Column with the If Function 09:10 Using the Value Column in a Visual 10:14 Nesting Expressions in an If Function 12:35 Nested If Functions 15:28 Combining Conditions with the And Function 17:53 Using the And Operator 20:07 Combining Conditions with the Or Function 22:20 The Or Operator 23:14 Combining Multiple Logical Operators 25:42 Multiple Or Operators 27:55 Using the In Operator 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!