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

Комментарии • 10

  • @user-ie5cz1co6u
    @user-ie5cz1co6u 4 месяца назад

    I leaned from your video and i got good job

    • @KSRDatavizon
      @KSRDatavizon  4 месяца назад

      Thank you so much for sharing this with me! I'm thrilled that my video was helpful to you.

  • @sandipansarkar9211
    @sandipansarkar9211 9 месяцев назад +1

    finished watching

    • @KSRDatavizon
      @KSRDatavizon  4 месяца назад

      Thank you so much for your comment, Please like, share and subscribe our channel for regular updates. it motivates us a lot

  • @normalguy9940
    @normalguy9940 6 месяцев назад

    Thanks

  • @Gandunomics007
    @Gandunomics007 Год назад +1

    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 ...?

  • @Gandunomics007
    @Gandunomics007 Год назад +1

    What is the difference between NULL VALUES IN CELL IN POWER BI and Blank values in power bi...?

  • @ravisunkara6664
    @ravisunkara6664 Год назад

    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.

    • @KSRDatavizon
      @KSRDatavizon  4 месяца назад

      Thank you so much, Please subscribe our channel, it motivates us a lot