Forum Discussion
Add half year to date table
Hi guys,
i have a date table with a date hiearchy. As marked in the screenshot i want to add a half year row to the date hierachie:
My date table looks like this:
How can i add the half year so i can drill down in visuals on half year basis using the date hierarchy?
Thanks already!
@HR303 , you may need to create a date table and create a custom hierarchy
https://radacad.com/power-bi-date-dimension-default-or-custom-is-it-confusing
Custom Hierarchy : https://www.youtube.com/watch?v=x6vXVJZ_eTY
3 Replies
- amitchandak
Super User
@HR303 , you may need to create a date table and create a custom hierarchy
https://radacad.com/power-bi-date-dimension-default-or-custom-is-it-confusing
Custom Hierarchy : https://www.youtube.com/watch?v=x6vXVJZ_eTY
- AnonymousNot applicable
Thank you works perfectly!
- v-easonf-msft
Community Support
Hello, @HR303
Looks like you found the solution in the video.
If so, could you mark the helpful answers as Answered?
It will help other community members easily find the solution when they receive the same problem.
Best regards
Community Support Team _ Eason