Quick question.. might be a stupid question...how did you increase the font size of formula bar... By the way... amazing video and great explanation. Support and love from India Thanks and Regards Krishna Kishore P
Thanks for the kind words. With the mouse cursor in the formula bar if you hold down the shift key and scroll up on your mouse wheel it will increase/decrease the formula text.
If you already have those other dimensions in your data model, what is the need for adding calculated columns and repeating that information elsewhere? Wouldn't this be considered a redundancy?
Douglas you are absolutely correct. I wanted to showcase with an easy dataset the difference between the two DAX functions. I would definitely do most of those transforms through merges in the Power Query editor. I've worked with some reports in Virtual Mentoring sessions where the user wanted to get an aggregation on a Dimension table in order to transfer conditional logic for a calculated column or someone is connecting to a live dataset and they don't have the ability to go back in the Power Query editor to modify so this was their only workaround.
Well, why do Related and Related table explained here are not explained in conjunction with cardinalities? Confusion can arise so easily with those who are new. Come on.
I look at so many related and relatedtable, only yours makes sense to me. And you explain so to the point!
Great explanation for RELATED and RELATEDTABLE function!
Glad you enjoyed!
Very informative. I really admire the way you explained the concept.
Thanks! very professional approach in teaching. All very clear
Great explanation - very clear and nuanced! Thank you so much! ❤
You just made my life a lot more beautiful ❤️
Thanks a lot 🙏
Then why we not use
Calculate(sum(tablename[columnname]),filter(tablename,table[playerid]=table[playerid]))
Great explanation, thank you!
Brilliant 🎉
Quick question.. might be a stupid question...how did you increase the font size of formula bar...
By the way... amazing video and great explanation.
Support and love from India
Thanks and Regards
Krishna Kishore P
Thanks for the kind words. With the mouse cursor in the formula bar if you hold down the shift key and scroll up on your mouse wheel it will increase/decrease the formula text.
Thanks, this helped.
You're welcome!
If you already have those other dimensions in your data model, what is the need for adding calculated columns and repeating that information elsewhere? Wouldn't this be considered a redundancy?
Douglas you are absolutely correct. I wanted to showcase with an easy dataset the difference between the two DAX functions. I would definitely do most of those transforms through merges in the Power Query editor. I've worked with some reports in Virtual Mentoring sessions where the user wanted to get an aggregation on a Dimension table in order to transfer conditional logic for a calculated column or someone is connecting to a live dataset and they don't have the ability to go back in the Power Query editor to modify so this was their only workaround.
Great comment and explanation. Valuable info!!
@@TheAlgebraTeacherPOWERStoBI that makes sense! Really great explainer on the difference between the two--thank you for sharing!
Very well explained, Thanks.
You are welcome!
Look like relate is working with dimension and relatetable is working with fact table ?
Excellent explanation!!
Thank you!
Hiii
Do you know any websites to practice DAX
Like Hacker rank for SQL
Well, why do Related and Related table explained here are not explained in conjunction with cardinalities? Confusion can arise so easily with those who are new. Come on.
Is there a way to do that in Query editor in one step without having to group by aggregate the table, then merge?
What a great explanation :)
Glad it was helpful!
Video caps has a typo.
1:30- RELATED
4:58- RELATEDTABLE