Variables in DAX

- - - - My Courses - - - -
✔️ Mastering DAX in Power BI -

✔️ Power Query Course-

✔️ Master Excel Step by Step-

✔️ Business Intelligence Dashboards-

- - - Subscribe

- - - Download File

0:00 What are Variables
0:57 Syntax and how Variables are declared
6:48 Where in Power BI can you declare Variables
7:22 Variables in a Measure
7:57 Variables in a Column
9:07 Variables in a Table
9:55 A Common Mistake with Variables
12:10 How do variables work
15:24 3 Benefits of using Variables

[salahaldeen]

I keep re visiting this vid, thank you Chandeep

[elainelam]

Really like the ways you deliver all the complicated processes! I have learned a lot from you! Thanks so much

[agustinpena]

Man! I really like the way you structure and explain things! Thank you SO much :)

[ItsWithinYou]

Excellent explanation Chandeep! If anyone wants to learn about variables in DAX within 15 minutes then this is THE video! I appreciate your time and help!

[veebee]

Thank you so much. Your videos are always very helpful.

[capriag]

Thanks Chandeep for the value you are adding to all your viewers. Can you please clarify when to use VAR outside the formula and when should it be used inside. thanks Aseem

[lunacyfoundme]

Great video, very clear thorough explanation

[MichaelBrown-lwkz]

Awesome, awesome, awesome explanations. Wow, you are a talented instructor, sir.

[MucahitKatirci]

Thanks for the video. It was very helpful.

[KirillBezzubkine]

Actually yes. Mr is really good at explaining

[sharadkolse]

thank you so much brother, your content is really helpful

[sandeepreddy]

Thanks Chandeep for the video. Really liked all your videos.

[tableaututorialstips]

Wonderful bro :) Thanks for sharing this

[stevefox]

...as everyone said this is really well done.

[Everyonelovesyou]

On a lighter note about your intro line, I came to know after watching an year of your videos that it is "Chandeep at goodly" not "chani pad goodly". But I must say your videos are so helpful and you make it simple and easy to understand videos. Thanks

[williamarthur]

Really good video as always, but (you knew there was one coming ), you say a variable is a constant, and so do Mr R and Mr F, but in a running total measure we declare a MAX( Table [Date] ), which doesn't seem to be a Constant but returning the Max in the current filter context, the other thing is where to place them in your EARLIER video ( the best explanations I've seen) I tried using a variable instead of EARLIER and had to place it after the SUMX(TABLE, and before the Filter, not at the very beginning as is usually the case. Just to make clear I REALLY do enjoy your channel.

[kudratilla]

your teaching and explaining skills are excellent

[rajujannapreddy]

Please give a Brief introduction on the Tables and columns (DataBase) inside that could help us better understand the logic...Apart from that, Explanation is outstanding

[sachintiwari]

@Goodly, sir how do i make the variable get calculated again and again OR how variables declared inside a dax can be affected by the slicers ?

[jiandong]

Very helpful! If there were a link to your Excel working file, it would be super.