Forum Discussion
Add half a year to the 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 hierachie date:
My date table looks like this:
How can I add the half year so I can drill into visuals in half a year using the date hierarchy?
Thanks, now!
3 Replies
- amitchandak
Super User
Anonymous , You have to create a half year and then create a custom hierarchy
New column in the date table
Half Year =IF(Month('Date'[Date])>=7,"H2","H1")
Refer:https://www.youtube.com/watch?v=WWvVeYU0Dvw
In case you need other column : https://community.powerbi.com/t5/Webinars-and-Video-Gallery/PowerBI-Time-Intelligence-Calendar-WTD-YTD-LYTD-Week-Over-Week/m-p/1051626#M184
- Ashish_Mathur
Hi,
In the Calendar Table, add this calculated column formula
=IF(MONTH(Calendar[Date])>=7,"H2","H1")
This assumed that H2 starts from July.
- 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
