Forum Discussion
Month and week on same x axis
So I looking for a solution to have a period of months and weeks on the same axis. Example, show month Jan, Feb, Mar, but April didn't end and shows the weeks of the April until April is close an...
amitchandak
Super User
Super UserTmedeiros , Create a new column in Date table
if(month([Date]) < month(Today()), year([Date]) *100 + month([Date]) , year([Date]) *100 + weeknum([Date],2) )
You can create text column to using format and mark above as sort column
Thank you amitchandak
My data is always in fiscal Year and Fiscal Week. I don't the days