By Andrew Gould

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