Variables in DAX

[@elainelam6883]

Really like the ways you deliver all the complicated processes! I have learned a lot from you! Thanks 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!

[@GoodlyChandeep]

Glad you like it 💚

[@agustinpena948]

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

[@GoodlyChandeep]

Glad it helped! :)

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

[@MichaelBrown-lw9kz]

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

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

[@kudratilla]

your teaching and explaining skills are excellent

[@GoodlyChandeep]

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

[@lunacyfoundme]

Great video, very clear thorough explanation

[@veebee3969]

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

[@salahaldeen7924]

I keep re visiting this vid, thank you Chandeep

[@jiandong8351]

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

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

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

[@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 - kzbin.info/www/bejne/gpjKgHydh5enpJo

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

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

[@zxccxz164]

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

[@sharadkolse6871]

thank you so much brother, your content is really helpful

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

[@KirillBezzubkine]

Actually yes. Mr is really good at explaining

[@shreyamukkawar2989]

Clear and perfect explanation

[@GoodlyChandeep]

Glad you liked it

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

[@sandeepreddy7687]

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

[@GoodlyChandeep]

Glad to hear that

[@MucahitKatirci]

Thanks for the video. It was very helpful.

[@Analyse_US]

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

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

[@KaranNayyarBCS]

Nicely Explained. Thanks !

[@adrianfuhrer5832]

Perfect thanks😊

[@tomaskavicky]

very clear explanation, thanks !

[@subinelias674]

Well structured. Awsome!

[@GoodlyChandeep]

Thank you

[@mnasirkhanctl]

Awesome!!! thanks

[@blse2000]

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

[@GoodlyChandeep]

Sure

[@ashokreddy3300]

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

[@GoodlyChandeep]

Please check - goodly.co.in/products/

[@surajchavan6447]

Awesome!!🥰🥰

[@ArifulIslam-gs6uy]

Really Excellent...

[@64BitTeluguGaming]

Good explanation 👍

[@suribhandari1985]

You are awesome bro!!!

[@tableaututorialstips71]

Wonderful bro :) Thanks for sharing this

[@kennethstephani692]

Great video!

[@anisshaikh5325]

Nice, sure Will start using it 👍

[@GoodlyChandeep]

All the best

[@SandipanSarkar-c8v]

Finished watching

[@carnivorecommando9617]

Nice video

[@fog2640]

finished watching

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

[@samoptimizer]

💯👏👏👏👏👏👏

[@bzflowerbee]

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

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