Channel: WiseOwlTutorials

Category: Education

Tags: visualizationtest for blankblankimportisnullfree tutorialbasic daxdax basicsintroduction to daxbasic expressionpbixbeginnerif functiondaxisblank()tutorialgetting started with daxiftableonline trainingcolumncoalescepower bibasic calculationisblankpower bi desktopreplace blankfree trainingblank()online tutorialcalculated columnnullpbicheck if blankwise owldata analysis expressions

Description: By Andrew Gould Download source data here wiseowl.co.uk/power-bi/videos/dax-powerbi/dax-blanks 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 shows you how to work with blanks in your DAX expressions for calculated columns. You'll learn you to test for blanks using the IsBlank function and the Blank function. You'll see the difference between the equal to and strictly equal to operators and the importance of that difference when it comes to working with blanks. You'll learn how to produce a blank as the result of an expression and what happens when you involve a blank in some basic arithmetic. Finally, you'll see how to concatenate a blank into a string and how to use the Coalesce function to produce a replacement value. Chapters 00:00 Topic list 00:40 Importing Data 01:20 Using the IsBlank Function 03:55 Using the Column in a Visual 04:37 Using the Blank Function 06:43 The Strictly Equal To Operator 09:45 Blanks in Arithmetic Expressions 11:20 Returning a Blank from an Expression 13:09 Returning Blank by Default 14:20 Blanks and Empty Strings 16:32 Concatenating Blanks and the Coalesce Function 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!