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!
Very informative. I really admire the way you explained the concept.
Great explanation - very clear and nuanced! Thank you so much! ❤
Thanks! very professional approach in teaching. All very clear
You just made my life a lot more beautiful ❤️
Thanks a lot 🙏
Great explanation for RELATED and RELATEDTABLE function!
Glad you enjoyed!
Thanks, this helped.
You're welcome!
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.
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!
Excellent explanation!!
Thank you!
What a great explanation :)
Glad it was helpful!
Then why we not use
Calculate(sum(tablename[columnname]),filter(tablename,table[playerid]=table[playerid]))
Is there a way to do that in Query editor in one step without having to group by aggregate the table, then merge?
Hiii
Do you know any websites to practice DAX
Like Hacker rank for SQL
Look like relate is working with dimension and relatetable is working with fact table ?
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.
Video caps has a typo.
1:30- RELATED
4:58- RELATEDTABLE