Really like the ways you deliver all the complicated processes! I have learned a lot from you! Thanks so much
@ItsWithinYou
2 жыл бұрын
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
2 жыл бұрын
Glad you like it 💚
@agustinpena948
3 жыл бұрын
Man! I really like the way you structure and explain things! Thank you SO much :)
@GoodlyChandeep
3 жыл бұрын
Glad it helped! :)
@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
2 жыл бұрын
your teaching and explaining skills are excellent
@GoodlyChandeep
2 жыл бұрын
Thanks Man.. glad you enjoyed the video. More to come
@MichaelBrown-lw9kz
9 ай бұрын
Awesome, awesome, awesome explanations. Wow, you are a talented instructor, sir.
@salahaldeen7924
2 ай бұрын
I keep re visiting this vid, thank you Chandeep
@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
@lunacyfoundme
Жыл бұрын
Great video, very clear thorough explanation
@sharadkolse6871
3 ай бұрын
thank you so much brother, your content is really helpful
@veebee3969
11 ай бұрын
Thank you so much. Your videos are always very helpful.
@capriag
3 жыл бұрын
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
@williamarthur4801
2 жыл бұрын
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.
@shreyamukkawar2989
Жыл бұрын
Clear and perfect explanation
@GoodlyChandeep
Жыл бұрын
Glad you liked it
@KirillBezzubkine
3 жыл бұрын
Actually yes. Mr is really good at explaining
@jiandong8351
Жыл бұрын
Very helpful! If there were a link to your Excel working file, it would be super.
@MucahitKatirci
2 жыл бұрын
Thanks for the video. It was very helpful.
@adrianfuhrer5832
Ай бұрын
Perfect thanks😊
@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
4 жыл бұрын
Thanks Chandeep for the video. Really liked all your videos.
@GoodlyChandeep
4 жыл бұрын
Glad to hear that
@mnasirkhanctl
Ай бұрын
Awesome!!! thanks
@stevefox7469
2 жыл бұрын
...as everyone said this is really well done.
@KaranNayyarBCS
3 жыл бұрын
Nicely Explained. Thanks !
@tomaskavicky
3 жыл бұрын
very clear explanation, thanks !
@user-lm5wb8vi1x
8 ай бұрын
Finished watching
@subinelias674
Жыл бұрын
Well structured. Awsome!
@GoodlyChandeep
Жыл бұрын
Thank you
@surajchavan6447
9 ай бұрын
Awesome!!🥰🥰
@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
@blse2000
4 жыл бұрын
Bro..i like the way u teach concepts so much...can you please do a video on ALLEXCEPT() please
@GoodlyChandeep
4 жыл бұрын
Sure
@zxccxz164
7 ай бұрын
Does each variable run even if it is not used in the final return???
@fog2640
9 ай бұрын
finished watching
@sbn4862
2 жыл бұрын
Hi. Maxx(Date, var SalesTable=(Sales) return sumx(SalesTable,Sales[qunt]*Sales[Prise]) Why we used varable to the table Sales ?
@ArifulIslam-gs6uy
3 жыл бұрын
Really Excellent...
@SujathaS-sx3kg
3 жыл бұрын
Sir, what is the use of creating variable, where we find the variable which we created
@mehmetakarca6400
2 жыл бұрын
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.
@anisshaikh5325
4 жыл бұрын
Nice, sure Will start using it 👍
@GoodlyChandeep
4 жыл бұрын
All the best
@shabnamattar5632
Жыл бұрын
can pls tell us the currency conversion Dax
@64BitTeluguGaming
2 жыл бұрын
Good explanation 👍
@tableaututorialstips71
2 жыл бұрын
Wonderful bro :) Thanks for sharing this
@sachintiwari4420
3 жыл бұрын
@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 ?
@excel-k-sir
3 жыл бұрын
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
@kennethstephani692
3 жыл бұрын
Great video!
@suribhandari1985
3 жыл бұрын
You are awesome bro!!!
@apamwamba
5 ай бұрын
Cool!!
@ajieapen
4 жыл бұрын
Chandeep, at 11:35 what are the keyboard shortcuts that you used to insert // and later to remove them?
@GoodlyChandeep
4 жыл бұрын
Select all the lines of code and use Ctrl / to comment them. To uncomment use the same shortcut. Perhaps this might be helpful - kzitem.info/news/bejne/rZ2dtX2di2SloW0
@ashokreddy3300
Жыл бұрын
I would like to take coaching from yours so how do I contact,bro
@GoodlyChandeep
Жыл бұрын
Please check - goodly.co.in/products/
@rickyzeng5907
Жыл бұрын
The explanation of how variables are interacting with external ‘filters’ which are out of variables is missing
@blse2000
4 жыл бұрын
Awesome
@atlascbg
4 жыл бұрын
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
4 жыл бұрын
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
3 жыл бұрын
I like it but I'm scared of variables, don't know why.
@samoptimizer
Жыл бұрын
💯👏👏👏👏👏👏
@satishpatilkulkarni6414
2 жыл бұрын
Please send emails
@sourabhpatel3834
11 ай бұрын
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 ?
Пікірлер: 66