I’m designing a calendar table in Power BI. I have date, year, week, week number.
I want to give users the ability to analyst by year week.
I have an option to either create the year week as a column (and year week number for sorting), or to just add the existing year and week columns into a hierarchy called year week.
Or I can do both. What is the basis to make this decision?