Add half a year to the date table

[Anonymous]

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!

[v-easonf-msft]

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

[amitchandak]

@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.