What is the difference RELATED vs. RELATEDTABLE DAX | Power BI

Lets understand the difference between RELATEDTABLE and RELATED DAX functions. We will see in which scenarios, each of them should be used and how to implement them with examples
1. Type of Data both returns
2. Cardinality Compatibility
3. Examples for implementation of each
Data Used
www.pivotalstats.com/post/com...
Link for Previous Video on RELATED DAX
• How to use RELATED DAX...
Visit my blog for more content :
www.pivotalstats.com
Cool tech I use to produce these videos (affiliate links)
1. Blue Yeti Microphone -
amzn.to/3CeMv7C
2. LG Ultrawide Curved Monitor -
amzn.to/3EaHY8v
#Microsoft
#powerpivot
#dataanalytics
#dataanalysis
#powerbi
power bi,power bi dax,power bi desktop,power bi relatedtable,relatedtable in power bi,power bi tutorial,relatedtable power bi,power bi training,dax,relatedtable,power bi for beginners,power bi tutorial for beginners,relatedtable dax power bi,microsoft power bi,power bi related,power bi desktop dax,dax functions in power bi,relatedtable example power bi,powerbi,relatedtable dax function in power bi,dax relatedtable function in power bi

[@user-jn3cp3ne2f]

super sir

[@pivotalstats]

Thanks!

[@divyadsouze9701]

Very useful content.. Thank you Pivotalstas!! would you please upload some videos in relation to PL-300

[@pivotalstats]

Thanks! Sure I will upload soon.

[@cdwawhal]

Sir doesn't it create a table instead it is creating a column

[@pivotalstats]

Hi, If I understand your question correctly, you want to know why RelatedTable is used to create a column. Well if you use it on its own to create a column then it will always give you a error, because at the backend its giving a table not a single value. That is why we have used SUMX, which is an iterative function, which scans that table output from RelatedTable and then fetches values for each row. Hope this helps!