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:
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!

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