By Andrew Gould

Download files here https://www.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:
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 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 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!