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.
Go to Solution.
@mohinderbabu , 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
View solution in original post
Find out who won the T-Shirt Design Challenge and the top 3 finalists.
Find out more about the March 2023 update.