Channel: WiseOwlTutorials

Category: Education

Tags: temporary tablevariablestable variablefree tutorialvaronline trainingpower bifree trainingmicrosoftbusiness intelligencetemp tableonline tutorialreportvariabledeclare variablevariable data typesdaxtutorialwise owl

Description: By Andrew Gould Download files here wiseowl.co.uk/power-bi/videos/dax-powerbi/dax-variables 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 explains how to use variables in DAX to break a large calculation into discrete parts. You'll learn how to declare and assign values to variables in calculated columns and measures, and how to refer to variables in your code. You'll see how to declare variables within a function to create variables with a limited scope, and how to create variables which can hold the results of a table expression. Chapters 00:00 Topic list 00:30 Creating a Calculated Column 03:52 Declaring and Using DAX Variables 07:03 Using Multiple Variables 08:04 Attempting to Change Variable Values 09:43 Testing for Blanks 11:41 Nesting Variables 14:37 Creating a Measure 16:22 Using Variables in Measures 17:56 Excluding Blanks 21:51 Using Table Variables 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!