You are an excellent teacher and I am inspired to forward my knowledge like you. Thank you for all your hard work, time and selflessness and sharing your invaluable knowledge. It means a lot. xxx
@CurbalEN
4 жыл бұрын
And thanks for your feedback! /Ruth
@powerbinareal
2 ай бұрын
Fico impressionado como um vídeo de 6 de jan. de 2017 não perde sua importância com o tempo. Sempre Estou reaprendendo com vc. Valeu!!! 😎😎😱😱😱😱😱😱💪🏼💪🏼
@CurbalEN
2 ай бұрын
🥳🥳
@SmartBimson
7 жыл бұрын
Hello Ruth ! This video is very interesting and I would like to ask you if you can make a follow up video with an example how to use this Dax expressions or to take this example further and to show us how to use this function more detailed ... And I'm looking forward today's Dax Friday 👍🏻👍🏻👍🏻 🎉👍🏻
@CurbalEN
7 жыл бұрын
+SmartBimson Hi Absolutely, is there any specific scenario you had in mind? /Ruth
@SmartBimson
7 жыл бұрын
Curbal hello Ruth, yes kind of but I'm afraid I'm not able to explain it properly in English. Could be cool if you can do a general example with the use of power bi filters and then I can ask my questions based on your cool video ! Thanks so much, appreciate it a lot 👍🏻👍🏻👍🏻
@CurbalEN
7 жыл бұрын
+SmartBimson ok, it will take some weeks as I have other videos schedule but as soon as I can I will make it for you! :) /Ruth
@SmartBimson
7 жыл бұрын
Curbal that's so cool !!! Can't wait anymore already 😉🍾 have a great weekend Ruth !
@CurbalEN
7 жыл бұрын
+SmartBimson The same to you and many thanks for watching and supporting my videos! You are the best! 😊 /Ruth
@Lixia123
7 жыл бұрын
Very useful to solve complex buiness problem, thanks!
@CurbalEN
7 жыл бұрын
+Lixia Zhang Hi Lucia! Glad you found it useful and thanks for the feedback! /Ruth
@anitashinde7543
3 жыл бұрын
Thank you so much for all DAX files
@CurbalEN
3 жыл бұрын
My pleasure!
@MarkHinderliter
6 жыл бұрын
Ruth I like this one. Any chance of you showing how to put the PATHCONTAINS together with a filter like you did with the Top N? I'm thinking of org structure, it'd be nice to see how you could select a person in an org and see everyone who rolls up to them.
@CurbalEN
6 жыл бұрын
Great idea, noted ;) Happy new year! /Ruth
@clemmonswest262
Жыл бұрын
Awesome!
@rrrprogram8667
7 жыл бұрын
Nice one ruth
@CurbalEN
7 жыл бұрын
+RRR program Thanks ;) /Ruth
@lifeuncut3463
2 жыл бұрын
Very useful
@paulcooper5330
6 жыл бұрын
You just solved a particular problem. I have been trying to work out a way to iterate down through boms to find if software sits in a particular bom. This will work.
@CurbalEN
6 жыл бұрын
Yey! Glad it was useful :) /Ruth
@paulcooper5330
6 жыл бұрын
I may have drawn a blank Ruth. I will keep trying. My issue is that the Component are used in multiple Parents and the bom hierarchy has up to 6 levels. In short, what I am trying to do is to create a query that flags a Parent that has certain Software down any level in the hierarchy. I will keep trying unless you have a suggestions (like give up) :)
@CurbalEN
6 жыл бұрын
Have you tried asking in the power bi community? Post some sample data too! /Ruth
@paulcooper5330
6 жыл бұрын
Curbal, I found a nice solution on BIAccountant blog from last year. Quite complex PQ with some trick M that iterates down the levels. Still stress testing but seems to work.
@CurbalEN
6 жыл бұрын
Excellent and Thanks for sharing :) /Ruth
@kummithavenkatareddy2302
2 жыл бұрын
You are my PowerBI Guruvu(Teacher).
@prachitrivedi7928
4 жыл бұрын
Thank you very much Ruth !! This video helped me in solving one my long outstanding issue with org hierarchical slicer
@CurbalEN
4 жыл бұрын
Wonderful to hear :)
@exceliarmus7858
2 жыл бұрын
Thank you!
@MartinMunoa
4 жыл бұрын
Hi Ruth! I think this solution here only works when you have just one parent per child. I need to do a Bill of materiales where there are many childs that are used on multiple parents (For example a model of screw -Child- that is used in lots of final products -Parents-, or the delivery box -We use the same one for multiple products-). If you do know how to do it, could you make a video about it? Thank you and thanks for this great channel!
@kinoby4me2
4 жыл бұрын
Yes, please let me know if you have a solution for child items having multiple parents....currently results in an #ERROR
@glendierick7983
Жыл бұрын
Did you find a solution?
@asimabdulwahab9444
6 жыл бұрын
Very nice
@CurbalEN
6 жыл бұрын
+Asim Abdul Wahab Thanks and Happy Friday :) /Ruth
@chumito6
3 жыл бұрын
Hi Ruth! thank you for this video. I've followed every step and everything worked perfectly regarding the columns. However, when I go back to the visuals' pane, I do not see any hierarchy and therefore I cannot use it for creating drill-down visuals. Please help!
@pallavijain3957
2 жыл бұрын
Hi Ruth...You are excellent... your videos are very informative and unique I have a query...in Parent child Dax If we want to repeat emp key and Mgr key...then there is sn error. Issue is...that employee A is reporting to emp x.. But now he is reporting to Emp Z We want to keep both values. How can we solve this..
@thangvan-h9p
29 күн бұрын
hello, the example link was inaccessible , could you please check? Thanks for your great video
@Golden_Tortoise
7 жыл бұрын
Very good video! Thank you so much! Suggestion: It is not very easy to follow a data set that has computer-like values (MMK115/1). It would be better if the values were more human readable such as CEO, Vice President, Manager, Employee etc. for someone who does not even know what is a parent or child function. Other than that, thank you!
@CurbalEN
7 жыл бұрын
+Brendan Crowther Ah, true! Thanks for the feedback, I will take it into account for next videos :) /Ruth
@MKJainStatistics
4 жыл бұрын
Hi Ruth, very clear and crisp explanation. I am working on developing a data warehouse on manufacturing process and was struggling to get real world example on product traceability. Whenever search for parent child hierarchy topic most of the time we come across organization kind, but this one I could relate very well. Thanks for that.
@CurbalEN
4 жыл бұрын
Perfect! Happy it worked for you :) /Ruth
@amarsale322
4 жыл бұрын
Hey Ruth, is it possible to view parent & child in same visual (no drilling) and the parent showing sum of all its children instead of only the selected children? For example, if i want to see the count of employees in Cities like London, Leeds, Birmingham and also in all of England and Europe in same visual with no drill down
@CurbalEN
4 жыл бұрын
Try using the matrix visual with the stepped option on (or off can’t remember which) /Ruth
@10806628
4 жыл бұрын
Hi, you forgot to show the values associated with the hierarchy. Do you simply attach the values and it will just show the values in a collapsible manner?
@kanthu85
4 жыл бұрын
What about component has duplicate mean multiple parent hierarchy..
@aks541
7 жыл бұрын
For practicing purpose want to get the excel which you'd used here. Where to get the excel?
@CurbalEN
7 жыл бұрын
+Ak S Hi, you can find it in the description box. /Ruth
@rikabchand6036
4 жыл бұрын
112|23|18|1 As per my understanding when we use PATH function, 112 denotes the Org Lvl 1 and 23 denotes Org Lvl 2 and so on. Can this be bi-directional like below, 1|18|23|112 1 denotes last Org Lvl N and 18 denotes Org Lvl N-1 and so on. Basically I want to have Child-Parent Hierarchy. The reason he if one persons belongs to 2 difference regions how we can take care of this using PATH function. Basically what I need is Child-Parent relationship instead of Parent-Child relation ship.
@poorvaawale
3 жыл бұрын
Hi Ruth, I have a file in which a column is in hierarchical format I want to spilt it into parent child format in different column.. How to do this any idea?
@Sharvan029
6 жыл бұрын
Hi Ruth, How can i find out the sum of number of Child iD's per Parent ID?
@CurbalEN
6 жыл бұрын
+sharvan hameed Hi! Let me do a Dax Friday video of it! /Ruth
@walidkhlil2872
4 жыл бұрын
great thanks
@shwetadalal389
3 жыл бұрын
I am not able to download the excel file. I want to use it for practice.
@alexkelly757
5 жыл бұрын
Hello, how do you use the DAX hierarchy in the report view? I've created a 4 level hierarchy using DAX and was expecting to be able to drag this into a report but it doesnt show in the report view.
@CurbalEN
5 жыл бұрын
Best way to get support is to contact the power bi community (community.powerbi.com). Make sure you post as much info as possible. /Ruth
@rajibmahmud19
6 жыл бұрын
hi Ruth, thanks for the video. Would you be able to share the PBI file. For some reason I am unable to download the file from the link you shared.
@CurbalEN
6 жыл бұрын
Oh, it is probably broken. I will fix it tomorrow! /Ruth
@rajibmahmud19
6 жыл бұрын
Thanks
@CurbalEN
6 жыл бұрын
It is working, can you please try again? /ruth
@sauravsinha6939
2 жыл бұрын
Can you please explain as how to use this relationship in Viz and show some meaningful presentations
@shivamsince91
5 жыл бұрын
Ruth, it's amazing. Just want to know, how can we implement security on these hierarchical things.
@CurbalEN
5 жыл бұрын
Mmmm that is a question for the Power Bi Community. Make sure you post as many details as possible of your data and model. /Ruth
@devidodge
5 жыл бұрын
Thanks Ruth, how can we apply this to a 4 level hierarchy?
@CurbalEN
5 жыл бұрын
You should, but post the details of your case in the Power bi Community (Community.powerbi.com) to get detailed help. /Ruth
@dylanfan9746
6 жыл бұрын
Hello Ruth, Thank you for your awesome DAX Fridays! video series and other intermediate Power BI videos, keep them coming! I have a question regarding Hierarchy which I can't wrap my head around. Hopefully you, or anyone in the Power BI community, could help me understand this. I can see how powerful utilizing Hierarchy could help in modelling data better and providing a fast and efficient way of retrieving data with DAX. (Especially when dealing with BOM data sets) However, I have confusion over how hierarchy works over these 3 videos: 1) Creating and working with hierarchies in Power BI (3-11g): kzitem.info/news/bejne/0m6Nqol3ooZ4mIo 2) Create Hierarchies in Power Query: kzitem.info/news/bejne/0HuFx6WvmoyFjaw 3) DAX Fridays! #20: Parent and Child Functions -Hierarchies: This Video. My confusions are: 1) Does all the above 3 videos provide the same outcome, just with different methods? If so, wouldn't (1) be a simpler form of creating hierarchy groups in Data Modeling and provide filtering capabilities when using the 'CALCULATE()' function? 2) How can I use any of these above methods, create a hierarchy data model, and utilize other DAX functions such as 'RELATED()', 'RELATEDTABLE()', 'USERELATIONSHIP()' etc. in the 'CALCULATE()' function filtering ability to calculate what I want? 3) Does it mean that having Hierarchies will eliminate my need to calculate certain results because of it's dynamic data drilling down abilities? Hope that I am phrasing my question in a fathomable way. Thank you very much for your wonderful work and I am eager to receive your response on this as it definitely will tremendously help me in my work to create data models which DAX functions will shine!
@CurbalEN
6 жыл бұрын
Thanks for taking the time to write such a detailed comment! My time to answer it is unfortunately a bit limited, but think of it like this, different scenarios will require different approaches and what the Power BI team does is giving us different tools to solve them. All methods are valid depending on your situation. For a more detailed answer, I encourage you to re-post this in the power bi community where others can also chip-in. Thanks again! /Ruth
@dylanfan9746
6 жыл бұрын
Thank you Ruth for taking your time to reply my queries. I will take this up to the community. 😁
Пікірлер: 70