Forum Discussion
Anonymous
6 years agoNot applicable
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...
amitchandak
Super User
6 years agoAnonymous , 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