Variables in DAX

[@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!

[@GoodlyChandeep]

Glad you like it 💚

[@elainelam6883]

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

[@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

[@GoodlyChandeep]

"Chani pad goodly".. Haha!
I've got to say my name more clearly.

[@agustinpena948]

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

[@GoodlyChandeep]

Glad it helped! :)

[@MichaelBrown-lw9kz]

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

[@kudratilla]

your teaching and explaining skills are excellent

[@GoodlyChandeep]

Thanks Man.. glad you enjoyed the video. More to come

[@salahaldeen7924]

I keep re visiting this vid, thank you Chandeep

[@lunacyfoundme]

Great video, very clear thorough explanation

[@veebee3969]

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

[@KirillBezzubkine]

Actually yes. Mr is really good at explaining

[@sharadkolse6871]

thank you so much brother, your content is really helpful

[@rajujannapreddy7214]

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

[@shreyamukkawar2989]

Clear and perfect explanation

[@GoodlyChandeep]

Glad you liked it

[@Analyse_US]

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

[@williamarthur4801]

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.

[@MucahitKatirci]

Thanks for the video. It was very helpful.

[@sandeepreddy7687]

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

[@GoodlyChandeep]

Glad to hear that

[@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

[@jiandong8351]

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

[@KaranNayyarBCS]

Nicely Explained. Thanks !

[@tomaskavicky]

very clear explanation, thanks !

[@TRZMac]

At minute 10:48 I see you wrapped your CalTable Var with a filter in the second Variable, isn't it true that variables cannot be filtered?
So your filter argument in that case did not change the result of CALENDERAUTO() right?
Thanks

[@adrianfuhrer5832]

Perfect thanks😊

[@subinelias674]

Well structured. Awsome!

[@GoodlyChandeep]

Thank you

[@manishkapoor4416]

Thankyou, Chandeep you explain the concepts very clearly,,,,,,,Thanks a lot.......and where can i get your full dax course

[@GoodlyChandeep]

goodly.co.in/learn-dax-powerbi/

[@surajchavan6447]

Awesome!!🥰🥰

[@ArifulIslam-gs6uy]

Really Excellent...

[@64BitTeluguGaming]

Good explanation 👍

[@shabnamattar5632]

can pls tell us the currency conversion Dax

[@sachintiwari4420]

@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 ?

[@mnasirkhanctl]

Awesome!!! thanks

[@ajieapen]

Chandeep, at 11:35 what are the keyboard shortcuts that you used to insert // and later to remove them?

[@GoodlyChandeep]

Select all the lines of code and use Ctrl / to comment them. To uncomment use the same shortcut.
Perhaps this might be helpful - ua-cam.com/video/LggOIgR2tn8/v-deo.html

[@tableaututorialstips71]

Wonderful bro :) Thanks for sharing this

[@suribhandari1985]

You are awesome bro!!!

[@anisshaikh5325]

Nice, sure Will start using it 👍

[@GoodlyChandeep]

All the best

[@kennethstephani692]

Great video!

[@zxccxz164]

Does each variable run even if it is not used in the final return???

[@Excel-power-users]

I am trying to create a pivot where I want the rolling total for last twelve months for sales and what is open value. With months in rows and ltm and open values in columns. I am not able to find the right syntax

[@sbn4862]

Hi.
Maxx(Date,
var SalesTable=(Sales)
return
sumx(SalesTable,Sales[qunt]*Sales[Prise])
Why we used varable to the table Sales ?

[@SujathaS-sx3kg]

Sir, what is the use of creating variable, where we find the variable which we created

[@mehmetakarca6400]

Hello, first of all, thank you for the videos. Could you please share a video for KPi table with status icon like traffic light. I tried to do it with tabular editor.

[@SandipanSarkar-c8v]

Finished watching

[@blse2000]

Bro..i like the way u teach concepts so much...can you please do a video on ALLEXCEPT() please

[@GoodlyChandeep]

Sure

[@carnivorecommando9617]

Nice video

[@fog2640]

finished watching

[@ashokreddy3300]

I would like to take coaching from yours so how do I contact,bro

[@GoodlyChandeep]

Please check - goodly.co.in/products/

[@apamwamba]

Cool!!

[@AUXA_2014]

The explanation of how variables are interacting with external ‘filters’ which are out of variables is missing

[@blse2000]

Awesome

[@atlascbg]

do you have any video showing a variance of data from one month to another in excel is easy but I haven't understand it for dax

[@GoodlyChandeep]

I don't have it for now but I can make a video on it soon. Be subscribed to be notified.
Meanwhile read this blog post - goodly.co.in/actual-vs-budget-calculations-dax-powerbi/
Thanks for suggesting :)

[@bzflowerbee]

I like it but I'm scared of variables, don't know why.

[@samoptimizer]

💯👏👏👏👏👏👏

[@satishpatilkulkarni6414]

Please send emails

[@sourabhpatel3834]

I am calculating Total sales in two ways but it is providing wrong results
First way :
Total sales =
var sale = SUMX(
order_details,
order_details[unitPrice] * order_details[quantity])
var discount = SUMX(
order_details,
order_details[discount] * order_details[unitPrice] * order_details[quantity] )
return sale-discount
__________________________________________________________________________________________________
and the second way ( i am using sale variable):
Total sales =
var sale = SUMX(
order_details,
order_details[unitPrice] * order_details[quantity])
var discount = SUMX(
order_details,
order_details[discount] * sale )
return sale-discount
this two must provide same result ?