By Andrew Gould

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