Power BI DAX Tutorial (12/50) - What is Related Function

What Is RELATED function in DAX in Power BI, When you have to refer a column in the another table in your calculation you need to use Related Function in Power BI, Make another table should be related to this table. Power bi dax tutorial with examples

#powerbi #powerbidax #RELATED

Video Link for Date Table creation

Source File for Practice:

Complete Playlists

BI Developer - Complete Reference - Playlist
BI Architect - Complete Reference - Playlist

[siddheshdandagavhal]

In DAX you can use only one table. If you need a metric from other table you need to pull the date in the measure table which is inefficient. To overcome this issue we have related function:
Profit = SUMX(Sales, Sales[Quantity] * Related['Product Master'[Cost Price]))
Related used the Data Model Relationships to seek the related values from other table

This was Really Helpful! Thanks For this Video.

[alvegrande]

I finally get it nowwww. Thank you so much!

[kumargunjan]

Nicely explained… thanks nags for all these awesome content ❤️❤️

[saratchandra]

is that rows in both tables should be same or different, there may be case where rows from related table different how to handle that. Thanks for your answer.

[nagsiva]

Is there anyway we can specify the columns from other tables in the formula without creating relationship between them ?

[sravankumar]

your way of explanation is awesome, do more videos on dax, am eagerly waiting for your videos

[krishnaskills]

ur explanation is well plz provide sales table practise purpose

[datawhipper]

How about using RELATEDTABLE since you have a one to many relationship?

[bhupendersingh]

Sir You video is very helpful I am watching on daily basis. I really like. Sir Can we also get data from Dimdate to Product table

[AmitKumar-eexj]

We can only use "Related" when we are going with the flow of relationship bcz if we are going against the flow then related will not work. I guess you have to add this in your video

[ashishmohan]

Hi very useful video and very practical need everyone for every project big thanks to share with us.



If it can possible can you plzz provide us excel data file which you used.

Very greatful for us...👌👌👌👌👌👌👌👌💐💐💐💐🎂🎂🎂🎂🎂🎂🎂🎂🎂🎂🎂🎂

[divyagadi]

When you will explain remaining DAX function

[aryansena]

Need difference between related nd related table