RELATED Vs RELATEDTABLE DAX Function in Power BI | Power BI | BI Consulting Pro | DAX Sundays | DAX
Vložit
- čas přidán 28. 06. 2024
- In DAX, generally Row Context doesn't work with the relationships. However, there are some built in DAX functions which can take advantage of existing relationships in Data Model and can work with Row Context.
Here, in this video, I have explained, how can we use RELATED & RELATEDTABLE DAX functions to take advantage of existing relationships in the data model.
Timeline:
00:00 - Introduction
01:16 - RELATED DAX Function & other Info
08:16 - RELATEDTABLE DAX
11:00 - End Part & Request to the viewers
For More info:
docs.microsoft.com/en-us/dax/...
RELATED DAX Video: • RELATED DAX Function |...
*****************************
For DA-100 Exam Tutorial Series:
• PL- 300 Exam Tutorial
************************
For more DAX Videos:
• DAX Sundays
*************
For more Weekly Videos:
• Power BI Weekly Videos
***********************************
********
LET'S CONNECT!
********
- Twitter: / biconsultingpr1
- Instagram: / biconsultingpro
- Email: connect@biconsultingpro.com
- Facebook: / community
- Website/vlog: www.biconsultingpro.com
#RELATEDTABLE #REALTED #DAXSundays #BIConsultingPro #PowerBI
~-~~-~~~-~~-~
Please watch: "Microsoft Azure Synapse Analytics Tutorial | Azure Synapse Studio |BI Consulting Pro |Azure Tutorial"
• Microsoft Azure Synaps...
~-~~-~~~-~~-~
Great, thank you for a calm and systemized approach to bringing information :)
videos are so helpful.thank you so much
Excellent explanation, exactly explaining the crux..
Thank you. Much appreciated.
You are a very good trainer. Thanks a lot.
I appreciate that! Thank you for your feedback!
THANK YOU SIR
Tq sir..
Thanks a lot
Most welcome
value of time spent on this
Thank you.
Nice
Great explanation, Please guide me how can I fetch value from fact table to dim table.
You can use lookupvalue() DAX function. There is video on this. Please visit our channel.
Hi sir. Pls share the google drive link to download the source files.
example for relatedtable is not good, please use a Realtime scenario
Thank you for your feedback! Much appreciated. Will keep in mind :)