End-to-End DAX Tutorial | Power Bi | PARENT & CHILD FUNCTION | KSR Datavizon
HTML-код
- Опубликовано: 24 апр 2023
- In DAX (Data Analysis Expressions), parent-child functions are used to define hierarchical structures within a table. These functions allow you to create relationships between columns within the same table that represent a parent-child hierarchy.
There are two types of parent-child functions in DAX:
PARENT Function: This function returns the parent of a specified member in a parent-child hierarchy.
PATH Function: This function returns the path from the root of a specified member to the parent of the specified member in a parent-child hierarchy.
Note: To create a parent-child hierarchy in DAX, you need to have a table with at least two columns, one for the parent and one for the child. The child column should contain a reference to the parent column. You can create this reference using the RELATED function or by using a calculated column that defines the relationship.
How are we different from Others...?
1. 24*7 Recorded sessions Access & Support
2. Flexible Class Schedule
3. 100 % Job Guarantee & 100 % Live Training
4. Mentors with +14 yrs. & Free Microsoft License
6. LMS And APP Availability for a Good live session experience.
7. Soft Skills I Email Etiquette I Client/Stakeholders Handling Techniques.
Call us on IND: 9916961234 / 8527506810 to talk to our Course Advisors
👉Please ping on WhatsApp: - wa.me/918951796123
#DAX #DataAnalysis #DataVisualization
#PowerBI
#DataModeling
#DataAnalysis
#DataVisualization
#BusinessIntelligence
#Measure
#CalculatedColumn
#DataAnalytics
#DataModel
I leaned from your video and i got good job
Thank you so much for sharing this with me! I'm thrilled that my video was helpful to you.
finished watching
Thank you so much for your comment, Please like, share and subscribe our channel for regular updates. it motivates us a lot
Thanks
We appreciate your support!
Hello Mam, I trying to the same with the same data set but i get the errors like data is missing in parent table (reference - in front of koti ) and another error enable to find krishna in parent table .
How to resolve this issue ...?
What is the difference between NULL VALUES IN CELL IN POWER BI and Blank values in power bi...?
Thanks Madam for your explanation on parent & child method & really appreciated. If you show us live scenario where it can be used that could be great.
Thank you so much, Please subscribe our channel, it motivates us a lot