cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
vishnuprashanth
Helper III
Helper III

How to create Half Year in the date hierarchy

Hi Everyone, 

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

Adding Half year to date hierarchyAdding Half year to date hierarchy

 

Any help would be highly appreciated. TIA 

2 ACCEPTED SOLUTIONS
Floriankx
Solution Sage
Solution Sage

Hello you can add a calculated column

 

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

View solution in original post

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

View solution in original post

4 REPLIES 4
AnalystPower
Helper I
Helper I

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 

 
 
 

2020-06-12_11-30-22.jpg

iamprajot
Responsive Resident
Responsive Resident

In Visual Level Filters select what months are required.
Floriankx
Solution Sage
Solution Sage

Hello you can add a calculated column

 

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

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

Helpful resources

Announcements
September Update

Check it Out!

Click here to learn more about the September 2022 updates!

Power BI Show episode 9

The Power BI Community Show

Watch the playback when Priya Sathy and Charles Webb discuss Datamarts! Kelly also shares Power BI Community updates.

Power BI Dev Camp Session 26

New Date - Check it Out!

Mark your calendars and join us on Thursday, October 6 at 11a PDT for a great session with Ted Pattison!

Top Solution Authors