Variables in DAX

[@elainelam6883]

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

[@agustinpena948]

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

[@GoodlyChandeep]

Glad it helped! :)

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

[@adrianfuhrer5832]

Perfect thanks😊

[@mnasirkhanctl]

Awesome!!! thanks

[@salahaldeen7924]

I keep re visiting this vid, thank you Chandeep

[@MichaelBrown-lw9kz]

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

[@veebee3969]

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

[@lunacyfoundme]

Great video, very clear thorough explanation

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

[@sharadkolse6871]

thank you so much brother, your content is really helpful

[@kudratilla]

your teaching and explaining skills are excellent

[@GoodlyChandeep]

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

[@SandipanSarkar-c8v]

Finished watching

[@MucahitKatirci]

Thanks for the video. It was very helpful.

[@shreyamukkawar2989]

Clear and perfect explanation

[@GoodlyChandeep]

Glad you liked it

[@KaranNayyarBCS]

Nicely Explained. Thanks !

[@subinelias674]

Well structured. Awsome!

[@GoodlyChandeep]

Thank you

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

[@KirillBezzubkine]

Actually yes. Mr is really good at explaining

[@tomaskavicky]

very clear explanation, thanks !

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

[@stevefox7469]

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

[@jiandong8351]

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

[@sandeepreddy7687]

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

[@GoodlyChandeep]

Glad to hear that

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

[@ArifulIslam-gs6uy]

Really Excellent...

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

[@kennethstephani692]

Great video!

[@surajchavan6447]

Awesome!!🥰🥰

[@64BitTeluguGaming]

Good explanation 👍

[@fog2640]

finished watching

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

[@suribhandari1985]

You are awesome bro!!!

[@tableaututorialstips71]

Wonderful bro :) Thanks for sharing this

[@anisshaikh5325]

Nice, sure Will start using it 👍

[@GoodlyChandeep]

All the best

[@apamwamba]

Cool!!

[@zxccxz164]

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

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

[@sbn4862]

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

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

[@blse2000]

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

[@GoodlyChandeep]

Sure

[@SujathaS-sx3kg]

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

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

[@shabnamattar5632]

can pls tell us the currency conversion Dax

[@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 - th-cam.com/video/LggOIgR2tn8/w-d-xo.html

[@ashokreddy3300]

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

[@GoodlyChandeep]

Please check - goodly.co.in/products/

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

[@rickyzeng5907]

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

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