Channel: WiseOwlTutorials

Category: Education

Tags: visualizationblankimportfree tutorialbasic daxiferrorerrordax basicsintroduction to daxpbixif functiondaxtutorialgetting started with daxtableonline trainingcolumnpower bipower bi desktopfree trainingiserroronline tutorialcalculated columnpbierror handlingwise owldata analysis expressions

Description: By Andrew Gould 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! Download files here wiseowl.co.uk/power-bi/videos/dax-powerbi/dax-error-functions This video explains how to deal with errors in your DAX calculated column expressions. You'll learn how to use the IsError and IfError functions to replace errors when they occur, as well as how to use the If function to avoid some errors in the first place. You'll see how to use the Divide function to help avoid divde by zero errors. You'll see errors related to data type conversions and also how to use the alternate result parameter of some functions to avoid errors. Chapters 00:00 Topic list 00:47 Importing Data 01:30 Dividing with Zeroes 03:19 The IsError Function 05:06 The IfError Function 06:06 Avoiding the Error 07:18 Using the Divide Function 08:19 Other Problems with Dividing 11:56 Problems with Converting Data Types 13:17 Converting Text to Numbers 14:40 Alternate Result Parameters 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!