hierachy

[Anonymous]

hiii https://drive.google.com/file/d/1DR0YO-OG0QQtsKD61d_6JVKv6Szip7IF/view?usp=sharing 

can some help me to create a hierachy for call closed in query2 

i am trying to create year and month hierachy so that my dax in table column will work and display the values

[v-easonf-msft]

Hi, @Anonymous 

I am a bit confused.

Why did you create the second table“Table” and establish a relationship between the two tables based on the date field?

The visuals  you create do not need to use the fields of the table "query2" and the table "Table" at the same time, and I don't think it is necessary to create a relationship.

Best Regards,
Community Support Team _ Eason

[amitchandak · Accepted solution]

@Anonymous , refer if these links can help in creating hierarchy

https://stoneridgesoftware.com/creating-hierarchies-in-power-bi/
https://www.youtube.com/watch?v=x6vXVJZ_eTY

Yet to check the file.