Channel: WiseOwlTutorials

Category: Education

Tags: logical expressionvisualizationimportfree tutoriallogical testbasic daxswitch functionswitchdax basicsintroduction to daxbasic expressionpbixbeginnerdaxtutorialgetting started with daxiftablecasecommentsonline trainingcolumnfalsepower bibasic calculationpower bi desktopfree traininglogicalonline tutorialcase expressioncalculated columntrue falsepbitruetrue functionwise owldata analysis expressions

Description: By Andrew Gould Download files here wiseowl.co.uk/power-bi/videos/dax-powerbi/switch-function-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 use the Switch function in calculated columns in DAX. You'll learn how to test a column value against a list of constants, how to use the True function to enable your Switch function to include logical tests, and the importance of the order in which you write those tests. Chapters 00:00 Topic list 00:39 Importing Data 01:26 Creating a Basic Switch Expression 04:19 Adding more Values and Results 05:37 Using the Else Parameter 06:27 Writing Logical Tests in a Switch Function 09:38 Adding More Logical Tests 10:55 The Order of Logical Tests 12:35 Referencing Different Columns in the Same Switch Function 15:14 Using the Columns in Visualisations 16:24 Using Switch to Create a Sort By Column 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!