Forum Discussion
Solved
Week Number Showing Twice
Hello, I have a stacked column graph that I want the X axis to show the values by month/year and then drill down into week number. The visual I created does this but at times shows the same week numb...
I was able to solve this by creating this measure and just using the date hierarchy of it, instead of separately bringing in a month and week column.
Week Start Date = DateTable[Date] - WEEKDAY(DateTable[Date],2) + 1
I was able to solve this by creating this measure and just using the date hierarchy of it, instead of separately bringing in a month and week column.
Week Start Date = DateTable[Date] - WEEKDAY(DateTable[Date],2) + 1