Add week ending to date hierarchy

[Anonymous]

Hi folks,

I have a date column and I would like to add Week ending to the Hierarchy, how could I achieve that?

Ex: Year - Month - Week Starting.

[amitchandak · Accepted solution]

@Anonymous , You have to create a custom Hierarchy

Week End date = 'Date'[Date]+ 7-1*WEEKDAY('Date'[Date],2)

Custom Hierarchy
https://stoneridgesoftware.com/creating-hierarchies-in-power-bi/
https://www.youtube.com/watch?v=x6vXVJZ_eTY