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
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.
The dimension table can contain more members than the fact table, and where as fact should have members that exist in dimension table. Obviously related function should refer to dimension table most of the case and member should exist
Dont know if anyone cares but if you are bored like me atm you can stream all the latest series on instaflixxer. Have been binge watching with my girlfriend for the last months xD
Hi very useful video and very practical need everyone for every project ......very 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...👌👌👌👌👌👌👌👌💐💐💐💐🎂🎂🎂🎂🎂🎂🎂🎂🎂🎂🎂🎂
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
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.
You're welcome!
I finally get it nowwww. Thank you so much!
Thanks keep learning
Thank you, sir 🙏🏻❤️📜✨
You are very welcome
Is there anyway we can specify the columns from other tables in the formula without creating relationship between them ?
Check the channel searching Treatas Dax functions. Which doesn’t require relationship
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.
The dimension table can contain more members than the fact table, and where as fact should have members that exist in dimension table. Obviously related function should refer to dimension table most of the case and member should exist
Nicely explained… thanks nags for all these awesome content ❤️❤️
Glad you liked it
your way of explanation is awesome , do more videos on dax, am eagerly waiting for your videos
Thank you, I will
Dont know if anyone cares but if you are bored like me atm you can stream all the latest series on instaflixxer. Have been binge watching with my girlfriend for the last months xD
@Kareem Cain Definitely, I have been watching on instaflixxer for since november myself :)
ur explanation is well plz provide sales table practise purpose
For simple dataset we don't maintain it , we delete it , create your own data.
How about using RELATEDTABLE since you have a one to many relationship?
docs.microsoft.com/en-us/dax/relatedtable-function-dax
When you will explain remaining DAX function
Will surely update soon. Follow the channel updates
You can look at the Playlists section and DAX playlist for specific Updates.
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
Yes we can
@@AnalyticswithNags Sir Can you please make a tutorial video on this
@@bhupendersingh6673 Yes sure will add in the to do list
Need difference between related nd related table
will make video
Hi very useful video and very practical need everyone for every project ......very 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...👌👌👌👌👌👌👌👌💐💐💐💐🎂🎂🎂🎂🎂🎂🎂🎂🎂🎂🎂🎂
Yes, sure
@@AnalyticswithNags thanks
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
Noted.