PowerBi & DAX - Parent Child Hierarchies (Part I)
HTML-код
- Опубликовано: 16 окт 2024
- Parent Child hierarchies are everywhere around us. In this video i show how to create deal with Parent Child Hierarchies in PowerBI / Dax (Tabular).
#dax #powerbi #powerbidesktop #tabular #data #dataanalytics
Links
DAX Functions Used
dax.guide/path/
dax.guide/path...
dax.guide/path...
dax.guide/look...
dax.guide/isin...
Hierarchy Pattern Site
www.daxpattern...
My Site
www.basensei.com
PowerBi Report
app.powerbi.co...
It is very easy to follow. Excellent presentation! You are the best!
glorious thanks!
How you only have 15 views by now is a mystery to me. Great teaching skills, great tutorial
Thank you for taking the time to both explain the type of heirarchy involved and how to show it in PBI. Much appreciated tutorial! 😊
I had to comment because I feel its unfair such a great video remains unnoticed. It was very well explained each detail of the topic, thanks a lot for the effort.
thanks man!
This is a well explained video. Glad I stumbled upon this.
This is exactly I have been looking for, thank you very much!!
Best Parent Hierarchy Tutorial 👍👍👍
Unbelievably good explantion!!! Excellent, keep up the great work man!
thanks man!
Дякую, дуже допомогли
Brilliant!
Amazing stuff
That's excellent.
Great video!!!
Great Video..
Is it ideal to have the data source already assigned the parent-child relationship between hierarchies? Additionally, if another data is added in-between a path, how would I be able to adjust the hierarchy ranking?
Hi! How was the total amount measure created ? Total amount 2 refers to it
what to do with the error that all parent values must be in id values.
and the first id cannot have it because it has no parent.
For me the Path function doesn't work otherwise, for you it surprisingly works ((
you are amazig
How was the TotalAmount Measure created?
Sir I have a hierarchy of three levels but the sum of lowest level is accurate but it is adding some values from blank to other higher levels
I got error when setting sorting each level. I created new column of Index for each level. Error showed about more than one value relation. Do you know how to fix it?
Hi I don't know how many levels will I have so can I not create hierarchy such that it takes in all column with name starting with level
Level1 =
VAR LevelNumber = 1
VAR LevelKey = PATHITEM(YOURTABLE[PATH COLUMN], LevelNumber, INTEGER)
VAR LevelName = LOOKUPVALUE(YOURTABLE[NAME], YOURTABLE[ID], LevelKey)
VAR Result = LevelName
RETURN
Result