This video explained the logic behind using another dax with relatedtable. Related table used in sylos doesn't yield anything, that's where the way the video portion for relatedtable from 5:15 to 7:15 is described is awesome. One of the best video for relatedtable. Thanks, Chandeep.
@RaviGupta-mo1nf
4 жыл бұрын
Great explanation Great English Therefore perfect clarity. I will keep watching all your videos to learn!!
@DavidPetersen-s1s
Жыл бұрын
Thanks for this, finally I get it. Will make my life alot easier by not writing complicated lookups
@daveybalmer
4 жыл бұрын
A perfect explanation delivered crisply with no embroidery or annoying background music. Thanks
@Laxmanmane007
4 жыл бұрын
Really awesome also make vdo on summarize the and summarize columns to clearly understand exact diff.🙂
@aryansena7290
4 жыл бұрын
Great explanation, just b little slow for beginners. Thanks a lot.. Need more video
@GoodlyChandeep
4 жыл бұрын
More to come!
@vishaljhaveri7565
2 жыл бұрын
Nice video. If you don't understand this function at first go, 1. Follow this video first. This is the VLookup in Excel(in Hindi) : kzitem.info/news/bejne/1oiNqoeOf2RzqKg 2. Continue with this video. Thank you so much for this video. Finally understood these functions. PS : At 2:51, it would be "one side" instead of "many side".
@davidignatius1
Жыл бұрын
Your note at the beginning of the video is extremely powerful since many other videos do not explain that. Keep up the good work!
@GoodlyChandeep
Жыл бұрын
Glad you liked it David!
@Tessie1993
3 жыл бұрын
Thanks so much, that helped me a bunch!! Was going completely crazy haha
@mahimasharma2111
2 жыл бұрын
What is the difference between "COUNTROWS(Table1)" and "COUNTROWS(RELATEDTABLE(Table1))"? Here "Table1" is Fact Table and I used this formula on dimention table but both are giving different values. Counld you plz explain. I used this formula in calculated column.
@stephencross4978
3 жыл бұрын
thanks Chandeep, a great video and so nicely explained!
@sujit3375
Жыл бұрын
What if i want to fetch column from one fact table into another fact table Using measure ( not able to fetch) But by using new column i am able to fetch that
@BusinessQuant
3 жыл бұрын
One year on, and the tutorial is still immensely helpful! Just referred to it again for another round of development. Thanks again!
@GoodlyChandeep
3 жыл бұрын
Glad it helped!
@avinashnl9588
3 жыл бұрын
Superb explanation, Loved it. Keep the good work.
@sujit3375
Жыл бұрын
What if i need data from one fact table into other fact table via usinh measure
@Tat-cx1lr
3 жыл бұрын
Speak slowly please ☹️☹️☹️☹️
@mahathmasadineni2884
9 ай бұрын
Hi Chandeep, Great explanation could you please do a vedio on what will happen if refer to price column with out using RELATED Function.
@Victor-zo7dp
3 жыл бұрын
thank you for a very clear explanation. what function i will use in picking up the string from one table to another like name of country name to put in another table
@viveklk21
Жыл бұрын
2.48 to 2.53 ..an error in explanation of related function....ie It not guving the intellisense because its on the one side of the relationship...You just said many side.
@ezazhaider3466
9 күн бұрын
Hi Goodly, for related table you mention relationship build on many to one etc. , but I guess it is one to many, and in example you show one to many but in beginning of video you mentioned many to one etc.
@reenamonteirosonar4607
2 ай бұрын
i think u made a mistake in the video @2.52 u called the product table as the many side of the relationship ?
@surojeetdey57
11 ай бұрын
Sir, Whatever you did in the related table function in new column, can we do this new measure by using iterator function.
@saurabh-sharma
3 ай бұрын
Mistake at 2:54, {Not a many side of the relation instead that is one side of the relationship}. Overall great content brother.
@Everyonelovesyou
3 жыл бұрын
Really informative.
@kaleeswarichellamani5185
6 ай бұрын
Great and clear Explanation.Thanks. plse share this practice file.
@summaoruvideo7300
Жыл бұрын
at 2.52 instead of one side you mentioned many side of the relationship😎
@ImranHussain-xv4se
4 жыл бұрын
Thanks sir, I have gone through many videos on this topic but the way you have explained is marvelous. Looking forward to more such videos.
@GoodlyChandeep
4 жыл бұрын
Thanks.. Keep watching
@3danim8r1
4 жыл бұрын
Nicely explained....
@ricardogoncalves9204
4 ай бұрын
THANK YOU!!!!! This saved me lots of time and more importantly saved my nerves :) Cheers
@javedhassansheik903
Жыл бұрын
can you provide the datasets so we can practice in power bi
@stephenbrincat7124
4 жыл бұрын
Thanks very well explained
@emilyamalkin4367
Жыл бұрын
I love how you explain the topic - I get it! Thank you and please keep them coming, you are a talented teacher! ❤
@shoaibrehman9988
Жыл бұрын
Very good explanation thanks
@pravinshingadia7337
2 жыл бұрын
Can we please have the file you show in each video as a downloadable so we can practice with you?
@GoodlyChandeep
2 жыл бұрын
Try to include it in all videos.. but could've missed out for this video :|
@animoki9292
2 жыл бұрын
Nice bro..well done..keep doing the good work..God bless you
@shwetadalal389
3 жыл бұрын
thanks for clearing all my doubts with this video!
@harishpaldhir5915
4 жыл бұрын
SIR AN EYE OPENING VIDEO ON RELATED AND RELATEDTABLE VERY GOOD EFFORT SIR TO TEACH DUMMIES LIKE US GOOD ONE
@Usr-vpo-p
11 ай бұрын
Thanks helped me crack an interview in one day :D
@TheGreatAzhar
2 жыл бұрын
Very Nice Explaination
@Albert-zf8ct
Жыл бұрын
easy peasy, clear and simple explanation - well done - thank you!
@jaipalcse
Жыл бұрын
What a logical explanation straight fit into my brain.
@sandeepjami9119
4 жыл бұрын
Thanks, Mate
@rahulshewale9206
4 жыл бұрын
Thank you sir
@redboom9874
4 жыл бұрын
Is this functions work with direct query.
@ibejoseph19
2 жыл бұрын
GREAT EXPLANATION! I WAS ALREADY LOSING HOPE 😂♥️. Thank youuuuu
@GoodlyChandeep
2 жыл бұрын
Glad you like it!
@venkatareddykummitha5863
3 жыл бұрын
give the excel doc. please
@ajaykumarvelivela9472
3 жыл бұрын
Crystal clear bro.Thanks for the video
@fabiocardososantos5677
3 жыл бұрын
By far, the best explanation i got about this topic in KZitem. Very nice job.
@dareemmanuel6079
7 ай бұрын
Excellent explanation!
@ramonillarramendi3191
3 жыл бұрын
Great. Thank you very much. Excellent explanation. Would it be better to have the column i.e total sales included in power query via a merge of tables? In measures, do you always have to use the related function or would the calculation be alright due to the existing relation that exists between the two tables?
@GoodlyChandeep
3 жыл бұрын
Refrain from merging tables. Using Relationship is a much better way to go. Also the RELATED function only gets triggered when you use the total sales measure
@ajinkyashinde1778
7 ай бұрын
as always crystal clear explanation.🔥
@ketankale4223
2 жыл бұрын
Really very good and simple explanation
@GoodlyChandeep
2 жыл бұрын
Thank you!
@arunv1909
2 жыл бұрын
2:54 its the one side
@BusinessQuant
4 жыл бұрын
Thank you so much, was trying to understand this problem from the last 3 hours. Perfect explanation! One thing though, is there anything else apart from COUNTROWS that works on RELATEDTABLE?
@GoodlyChandeep
4 жыл бұрын
Thanks Piyush, I am glad you liked how I explain ;) You can do anything with the table collected using RELATEDTABLE. for example creating a column with the formula =SUMX ( REALTEDTABLE ( Sales ), Sales [Units] ) will give you a column with total units for each product in the sales table.
@pranjalagrawal4167
3 жыл бұрын
I believe, wherever in measure it's asking for a table we can give RELATEDTABLE.
@GauravSharma-iu5mr
Жыл бұрын
Well Explained
@anuragbawankar685
Жыл бұрын
Thank you !
@abhishek12865a
Жыл бұрын
thanks bro
@peterhaftner9477
Жыл бұрын
Well explanation, thank you!
@GoodlyChandeep
Жыл бұрын
Glad you enjoyed it!
@perrybundoc6714
2 жыл бұрын
great explanation. thanks.
@ArifulIslam-gs6uy
3 жыл бұрын
Fantastic
@ALBERTYY55
3 жыл бұрын
clear explanation. thanks.
@ranjanajoshi3099
2 жыл бұрын
Awesome explanation!!
@zerobars3
3 жыл бұрын
Great tutorial, very well explained.
@abhishekpacheriwala496
4 жыл бұрын
Simple example with good clarity. Exactly what i was looking for.
@GoodlyChandeep
4 жыл бұрын
Hey Glad you found it helpful!
@sangeethetikala
4 жыл бұрын
Excellent Very Detailed Explanation, looking forward for more videos.
@GoodlyChandeep
4 жыл бұрын
More to come! :)
@norpriest521
3 жыл бұрын
@@GoodlyChandeep Hi, I would like to ask if I have..... [Fact table] Scan_id (surrogate key) and [Dim table] Scan_id (foreign key) Medicine_id (foreign key) I want to throw Medicine_id into the fact table. Is there any way I can do it? Because Scan_id is the only key those two tables can connect with each other. Can I somehow use RELATED or RELATEDTABLE for this particular scenario? I mean I don't want to do aggregation, I just wanted to do similar thing like RELATED. I only want it to show values. Appreciate your answer.
@hariprasad289
2 жыл бұрын
Wonderful explanation, thank you
@GoodlyChandeep
2 жыл бұрын
Glad you like it 😊
@dhananjaykulkarni5445
3 жыл бұрын
Nice explanation
@jonatorba
3 жыл бұрын
Excellent explanation!
@Wzxxx
Жыл бұрын
Hmmm…it seems that and relatedtable gives similar results as a filtercontext in calculated colums even if we use a row context. It is so frustrating as in a dax bible is always mentioned that rowcontext iterates and doeas not filter😵💫
Пікірлер: 96