How To Use Variables in DAX Formula with Power BI

Learn how to use variables in DAX formula to simplify your code and make it far easier to understand what calculations and filtering is being done for particular results in Power BI.

***** Video Details *****
1:08 - creating a simple calculation
2:21 - writing the actual calculation
4:19 - creating multiple variables
6:32 - writing comments

***** Learning Power BI? *****

***** Related Links *****

***** Related Course Modules *****

***** Related Support Forum Posts *****

[EnterpriseDNA]

Related Links

Related Course Modules

Related Support Forum Posts

[allonewordlowercase]

Very helpful mate. Trying to wrap my head around variables at the moment and this video has resonated with me the most.

But please use shift enter - it stops that awful sound each time you go to a new line

[adriaanb]

binge watching all videos, love the very structured approach to writing DAX, page design etc, will copy! Best Power BI series I found so far. Playlists would be helpful..

[automationguide]

Thank You !!

Can I use IF condition in RETURN CLAUSE.

If I want to segregate my sales into three categories GOOD, BAD, NORMAL

[alangolding]

Excellent video, curious, if I am connecting to a datasource using Direct Query, the datasource already has a predefine variable available, so instead of creating a variable inside of PowerBI is there a way I can call upon that variable from the datasource

[capriag]

Thanks Sam for the video. Can your please help clarify when to use VAR outside the formula and when should it be used inside. thanks Aseem

[musafirq]

What if I need sum(Sales) for some category and average sales for some other set of category provided that the category is a column in my data. How can I create a measure which will show both sum(Sales) and Avg (sales) for both set of categories in a table chart

[aonline-training]

Where Can i download the data from? would like to practice on this DATA. I have also signed up for the entire course @DNA Enterprise.

[mshparber]

Thank you!
Can you use VAR from one measure in other measures?

[PraxeoIogy]

Can you update a variable, or set a variable as a modification to itself, as opposed to having a really large nested if statement or creating multiples to arrive at the final e.g. Var1 = Substitute(Var1, "text", "")

[ZombieBrainz]

Great content! Subscribed.
Question: do you know how to make multiple API calls (a for loop kinda) when importing data. E.g. Twitter API only allows you to pull 100 entries at a time. I'm looking at getting 500. Haven't been able to figure it out. Thanks for what you do - learning a lot!

[HoppiHopp]

Now I understand variables but I’m lost at calculate. What does that? Where is the calculation? This looks like another filter to me.

[faustdw]

great videos, but please move your mic away for the keyboard. :)

[pantomima]

It is not good to do "ch" voice during the presentation. I had similar problem before. My course mates mentioned it and I started to work on it.