How to create Half Year in the date hierarchy

[vishnuprashanth]

Hi Everyone, 

How can I add "Half Year" to the date hierarchy? 

Adding Half year to date hierarchy

Any help would be highly appreciated. TIA 

[Floriankx · Accepted solution]

Hello you can add a calculated column

=YEAR([Date])&" HY "&ROUNDUP(MONTH([Date])/6)

[imtien2311]

Hi team

I got an error for the operator "&" when I put the solution in my PowerQuery:

Any ideas how I can work around it? Thaaaaaanks

[AnalystPower]

Here is an alternative to the calculation meathod. @vishnuprashanth @iamprajot @Floriankx 

Right click on you Date column... even if it is the full date  and then select new group.

Then Bin it by 6 Months 

[iamprajot]

In Visual Level Filters select what months are required.

[Floriankx · Accepted solution]

Hello you can add a calculated column

=YEAR([Date])&" HY "&ROUNDUP(MONTH([Date])/6)

[vishnuprashanth · Accepted solution]

Thanks, @Floriankx. 

I have added this custom column and also a custom date hierarchy adding this column to it. 

Just a small correction in your code, need to add 0 after the 6 for ROUNDUP.

Half Year=YEAR([Date])&" HY "&ROUNDUP(MONTH([Date])/6,0)

I create the hierarchy as shown in the solution of 
https://community.powerbi.com/t5/Desktop/Date-Hierarchy-at-Hourly-Level/td-p/210538?lightbox-message....

Thanks again @Floriankx